"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 |
What is the use of divide function?
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
what is sas metadata server? : Sas-di
What are the differences between proc means and proc summary?
How many missing values are available? When might you use them?
I have a dataset with variables empid and doj how to calculate retirement age?
diff between nodup rec and ondup key???
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
How to get the repeated values by using sql in sas ?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
When you will use nowd option in report???