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

Explain data_null_?

0 Answers  


explain about sas business intelligence? : Sas-bi

0 Answers  


Explain the special input delimiters used in sas programming.

0 Answers  


How do you specify the number of iterations and specific condition within a single do loop?

0 Answers  


What are symbol tables?Differemce between Local N Global Symbol tables.....

2 Answers   TCS,


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

0 Answers  


What are the features of SAS?

0 Answers  


i have one dataset data l; input name: $ 25; cards; manoj is a good boy to krishna krishna is a god boy to malli malli is good boy to ramana ques: here i want "manoj" observations nubers

3 Answers   SAS,


What is the difference between match merge and one to one merge?

0 Answers  


sas macros

12 Answers   TCS,


What is the role of administrative users? : sas-grid-administration

0 Answers  


Can you excute a macro within a macro? Describe.

2 Answers   Genta,


Categories