请问:如何用ods将proc freq 生成的两个out数据集(count 与 chisq)合并成指定格式的文件?谢谢!
指定的格式为:
数据文件名称 |
a1
|
a2
|
b1
|
b2
|
卡方值
|
P值
|
a.txt |
6
|
30
|
1
|
29
|
|
|
a2.txt |
|
|
|
|
|
|
… |
|
|
|
|
|
|
a1表示a组阳性例数,a2表示a组阴性例数;b1表示b组阳性例数,b2表示b组阴性例数
具体程序如下:
data a;
input var1 var2;
cards;
6 36
1 30
;
run;
data a_(keep=var);
set a;
var1_=var2-var1;
var=var1; output;
var=var1_; output;
run;
data aa;
do group = 1 to 2;
do r = 1 to 2;
output;
end;
end;
run;
data a_1;
merge aa a_;
run;
proc freq data=a_1;
weight var;
tables group*r/expected chisq out=count(keep=count) exact;
output out=chisq(drop=df_pchi) pchi;
run;