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 |
How do you add a prefix to some or all variables in a dataset using a SAS macro?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
What do you know about sas data set?
what is syntax of proc merge ?
what is sas? is a package or tool? give me introduction about sas?
What are the automatic variables for macro? : sas-macro
what is data access? : Sas-di
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
what is the primary variable in your study?
What is the difference between SAS functions and procedures?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.