Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete observations with duplicate keys?
- 13 Answers
- 26209 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 are the table names in oracle database...?
Mention common programming errors committed in sas ?
How are numeric and character missing values represented internally?
what is sas database server? : Sas-di
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What are the special input delimiters used in SAS?
What are the prime responsibilities of data integration administrator? : Sas-di
What is the difference between reading data from an external file and reading data from an existing data set?
what are sas bi dashboard components? : Sas-bi
Differences between where and if statement?
Explain what is SAS informats?
Explain data step in SAS
How can I remove header from output data set?
Mention the difference between ceil and floor functions in sas?
What are all the problems you faced while validating tables and reports?
