Proc SQL noprint; create table unique as select distinct (*) from dsn; qu

how to delete the duplicates by using proc sql?

Question Posted / shivakrishna.yenaganti

Answer Posted / shivakrishna.yenaganti

Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;

Is This Answer Correct ?

22 Yes

2 No

Please Help Members By Posting Answers For Below Questions

which date functions advances a date time or date/time value by a given interval? : Sas programming

958

explain what is data set in sas? : Sas-administrator

992

Have you ever used the SAS Debugger?

1761

explain the key concept of sas? : Sas-administrator

1007

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

1299

What versions of SAS have you used (on which platforms)?

1517

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

2126

What are the special input delimiters used in SAS?

1183

How do you use the do loop if you don’t know how many times you should execute the do loop?

1262

In ARRAY processing, what does the DIM function do?

1178

What is the maximum length of the macro variable?

1181

what are informats in sas? : Sas-administrator

1093

What is the work of tranwrd function?

1248

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1256

How to create an external dataset with sas code?

1158