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
What is the difference between %put and symbolgen? : sas-macro
how do you test for missing values? : Sas programming
Which command is used to save logs in the external file?
why is sas considered self-documenting? : Sas programming
What is the use of divide function?
How to create a permanent sas data set?
What is the basic syntax of a sas program?
Are you involved in writing the inferential analysis plan? Tables specfications?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is snowflake schema? : Sas-di
what is study design in while working with SAS? what are screening variables in SAS?
Explain the main difference between the sas procedures and functions? : Sas-administrator
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What are the new features included in the new version of SAS Programming Language?
What does P-value signify about the statistical data?