data have;
input UniqueID $ tier disc min_amt max_amt ;
cards;
A1 5 28 1278 2055
A1 4 25 849 1295
A1 3 25 545 794
A1 2 20 369 520
A1 1 19 320 320
B2 5 28 724 1179
B2 4 25 627 859
B2 3 25 456 691
B2 2 20 353 470
B2 1 19 332 332
;
data want;
merge have have(keep=UniqueID max_amt rename=(UniqueID=_UniqueID max_amt=_max_amt) firstobs=2);
if UniqueID=_UniqueID then adj_amt_min=max(min_amt,_max_amt);
drop _UniqueID _max_amt;
run;
... View more
