Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26540 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
Approximately what date is represented by the SAS date value of 730?
What are the ways to do a “table lookup” in sas?
Mention the validation tools used in SAS?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what is hierarchy flattening? : Sas-di
why is sas data integration studio important? : Sas-di
what has been your most common programming mistake? : Sas programming
What is the basic syntax style in SAS?
What is the difference between the proc sql and data step?
what is hash files in sas and why we are using this one in sas?
What is the maximum length of the macro variable? : sas-macro
Tell me more about the parameters in macro? : sas-macro
how will you locate the sas platform applications? : Sas-bi
what are _numeric_ and _character_ and what do they do? : Sas programming
How will you generate test data with no input data?
