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

What is the work of tranwrd function?

1233

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

1066

Differentiate between format and informat? : sas-grid-administration

1049

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1081

how will you locate the sas platform applications? : Sas-bi

1023

how would you create multiple observations from a single observation? : Sas programming

993

In sas, what are the areas that you are most interested in? : sas-grid-administration

1062

What do you know about sas and what we do? : sas-grid-administration

1134

what is sas and what are the functions? : Sas-administrator

975

What are the data types does SAS contain?

1103

what are 5 ways to perform a table lookup in sas? : Sas-administrator

1221

How do dates work in SAS data?

1163

For what purpose would you use the RETAIN statement?

1509

what is sas metadata server? : Sas-di

1097

How we can create SAS USER DEFINED CODE?

2078