How would you delete duplicate observations?
Answer Posted / vijay
There are several ways to do this. However the easliest
code-wise is to use PROC SORT. For example:
PROC SORT DATA=mydata NODUPKEY;
BY variable;
RUN;
| Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
In SAS explain which statement does not perform automatic conversions in comparisons?
how can you put a "trace" in your program? : Sas programming
What is the difference between order and group variable in proc report?
what are the types of interactive display types? : Sas-bi
Why and when do you use proc sql?
what other sas products have you used and consider yourself proficient in using? : Sas programming
What is the maximum length of the macro variable? : sas-macro
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
If money were no object, what would you like to do?
What was the last computer book you purchased? Why?
How to limit decimal places for variable using proc means?
what are validation tools that are used in sas? : Sas-administrator
what is sas data set?
Given an unsorted data set, how to read the last observation to a new data set?
how do you debug and test your sas programs? : Sas programming