Help using Base SAS procedures

Regarding Dup key

Reply
Frequent Contributor
Posts: 90

Regarding Dup key

Hi ,

Please explain whats the main difference between dupkey and nodupkey in order to remove the duplicate records ?

Thanks in Advance !!!
Super Contributor
Super Contributor
Posts: 365

Re: Regarding Dup key

Hello Raveena,

If you talking about proc SORT it has only NODUPKEY option (to my knowlege), and this is a description:

NODUPKEY
checks for and eliminates observations with duplicate BY values. If you specify this option, then PROC SORT compares all BY values for each observation to the ones for the previous observation that is written to the output data set. If an exact match is found, then the observation is not written to the output data set.

Sincerely,
SPR
Trusted Advisor
Posts: 2,113

Re: Regarding Dup key

Raveena,

Be careful with this. NODUPKEY will not remove duplicate records; it removes records with duplicate keys. The NODUP option gets closer, but it still assumes that you have sorted by a sufficient number of keys to uniquely identify the records.

http://support.sas.com/kb/1/566.html

Doc Muhlbaier
Duke
Ask a Question
Discussion stats
  • 2 replies
  • 1299 views
  • 0 likes
  • 3 in conversation