"What is the difference between proc sort nodup and proc
sort nodupkey?"
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 would you determine how far down on a page you have printed in order to print out footnotes?
what is business intelligence? : Sas-bi
What's the difference between VAR A1 - A4 and VAR A1 - A4?
What is the length assigned to the target variable by the scan function?
Name statements that function at both compile and execution time?
What is the difference between the proc sql and data step?
Mention few capabilities of sas framework.
What is the difference Using & and && in the macro variables
what is the difference between proc means and proc summary?
How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?
how can you improve the performance of a query, If it is excuting very slowly?
Can you suggest us materials for sdtm mapping?