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 |
how do the in= variables improve the capability of a merge? : Sas programming
What are the different servers in sas? : sas-grid-administration
Name few SAS functions?
What is a put statement?
Explain the difference between nodup and nodupkey options?
What is maximum storage capability of SAS?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?
what are the considerations when picking a SAS/STAT procedure?
0 Answers Accenture, Quintiles,
Which is the best training institute for SAS in Delhi. Please reply
proc means? proc sort? proc append? proc freq? proc print? proc content?
Explain what Proc glm does?