→ ckborn:把上篇改成全用merge作而已 11/15 16:06
※ 編輯: ckborn 來自: 140.128.142.244 (11/17 14:01)
data A;
input name$ chi eng;
cards;
a1 50 70
a2 30 60
a3 40 50
run;
proc sort data=A;
by name;
data B;
input name$ chi eng his bio;
cards;
a4 50 70 80 75
a6 30 60 70 66
a5 40 50 60 65
run;
proc sort data=B;
by name;
data C;
input name$ his bio;
cards;
a3 66 57
a2 55 78
a1 78 98
run;
data d;
merge A C;
by name;
data e;
merge B d;
by name;
ave=(chi+eng+his+bio)/4;
run;
proc means;
run;
proc print data=e;
run;
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.128.137.154