"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 |
Give some examples where proc report’s defaults are different than proc print’s defaults?
Under what circumstances would you code a SELECT construct instead of IF statements?
how the sas basic syntax style described? : Sas-administrator
How would you determine the number of missing or nonmissing values in computations?
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
When merging 2 datasets with a common variable (not merge key), how to keep both?
what is sas business intelligence? : Sas-bi
what is the main difference between rename and label? (don't say that they both perform the same function).
What is the purpose of _error_?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Describe the function and untility of the most difficult SAS macro that you have written.