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
why a stop statement is needed for the point= option on a set statement?
What does proc print, and proc contents are used for?
how many display types available in sas bi dashboard? : Sas-bi
How would you identify a macro variable? : sas-macro
Mention what are the data types does SAS contain?
Differentiate input and infile.
If money were no object, what would you like to do?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is the basic structure of a sas program?
What are the default statistics that proc means produce?
what is the difference between nodup and nodupkey options? : Sas programming
explain about data integrator metadata reports? : Sas-di
what is enterprise guide? What is the use of it? : Sas programming
How will you generate test data with no input data?
What is the SAS data set?