"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
Did you used proc test? when?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
which date function advances a date, time or datetime value by a given interval? : Sas programming
What’s the difference between var b1 – b3 and var b1 — b3?
What is the difference between match merge and one to one merge?
how the sas basic syntax style described? : Sas-administrator
what is the difference between nodup and nodupkey options? : Sas programming
Mention sas system options to debug sas macros.
AE datasets names? how many types?
how would you create multiple observations from a single observation? : Sas programming
What are types of transport files?
What areas of SAS are you most interested in?
What is the difference between INPUT and INFILE ?
How to limit decimal places for the variable using proc means?
what are the considerations when picking a SAS/STAT procedure?