how to delete the duplicates by using proc sql?
Answer Posted / shivakrishna.yenaganti
Proc SQL noprint;
create table unique as select distinct (*) from dsn;
quit;
Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
What is the difference between using drop = data set option in data statement and set statement?
how does sas handle missing values in procs? : Sas programming
how do you want missing values handled? : Sas programming
Explain input and put function?
How we can create SAS USER DEFINED CODE?
What are common programming errors committed in sas
Describe the ways in which you can create macro variables? : sas-macro
In sas, what are the areas that you are most interested in? : sas-grid-administration
What will calendar procedure do?
do you prefer proc report or proc tabulate? Why? : Sas programming
Explain data step in SAS
Intern stastical programmer written test
How do you define proc in sas? : sas-grid-administration
How to read an input file in sas?
Difference between SAS STATA & SPSS?