How would you delete duplicate observations?
Answer Posted / poornima
we can delete duplicate observations by using nodup or
nodupkey option in the proc sort
Example :-
Proc sort data=datasetname nodup;
run;
Is This Answer Correct ? | 33 Yes | 12 No |
Post New Answer View All Answers
If a variable contains letters or special characters, can it be numeric data type?
What is the use of stop statement?
Explain why double trailing @@ is used in input statement?
What are the advantages of using sas?
Describe a time when you were really stuck on a problem and how you solved it?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
Can you execute macro within another macro? : sas-macro
What is the difference between nodupkey and nodup options?
What’s the difference between var b1 – b3 and var b1 — b3?
Explain the purpose of substr functions in sas programming.
What is the function of output statement in a SAS Program?
what is star schema? : Sas-di
for what purpose would you use the retain statement? : Sas programming
how many types prompting framework can be broken down to? : Sas-bi
Difference between informat and format?