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

[deleted_user]

Hi All,

Anybody plz help into this one with detailed example.

Thanks In Advance,

Regards,
Govind.

[sbb]

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.

[BrunoSilva]

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