Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26630 Views
- Accenture, I also Faced
- E-Mail Answers
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
Have you ever used the SAS Debugger?
what is the purpose of _error_? : Sas programming
What system options would you use to help debug a macro? : sas-macro
Describe the ways in which you can create macro variables?
In ARRAY processing, what does the DIM function do?
What is the good sas programming practices for processing large data sets?
What is the difference between match merge and one to one merge?
explain what is factor analysis? : Sas-administrator
State the difference between INFORMAT and FORMAT ?
What are the difference between ceil and floor functions in sas?
What is SAS? What are the functions does it performs?
Can you execute macro within another macro? : sas-macro
what is the primary data source for the wrs? : Sas-bi
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is SAS OPTIMIZATION?
