topic Re: How to separate and store unique and duplicate records in two different datasets using proc sort in SAS Procedures

How to separate and store unique and duplicate records in two different datasets using proc sort

vshn — Sun, 05 Oct 2014 07:08:13 GMT

data excess;

input id n1;

cards;

10 10

10 20

10 30

10 40

10 50

;

run;

now using proc sort separate and store only unique records in dataA and all other records in dataB .

Re: How to separate and store unique and duplicate records in two different datasets using proc sort

Jagadishkatam — Sun, 05 Oct 2014 07:15:30 GMT

try

proc sort data = excess out=wantdupout=dups nodupkey;

by id n1;

run;

the want dataset have unique records and dups have all other records. Hope this helps.

Thanks,

Jagadish

Re: How to separate and store unique and duplicate records in two different datasets using proc sort

vshn — Sun, 05 Oct 2014 07:30:35 GMT

dataset want should be like this

id n1

10 10

10 30

10 50

and dataset dups

id n1

10 20

10 40

Re: How to separate and store unique and duplicate records in two different datasets using proc sort

Jagadishkatam — Sun, 05 Oct 2014 07:42:49 GMT

Thanks for providing the desired output. please try

dups dataset has duplicate records and unique will have unique records.

proc sort data=excess out=dups UNIQUEOUT= unique NOUNIQUEKEY;

by id n1;

run;

Thanks,

Jag

Re: How to separate and store unique and duplicate records in two different datasets using proc sort

art297 — Sun, 05 Oct 2014 16:45:34 GMT

I think that the following will achieve what you want:

proc sort data = excess ;

by id n1;

run;

data want dups;

set excess;

by id n1;

if first.n1 and last.n1 then output want;

else output dups;

run;

Re: How to separate and store unique and duplicate records in two different datasets using proc sort

vshn — Mon, 06 Oct 2014 06:15:46 GMT

thanks