topic Re: Need to Help How do we'll identify duplicate rows with dupout in proc sort in SAS Procedures

Need to Help How do we'll identify duplicate rows with dupout in proc sort

deleted_user — Sat, 13 Dec 2008 06:34:50 GMT

Hi All,

Anybody plz help into this one with detailed example.

Thanks In Advance,

Regards,
Govind.

Re: Need to Help How do we'll identify duplicate rows with dupout in proc sort

sbb — Sat, 13 Dec 2008 14:44:45 GMT

The SAS support website http://support.sas.com/ has technical papers and DOC references. You can find related information by using the SEARCH facility at the main support page. The search argument I chose was "proc sort dupout example" -- the search results included matches for documentation and SUGI/SGF user community technical papers, with examples.

Also the archives for the discussion forums is also a good reference source.

Scott Barry
SBBWorks, Inc.

Re: Need to Help How do we'll identify duplicate rows with dupout in proc sort

BrunoSilva — Sat, 13 Dec 2008 15:56:21 GMT

Hi

This is my example, i sort by region and subsidiary and i get one table without duplicated keys and another with the duplicates.

proc sort data=sashelp.shoes out=tablenodup dupout=tabledup nodupkey;
by region Subsidiary;
run;

But imagine that you just want to remove the observations that have all variables equal you can do like this

proc sort data=sashelp.shoes out=tablenodup dupout=tabledup nodupkey;
by _all_;
run;

See the above link for more info
http://support.sas.com/kb/24/626.html

i hope this help you,

cheers bruno