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
What are the five ways to do a table lookup in sas? : sas-grid-administration
what is data access? : Sas-di
explain what is factor analysis? : Sas-administrator
What are the features of SAS?
What is proc sort?
What is the difference between input and infile statement?
What is the function of Stop statement in a SAS Program?
what is study design in while working with SAS? what are screening variables in SAS?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
What is your favorite all time computer book? Why?
explain the function of substr in sas? : Sas-administrator
what is information maps?
What is the difference between %local and %global? : sas-macro
what are the considerations when picking a SAS/STAT procedure?