How would you delete observations with duplicate keys?
Answers were Sorted based on User's Feedback
Answer / sastechies
2 ways
1.Proc Sort with Dupkey and Noduprecs options
2.Datastep using a combination of first.var and last.var
variables...
However one common mistake one might do with Proc Sort
NoDup here is that missing all the variables in the By
statement..
Read here...
http://sastechies.blogspot.com/2009/12/common-programming-
mistake-with-proc.html
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between %local and %global?
what is factor analysis? : Sas-administrator
How do you connect the desktop application to metadata server? : sas-grid-administration
Explain append procedure?
what are _numeric_ and _character_ and what do they do? : Sas programming
How do handle working under pressure?
What are the efficacy variables in your study?
2 Answers Accenture, Quintiles,
why is a stop statement needed for the point=option on a set statement? : Sas programming
What is the difference between proportion and average?
What is the difference between SAS functions and procedures?
What are the data types that sas contain?
Name statements that are recognized at compile time only?