我在使用proc means过程之后,想提取结果中的mean 怎么用以下code无法实现:希望高人指点下:
proc means data=a;
var r r1-r9;
by code;
output out=meana;
run;
data mean;
set meana;
where _STAT_="mean";
run;
其中A是一个有数据的数据集。
proc sql;
create table aa as
select sum(case when v1=1 then 1 else 0 end)/count(*) as v1_1_per
,sum(case when v2=1 then 1 else 0 end)/count(*) as v2_1_per
from a;
quit;