變量觀察值之和做除法

我的數(shù)據(jù)是按班分類身高體重的信息，我想按班級(jí)分類，求出每個(gè)班級(jí)體重總和除以身高總和的值，我想只顯示計(jì)算結(jié)果，請(qǐng)問怎么做？hight weight class id
156 51 Amber Chem101
156 52 Amber Math102
156 52 Amber Math102
167 54 Denise ENGL201
167 55 Denise ENGL201
145 56 Ginny CHEM101
145 57 Ginny ENGL201
145 58 Ginny MATH102
134 59 Lynn CHEM101
134 60 Lynn CHEM101
134 61 Lynn MATH102
178 62 Rick CHEM101
178 63 Rick HIST300
178 64 Rick HIST300


就是最后結(jié)果只顯示amber類別里的hight之和除以weight之和的值等等。非常感謝！

data have;
input height weight class $ id $;
cards;
156 51 Amber Chem101
156 52 Amber Math102
156 52 Amber Math102
167 54 Denise ENGL201
167 55 Denise ENGL201
145 56 Ginny CHEM101
145 57 Ginny ENGL201
145 58 Ginny MATH102
134 59 Lynn CHEM101
134 60 Lynn CHEM101
134 61 Lynn MATH102
178 62 Rick CHEM101
178 63 Rick HIST300
178 64 Rick HIST300
;
proc sql;
select class,sum(weight)/sum(height) as rate from have group by class;
quit;

beijingdizheng 發(fā)表于 2013-9-18 09:05
data have;
input height weight class $ id $;
cards;

太感謝了！能不能再請(qǐng)教個(gè)問題，我想把下面的觀測(cè)值中height相同且weight為0的觀測(cè)值刪除（即第二條觀測(cè)值）刪除后，再做上面的操作，請(qǐng)問用怎么實(shí)現(xiàn)呢？
height weight class id
156 51 Amber Chem101
156 0 Amber Math102
156 52 Amber Math102
167 54 Denise ENGL201
168 0 Denise ENGL201
145 56 Ginny CHEM101
145 57 Ginny ENGL201
145 58 Ginny MATH102
134 59 Lynn CHEM101
134 60 Lynn CHEM101
134 61 Lynn MATH102
178 62 Rick CHEM101
178 63 Rick HIST300
178 64 Rick HIST300

data have;
input height weight class $ id $;
cards;
156 51 Amber Chem101
156 0 Amber Math102
156 52 Amber Math102
167 54 Denise ENGL201
168 0 Denise ENGL201
145 56 Ginny CHEM101
145 57 Ginny ENGL201
145 58 Ginny MATH102
134 59 Lynn CHEM101
134 60 Lynn CHEM101
134 61 Lynn MATH102
178 62 Rick CHEM101
178 63 Rick HIST300
178 64 Rick HIST300
;
proc sort data=have;
by height descending weight;
run;
data want;
set have;
by height descending weight;
if first.height then total=0;
total+1;
if weight=0 and total>1 then delete;
run;
proc sql;
select class,sum(height)/sum(weight) as rate from want group by class;
quit;

beijingdizheng 發(fā)表于 2013-9-18 11:59
data have;
input height weight class $ id $;
cards;

非常感謝！還希望以后跟著大師們多多學(xué)習(xí)呀！

beijingdizheng 發(fā)表于 2013-9-18 11:59
data have;
input height weight class $ id $;
cards;

真是不好意思，我能不能再問個(gè)問題，比如下面的數(shù)據(jù)，我想計(jì)算weight的和，但是weight和height的相等觀測(cè)值，只統(tǒng)計(jì)一次（如第一條和第二、三條觀測(cè)值只計(jì)算一次），請(qǐng)問怎么操作
height weight class id
156 51 Amber Chem101
156 51 Amber Math102
156 51 Amber Math102
167 54 Denise ENGL201
168 0 Denise ENGL201
145 56 Ginny CHEM101
145 57 Ginny ENGL201
145 58 Ginny MATH102
134 59 Lynn CHEM101
134 60 Lynn CHEM101
134 61 Lynn MATH102
178 62 Rick CHEM101
178 63 Rick HIST300
178 64 Rick HIST300

data have;
input height weight class $ id $;
cards;
156 51 Amber Chem101
156 51 Amber Math102
156 51 Amber Math102
167 54 Denise ENGL201
168 0 Denise ENGL201
145 56 Ginny CHEM101
145 57 Ginny ENGL201
145 58 Ginny MATH102
134 59 Lynn CHEM101
134 60 Lynn CHEM101
134 61 Lynn MATH102
178 62 Rick CHEM101
178 63 Rick HIST300
178 64 Rick HIST300
;
proc sort data=have out=want nodupkey;
by height weight;
run;
proc sql;
select sum(weight) from want;
quit;

beijingdizheng 發(fā)表于 2013-9-18 17:38
data have;
input height weight class $ id $;
cards;

實(shí)在是太感謝了！

crazy119 發(fā)表于 2013-9-21 08:57
實(shí)在是太感謝了！

大師。。。能不能再麻煩你個(gè)事。。。我想在計(jì)算的時(shí)候分兩級(jí)組，就是在class這一組里面計(jì)算每個(gè)id的weight之和，請(qǐng)問怎么操作？多謝大師�。�！

crazy119 發(fā)表于 2013-9-21 16:31
大師。。。能不能再麻煩你個(gè)事。。。我想在計(jì)算的時(shí)候分兩級(jí)組，就是在class這一組里面計(jì)算每個(gè)id的weigh ...

你這樣大師會(huì)不高興的，你直接給他做好了。