shenliang_111 发表于 2012-1-11 11:33 
Run it to see if it works in your version of SAS.
data a;
input ren banji renpin $;
cards;
1 1 a
2 1 c
3 1 c
4 2 b
5 2 b
6 3 c
7 3 a
8 3 b
9 4 b
10 4 c
;
proc sql;
select *,min(renpin) as renpin_max
from a
group by banji
order by banji,ren;
quit;
ren banji renpin renpin_max
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
1 1 a a
2 1 c a
3 1 c a
4 2 b b
5 2 b b
6 3 c a
7 3 a a
8 3 b a
9 4 b b
10 4 c b