topic Re: PROC SORT NODUP in SAS Programming

PROC SORT NODUP

SASPhile — Mon, 22 May 2017 20:13:52 GMT

i have datasets that have 30 columns. I would like clean up datasets by removing dulplicates using _all_ and redirect the duplicate records to another dataset.

proc sort data=have nodupkey out=_duprecs;

by _all_;

run;

this code doesnt seem to do what I want.

any help on this ?

Re: PROC SORT NODUP

art297 — Mon, 22 May 2017 20:19:47 GMT

Is the below what you are trying to do?:

data class (drop=i);
  set sashelp.class;
  do i=1 to 5;
    output;
  end;
run;

proc sort data=class nodupkey out=dups_removed dupout=_duprecs;
  by _all_;
run;

Art, CEO, AnalystFinder.com

Re: PROC SORT NODUP

SASPhile — Mon, 22 May 2017 20:24:25 GMT

Exactly!

Re: PROC SORT NODUP

Reeza — Mon, 22 May 2017 21:50:55 GMT

Please mark the question answered.