Interested to Buy Any Domain ? << Click Here >> for more details...
"What is the difference between proc sort nodup and proc
sort nodupkey?"
- 2 Answers
- 6906 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 |
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
Do you need to rearrange the order of the data for the report?
what is option year cuttoff in sas
how can u extract,transform and loading?
how to import XTP files into SAS datasets?
1 Answers Barclays, Institute For Plasma Research,
What Proc glm does?
how to rearrange the data as our wish by using dataset block?
How would you combine 3 or more tables with different structures?
How many versions came upto now in SAS?
Explain the message 'Merge has one or more datasets with repeats of by variables'.
In SAS how to read the variable values having different formats. eg:mar99,mar1999 (in a single variable)
8 Answers GSK GlaxoSmithKline,
what are the differences between proc report and proc tabulate?
Teradata 
