how to delete the duplicates by using proc sql?

Question Posted / ram

Answers were Sorted based on User's Feedback

how to delete the duplicates by using proc sql?..

Answer / shivakrishna.yenaganti

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

Is This Answer Correct ?

22 Yes

2 No

how to delete the duplicates by using proc sql?..

Answer / arpit

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

Is This Answer Correct ?

6 Yes

0 No

how to delete the duplicates by using proc sql?..

Answer / chowdary

In constraints time using unique
In datasets using distinct()

Is This Answer Correct ?

1 Yes

0 No

More SAS Interview Questions

what is the difference between unique key and primary key? : Sas-di

What is connection profile? : sas-grid-administration

what does .. meant in sas macros

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?

How do you read in the variables that you need?

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

Give some examples where proc report’s defaults are same as proc print’s defaults?

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

/* To determine the maximum and minimum of V1 */ data before3; input v1 v2 v3; cards; 3 2 1 4 6 5 2 1 3 6 5 4 1 3 2 5 4 6 ; run;

what are the sites did u refer for enquiries and doubts for SAS

i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?

What has been your most common programming mistake?

For more SAS Interview Questions Click Here