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


Please Help Members By Posting Answers For Below Questions

If a variable contains letters or special characters, can it be numeric data type?

1009


What is the use of stop statement?

854


Explain why double trailing @@ is used in input statement?

829


What are the advantages of using sas?

882


Describe a time when you were really stuck on a problem and how you solved it?

2440


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

1863


Can you execute macro within another macro? : sas-macro

762


What is the difference between nodupkey and nodup options?

819


What’s the difference between var b1 – b3 and var b1 — b3?

1077


Explain the purpose of substr functions in sas programming.

823


What is the function of output statement in a SAS Program?

834


what is star schema? : Sas-di

879


for what purpose would you use the retain statement? : Sas programming

839


how many types prompting framework can be broken down to? : Sas-bi

865


Difference between informat and format?

871