"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 are the differences between proc means and proc summary?
where will go the observations that were deleted by delete statement?
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
If you have a data set that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variable?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Baseline definition in your study
3 Answers Accenture, Quintiles,
Describe the function and utility of the most difficult SAS macro that you have written?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What are common programming errors committed in sas
Which date functions advances a date time or date/time value by agiven interval?