"What is the difference between proc sort nodup and proc
sort nodupkey?"
- 2 Answers
- 6535 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 |
is QUALCOMM using SAS ?
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
explain the proc in sas? : Sas-administrator
I need level 2 to 5 sas using companies in india
How do you add a number to a macro variable?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
what is incremental update ? is this possible in SAS OLAP CUBE STUDIO.
Which date function advances a date, time or datetime value by a given interval?
What are the joins,types of joins and thier functions?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
how do you test for missing values? : Sas programming
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
Teradata 
