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 can you code the confidence intervals?
6 Answers Cytel, IIT, Ranbaxy,
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
What are the data types in sas?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
what is data integration? : Sas-di
what is option year cuttoff in sas
Where do you use proc means over proc freq?
what is p-value
3 Answers Accenture, Quintiles, Sristek,
how to change the execute of macro
What is the difference between SAS Data step and SAS PROC SQL, and which is better?