How would you delete observations with duplicate keys?

Answers were Sorted based on User's Feedback



How would you delete observations with duplicate keys?..

Answer / serena

proc sort data= nodupkeys;
by variable;
run;

Is This Answer Correct ?    2 Yes 2 No

How would you delete observations with duplicate keys?..

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 would you delete observations with duplicate keys?..

Answer / amit

Using a command nodupKey in Proc sort statement

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

what is transformation in sas data integration? : Sas-di

0 Answers  


There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?

1 Answers   Oracle,


What are the features of base sas system?

0 Answers  


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  


What are the efficacy variables in your study?

2 Answers   Accenture, Quintiles,






Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation

1 Answers   SAS,


why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,


What are the applications primarily used by business analyst? : Sas-bi

0 Answers  


what is the difference between informat$8. $char8.

3 Answers   SAS,


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

0 Answers   SAS,


what is information maps?

0 Answers   CitiGroup,


What is factor analysis?

0 Answers  


Categories