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

how do you debug and test your sas programs? : Sas programming

0 Answers  


What is the difference between where and if statement?

0 Answers  


You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  


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

0 Answers  


What are the difference between sas functions and procedures?

0 Answers  


how can you get the single data set from the library(which has the number of data sets)?

3 Answers   Accenture, Deloitte,


For what purpose would you use the RETAIN statement?

0 Answers   Quintiles,


How will you generate test data with no input data?

0 Answers  


do you prefer proc report or proc tabulate? Why? : Sas programming

0 Answers  


Briefly describe 5 ways to do a "table lookup" in sas.

4 Answers   Quintiles,


SAS using companies in chennai

1 Answers  


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers  


Categories