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 add a prefix to some or all variables in a dataset using a SAS macro?

2 Answers  


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

2 Answers   Accenture,


What do you know about sas data set?

0 Answers  


what is syntax of proc merge ?

7 Answers   TCS,


what is sas? is a package or tool? give me introduction about sas?

11 Answers   Accenture,


What are the automatic variables for macro? : sas-macro

0 Answers  


what is data access? : Sas-di

0 Answers  


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

0 Answers   Accenture,


what is the primary variable in your study?

3 Answers   Accenture,


What is the difference between SAS functions and procedures?

0 Answers  


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

0 Answers  


I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.

4 Answers  


Categories