topic Regarding Dup key in SAS Procedures

Regarding Dup key

raveena — Wed, 20 Apr 2011 20:26:35 GMT

Hi ,

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

Thanks in Advance !!!

Re: Regarding Dup key

SPR — Wed, 20 Apr 2011 20:53:07 GMT

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

Re: Regarding Dup key

Doc_Duke — Wed, 20 Apr 2011 21:08:44 GMT

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