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
Explain what is SAS informats?
what are the benefits of data integration? : Sas-di
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;
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
How can I remove header from output data set?
Explain the main difference between the sas procedures and functions? : Sas-administrator
what is program data vector? : Sas-administrator
What are the data types does SAS contain?
What are the implications?
why a stop statement is needed for the point= option on a set statement?
How is character variable converted into numeric variable and vice versa?
What is a method to debug and test your SAS program?
Describe what are the different levels of administrative users in sas? : sas-grid-administration
What is the use of function Proc summary?
Give an example where SAS fails to convert character value to numeric value automatically?