"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 limit of the number of the rows and columns available in the worksheet? : Sas-bi
What is the use of stop statement?
Does anybody has lastest SAS certification dumps,if anybody has please mail me on saggydesai@gmail.com
what are all the ways to define macro variable??
2 Answers GSK GlaxoSmithKline,
How to convert .xls file into CSV format?
Do you know the features of sas?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
How to read an input file in sas?
Difference b/n proc means and proc summary procedures?
What does P-value signify about the statistical data?
How do you delete duplicate observations in sas?