Interested to Buy Any Domain ? << Click Here >> for more details...
"What is the difference between proc sort nodup and proc
sort nodupkey?"
- 2 Answers
- 7059 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
How do you put an elephant in the refrigerator?
What are the different versions of sas that you have used until now? : sas-grid-administration
Briefly describe 5 ways to do a "table lookup" in sas.
In sas admin differentiate between roles and capabilities? : sas-grid-administration
how to do user inputs and command line arguments in sas?
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?
how to remove duplicates using proc sql?
Which is the best training institute for SAS in Delhi. Please reply
Write a SAS macro to calculate number of numbers in an email address
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?
What is difference between Global n Local Macro Variables..?
Teradata 
