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


"What is the difference between proc sort nodup and proc
sort nodupkey?"

Answers were Sorted based on User's Feedback



"What is the difference between proc sort nodup and proc sort nodupkey?"..

Answer / chandrakanth

Proc sort nodupkey will remove any repeated observations based on by variable you mention in the proc sort, whereas proc sort nodup will remove all the repeated observation irrespective of the mentioned by variable . Hope this answers your question let me know if you need more details.

Is This Answer Correct ?    4 Yes 0 No

"What is the difference between proc sort nodup and proc sort nodupkey?"..

Answer / venkatesh

nodup: it deletes duplicates(column wise duplicates).
nodupkey: it deletes row wise duplicates according to
your by variable;
ex: id name
100 nani
101 ravi
100 nani
101 kali
nodup result:
id name
100 nani
101 ravi
101 kali

nodupkey result
100 nani
101 ravi

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SAS Interview Questions

How do you put an elephant in the refrigerator?

6 Answers   Oracle,


What are the different versions of sas that you have used until now? : sas-grid-administration

0 Answers  


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

4 Answers   Quintiles,


In sas admin differentiate between roles and capabilities? : sas-grid-administration

0 Answers  


how to do user inputs and command line arguments in sas?

0 Answers   D&B, TCS,


If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

4 Answers  


how to remove duplicates using proc sql?

0 Answers  


Which is the best training institute for SAS in Delhi. Please reply

12 Answers   HCL, HSBC,


Write a SAS macro to calculate number of numbers in an email address

2 Answers  


How to read multiple excel sheets from a single excel file at once????

7 Answers   HCL, Verinon Technology Solutions,


How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  


What is difference between Global n Local Macro Variables..?

6 Answers   TCS,


Categories