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

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1103


what are 5 ways to perform a table lookup in sas? : Sas-administrator

995


how to do user inputs and command line arguments in sas?

2674


Do you need to know if there are any missing values?

806


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

780


What are the applications primarily used by business analyst? : Sas-bi

776


Name any two sas spawners? : sas-grid-administration

785


What do you know about sas and what we do? : sas-grid-administration

811


Give an example where SAS fails to convert character value to numeric value automatically?

847


What is the basic syntax style in SAS?

844


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

815


Explain what is the use of proc gplot?

914


Mention the category in which sas informats are placed?

807


If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

827


What is program data vector (pdv)?

848