PROC SORT NODUP

[SASPhile]

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 ?

[art297 · Accepted solution]

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

[SASPhile]

Exactly!

[Reeza]

Please mark the question answered.