- proc import out=test file="C:\Users\mingfeng07\Desktop\数据.xls" dbms=xls replace;
- getnames=yes;
- run;
- proc sort data=test;by n r_std;run;
- proc sql;
- create table test1 as select *,sum(mv) as sum_mv,mv/calculated sum_mv as proportion label="权重" from test group by n,r_std;
- quit;