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 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

0 Answers  


how can u import .csv file in to SAS?tell Syntax?

7 Answers   CitiGroup, Franklin Templeton,


What are the data types in sas?

0 Answers  


For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

0 Answers  


what is data integration? : Sas-di

0 Answers  


what is option year cuttoff in sas

2 Answers   L&T,


Where do you use proc means over proc freq?

0 Answers  


what is p-value

3 Answers   Accenture, Quintiles, Sristek,


how to change the execute of macro

0 Answers   Mind Tree,


What is the difference between SAS Data step and SAS PROC SQL, and which is better?

1 Answers   TCS,


Categories