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
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
what are 5 ways to perform a table lookup in sas? : Sas-administrator
how to do user inputs and command line arguments in sas?
Do you need to know if there are any missing values?
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
What are the applications primarily used by business analyst? : Sas-bi
Name any two sas spawners? : sas-grid-administration
What do you know about sas and what we do? : sas-grid-administration
Give an example where SAS fails to convert character value to numeric value automatically?
What is the basic syntax style in SAS?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
Explain what is the use of proc gplot?
Mention the category in which sas informats are placed?
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
What is program data vector (pdv)?