Help using Base SAS procedures

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

Reply
N/A
Posts: 0

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

Hi All,

Anybody plz help into this one with detailed example.

Thanks In Advance,

Regards,
Govind.
Super Contributor
Super Contributor
Posts: 3,174

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

Posted in reply to deleted_user
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.
Contributor
Posts: 50

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

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 2 replies
  • 120 views
  • 0 likes
  • 3 in conversation