Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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 the difference between %local and %global?

1 Answers  


what is factor analysis? : Sas-administrator

0 Answers  


How do you connect the desktop application to metadata server? : sas-grid-administration

0 Answers  


Explain append procedure?

0 Answers  


what are _numeric_ and _character_ and what do they do? : Sas programming

0 Answers  


How do handle working under pressure?

1 Answers   Oracle, Wipro,


What are the efficacy variables in your study?

2 Answers   Accenture, Quintiles,


why is a stop statement needed for the point=option on a set statement? : Sas programming

0 Answers  


What is the difference between proportion and average?

0 Answers   KPMG,


What is the difference between SAS functions and procedures?

0 Answers  


What are the data types that sas contain?

0 Answers  


Name statements that are recognized at compile time only?

6 Answers  


Categories