Something like:
proc sort data=have out=first;
by account date;
run;
data first (keep=account rm_first);
set first (rename=(rm_original=rm_first));
by account;
if first.account;
run;
data want;
merge have first;
by account;
run;
Note, post test data in the form of a datastep in future, I am not here to type out test data, hence the above is not tested.
... View more
