Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26920 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
what is hash files in sas and why we are using this one in sas?
What would be the value of month at the end of data step execution and how many observations would be there?
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 your favorite all time computer book? Why?
how the sas basic syntax style described? : Sas-administrator
What is the work of tranwrd function?
Describe the ways in which you can create a macro variable?
what is treatment emergent events and treatment emregent adverse event
what is sas metadata repository? : Sas-bi
Explain input and put function?
How to sort in descending order?
Name types of category in which SAS Informats are placed?
How would you invoke a macro? : sas-macro
what is the function of catx syntax? : Sas-administrator
Differentiate between ceil and floor functions.
