"What is the difference between proc sort nodup and proc
sort nodupkey?"
Answer Posted / 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 |
Post New Answer View All Answers
How to limit decimal places for the variable using proc means?
What does proc print, and proc contents are used for?
what is the use of sas management console? : Sas-di
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Describe the ways in which you can create a macro variable?
What are the limitations for memory allocation for SAS variables
what versions of sas have you used (on which platforms)? : Sas programming
explain what is data set in sas? : Sas-administrator
Explain how merging helps to combine data sets.
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
How can I remove header from output data set?
Name types of category in which SAS Informats are placed?
What is SAS? What are the functions does it performs?
what is the purpose of _error_? : Sas programming
How to sort in descending order?