how to delete the duplicates by using proc sql?
Answers were Sorted based on User's Feedback
Answer / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
Is This Answer Correct ? | 22 Yes | 2 No |
Answer / arpit
proc sql;
select distinct (*) from sasuser.xyz;
quit.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / chowdary
In constraints time using unique
In datasets using distinct()
Is This Answer Correct ? | 1 Yes | 0 No |
what is OLAP?
Describe the function and untility of the most difficult SAS macro that you have written.
What are the five ways to do a table lookup in sas? : sas-grid-administration
what is pdv? how it is related to input buffer in sas?
what is the need of INDEX in datasets?
what is metadata? : Sas-bi
You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
What data sets do you need to produce the report?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
How does proc sql work?
Can we replace a dataset into view?
What are the ways to do a “table lookup” in sas?