Interested to Buy Any Domain ? << Click Here >> for more details...
"What is the difference between proc sort nodup and proc
sort nodupkey?"
- 2 Answers
- 7049 Views
- I also Faced
- E-Mail Answers
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 OLAP?
Which date function advances a date, time or datetime value by a given interval?
What is the command used to find missing values?
Name types of category in which SAS Informats are placed?
What is the difference between an informat and a format? Name three informats or formats.
for whom is sas data integration studio designed? : Sas-di
How can you limit the variables written to output dataset in data step?
how can you put a "trace" in your program? : Sas programming
what is sas? is a package or tool? give me introduction about sas?
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
What are the ways in which macro variables can be created in sas programming?
what is the difference between sas and other datawarehousing languages?what are the advantages of sas over them?
Teradata 
