How would you delete observations with duplicate keys?
Answer Posted / 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 |
Post New Answer View All Answers
how does sas handle missing values in sort order? : Sas programming
what is sas olap server? : Sas-di
what are the scrubbing procedures in sas? : Sas programming
which date function advances a date, time or datetime value by a given interval? : Sas programming
What are the data types in sas?
What are the limitations for memory allocation for SAS variables
Mention how to limit decimal places for the variable using proc means?
Name few SAS functions?
How would you determine the number of missing or nonmissing values in computations?
How to include or exclude specific variables in a data set?
What are the special input delimiters used in SAS?
How you can read the variables that you need?
Name types of category in which SAS Informats are placed?
Tell e how how dealt with..
how many display types available in sas bi dashboard? : Sas-bi