I am trying to find the max/min value of certain variables and the associated product of that max/min value account.
Have:
cust_id
account
prod
limit
balance
111
1234
A
10,000
500
111
5678
B
20,000
1,000
111
2345
C
3,000
2,000
111
6789
B
2,000
3,000
222
4321
A
1,000
2,000
222
8765
A
4,000
1,000
222
7654
C
6,000
5,000
Want:
cust_id
max_lmt
prod_max_lmt
min_bal
prod_min_bal
111
20,000
B
500
A
222
6,000
C
1,000
A
I could use a few data steps to achieve that, but are there any efficient way? Thanks in advance.
/****get max_lmt prod_max_lmt****/
proc sort data=have;
by cust_id limit;
run;
data have1(keep=cust_id prod limit rename=(limit=max_lmt prod=max_prod_lmt));
set have;
by cust_id limit;
if last.cust_id;
run;
... View more