How would you delete observations with duplicate keys?
Answer Posted / g.jyotshna
proc sort data=datasetname nodup;
by var;
run;
proc sort data=datasetname nodupkey;
by var;
run;
proc sort data=datasetname noduprecs;
by var;
run;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
Explain the difference between using drop = data set option in set and data statement?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
Difference between nodup and nodupkey options?
For clinical entire study how many tables will create approx?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
Mention what is SAS data set?
: and & modifiers.
What is the difference between nodupkey and nodup options?
Tell me about % include and % eval? : sas-macro
What are the parameters of scan function?
Mention the difference between ceil and floor functions in sas?
Enlist the syntax rules followed in sas statements.
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
what are the types of interactive display types? : Sas-bi