"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 your favorite all time computer book? Why?
What makes sas stand out to be the best over other data analytics tools?
Explain what is SAS informats?
why a stop statement is needed for the point= option on a set statement?
Tell e how how dealt with..
Explain how you can debug and test your SAS program?
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?
Tell me more about the parameters in macro? : sas-macro
In ARRAY processing, what does the DIM function do?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What is the maximum length of the macro variable?
what is sas enterprise intelligence architecture? : Sas-bi
Give e an example of..
What are the default statistics that proc means produce?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di