"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
what is metadata? : Sas-bi
How does the internal authentication work in sas? : sas-grid-administration
What does P-value signify about the statistical data?
What are the parameters of scan function?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
how can you put a "trace" in your program? : Sas programming
what is the difference between floor and ceil functions in sas? : Sas-administrator
What would you change about your job?
Name types of category in which SAS Informats are placed?
how does sas handle missing values in formats? : Sas programming
what is the purpose of _error_? : Sas programming
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
describe about physical data integration? : Sas-di
What is the role of sas grid administrator? : sas-grid-administration
Mention what is PROC in SAS?