1# douweifeng

data fuzhi;
input month hiprc loprc;
cards;
1 10000 1000
2 20000 2000
3 30000 3000
1 11000 1100
2 22000 2200
3 33000 3300
1 11100 1110
2 22200 2220
3 33300 3330
;
run;

proc means data=fuzhi max;
class month;
var hiprc;
output out=out1(drop=_:) max=maximum;
run;
proc means data=fuzhi min;
class month;
var loprc;
output out=out2(drop=_:) min=minimum;
run;
data result;
merge out1 out2;
by month;
if month=. then delete;
range=maximum-minimum;
proc print data=result noobs;
run;

data x;
input month hiprc loprc;
cards;
1 230 90
1 240 67
2 340 69
2 490 23
;run;
proc sql;create table final as  select distinct(month), max(hiprc)-min(loprc) as chazhi from x group by month;quit;

看来还得深挖SQL啊

简化点儿：