Remove Duplicates with Proc Sort

gsaba — Wed, 15 Aug 2018 08:07:18 GMT

Hello guys,

I need your help with a little issue here:

I had a big database, then wrote Proc Sort, with some criterias and now have this:

id date cam amount

4701      11JAN2018     1             $30.00
4701      09JAN2018     0             $30.00
16044    16JAN2018     1             $40.00
28563    30JAN2018     0             $10.00

this is the proc sort I wrote before:

proc sort data=lib.RESULT out=lib.RESULT

nodupkey; by id cam;

RUN;

the question is that now I want to add something in my proc sort to tell sas (if id is duplicated), select those values when date is smaller and 'cam' is 1. these are the priorities. how can I do that? can anobody help?

Re: Remove Duplicates with Proc Sort

RW9 — Wed, 15 Aug 2018 08:33:11 GMT

You would need two steps:

proc sort data=lib.result; 
  by id cam date;
run;
data want;
  set lib.result;
  by id;
  if first.id and cam=1;
run;

Note, I have only done this based on the test data you provided (and provided not in a datastep!!). Would need to see some actual descriptive test data in the form of a datastep and what you want to see out at the end.

topic Remove Duplicates with Proc Sort in SAS Programming

Remove Duplicates with Proc Sort

Re: Remove Duplicates with Proc Sort