See below: data have;   input ID $ DATE anydtdte. REASON $ AMOUNT ;   format Date Date9.; datalines; A123 01302012 REJECT 100000 A123 01302012 REJECT 100000 A123 01302012 APPROVE 100000 A123 01312012 APPROVE 100000 B345 01312012 REJECT 400000 B345 01312012 APPROVE 400000 B345 01312012 APPROVE 300000 C567 01302012 REJECT 300000 C567 01302012 REJECT 500000 C567 01312012 REJECT 300000 D667 01302012 REJECT 300000 D667 01302012 REJECT 500000 D667 01302012 REJECT 300000 ; run; proc sort data=have;   by ID Date Reason; run; data want;   set have;   by ID Date;   if Reason='APPROVE' then output;   else if first.date and Reason='REJECT' then output; run; ... View more