"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
Explain proc sort?
what are the considerations when picking a SAS/STAT procedure?
What is the basic structure of the SAS base program?
what is function of retain statment
How can you create a macro variable with in data step? : sas-macro
What are symget and symput? : sas-macro
what are validation tools that are used in sas? : Sas-administrator
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what is slowly changing dimension? : Sas-di
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
what are the types of interactive display types? : Sas-bi
What is SAS?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Explain what is the use of proc gplot?