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?
it will become easy if uuu provide website linkssss and list of consultanciessssss
Explain bmdp procedure?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
How necessary is it to be creative in your work?
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Explain the difference between nodup and nodupkey options?
What is the purpose of trailing @ and @@? How do you use them?
For clinical entire study how many tables will create approx?
what is sas application server? : Sas-di
explain the function of substr in sas? : Sas-administrator
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
How substr function works in sas?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
name some data transformation used in sas di? : Sas-di