"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


Please Help Members By Posting Answers For Below Questions

What are the prime responsibilities of data integration administrator? : Sas-di

581


Mention what is PROC in SAS?

592


Mention the difference between ceil and floor functions in sas?

635


What does proc print, and proc contents are used for?

602


What are the different servers in sas? : sas-grid-administration

593






How do dates work in sas?

633


What are types of transport files?

6813


What is the difference between input and infile statement?

674


How do you delete duplicate observations in sas?

562


How substr function works in sas?

693


How can you create a macro variable with in data step? : sas-macro

564


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

1654


Are you involved in writing the inferential analysis plan? Tables specifications?

3471


How do you add a number to a macro variable? : sas-macro

536


What is the purpose of trailing @ and @@? How do you use them?

603