proc sql; select distinct (*) from sasuser.xyz; quit.

how to delete the duplicates by using proc sql?

Question Posted / arpit

Answer Posted / arpit

proc sql;
select distinct (*) from sasuser.xyz;
quit.

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain translate function?

1128

what is the purpose of _error_? : Sas programming

1080

What are the statements that are executed only?

1095

explain the key concept of sas? : Sas-administrator

941

what are the scrubbing procedures in sas? : Sas programming

1222

Do you need to know if there are any missing values?

993

how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

984

What is connection profile? : sas-grid-administration

1109

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1014

Mention what is PROC in SAS?

1009

what is the effect of the options statement errors=1? : Sas programming

1000

What is the difference between %put and symbolgen? : sas-macro

1158

Why and when do you use proc sql?

1180

What is interleaving in SAS?

1062

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

989