- proc import datafile='f:\原始数据' dbms=excel
- out=rep_data replace;
- getnames=yes;
- run;
- options linesize=256;
- proc report data=rep_data nowindows out=rep(drop=n _break_);
- column standard_a_name standard_b_name biaozhunfen=mean_biao dwmc,score score=average scoreratio n ;
- define score / analysis format=12.2;
- define average / '平均值' mean format=12.2;
- define scoreratio / '得分率' format=percent7.1;
- define dwmc /across ;
- define standard_a_name/' ' group order=data;
- define standard_b_name /' ' group order=data;
- define biaozhunfen/ group ;
- define mean_biao / analysis mean '标准得分 ' format=12.2 ;
- compute scoreratio;
- scoreratio=average/mean_biao;
- endcomp;
- compute after standard_a_name;
- standard_b_name='合计';
- mean_biao=mean_biao*n/10; */除以10因为有10个地点,这里有些勉强,但似乎找不到可以直接求和汇总的方法,
- 因为mean_biao被定义为求均值,无法在下面的break after中语句直接求和汇总/;
- average=average*n/10;
- endcomp;
- break after standard_a_name/ summarize suppress;
- rbreak after /summarize;
- compute after;
- standard_a_name='合计';
- mean_biao=mean_biao*n/10;
- average=average*n/10;
- endcomp;
- quit;
不是很完美解决,有点勉强,但数据总算是看到了的。