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

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1180

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

1291

What is a method to debug and test your SAS program?

1427

What is the difference between class statement and by statement in proc means?

1384

Mention the difference between ceil and floor functions in sas?

1207

What is the difference between one to one merge and match merge? Give an example.

1119

How do you specify the number of iterations and specific condition within a single do loop?

1150

explain the key concept of sas? : Sas-administrator

1045

What are the special input delimiters used in SAS?

1238

what techniques and/or procs do you use for tables? : Sas programming

1097

Explain the difference between nodup and nodupkey options?

1081

What are the difference between the sas data step and sas procs?

1244

What are the features of SAS?

1077

Can you execute macro within another macro? : sas-macro

1045

How is character variable converted into numeric variable and vice versa?

1218