"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 |
how many types of MERGE?
What does P-value signify about the statistical data?
How would you determine the number of missing or nonmissing values in computations?
What is the difference between reading data from an external file and reading data from an existing data set?
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
Describe what are the different levels of administrative users in sas? : sas-grid-administration
what is sas business intelligence? : Sas-bi
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
What are the data types that sas contain?
what is portability of sas programmes?
if x=round(26.3,10)-1 then x= how much and how explain?
How do you debug and test your SAS programs?