How would you delete observations with duplicate keys?
Answers were Sorted based on User's Feedback
Answer / 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 |
Explain data_null_?
explain about sas business intelligence? : Sas-bi
Explain the special input delimiters used in sas programming.
How do you specify the number of iterations and specific condition within a single do loop?
What are symbol tables?Differemce between Local N Global Symbol tables.....
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
What are the features of SAS?
i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers
What is the difference between match merge and one to one merge?
sas macros
What is the role of administrative users? : sas-grid-administration
Can you excute a macro within a macro? Describe.