"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 |
Define run-group processing?
How can sas program be validated?
what is business intelligence? : Sas-bi
How would you determine how far down on a page you have printed in order to print out footnotes?
how do u validate the program which u have written.
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What is the length assigned to the target variable by the scan function?
what do you mean by data staging area? : Sas-di
name some data transformation used in sas di? : Sas-di
Under what circumstances would you code a SELECT construct instead of IF statements?
I have a dataset concat having variable a b & c. How to rename a b to e & f?