我希望SAS的输出结果是一个表格,包含下面的内容:
1.第一、二列是var1的各个取值和对应的frequency,记为frequency1:
proc freq data=data_set;
tables var1;
run;
2.第三列是在var2等于某值的条件下var1的各个取值对应的frequency,记为frequency2:
proc freq data=data_set(where=(var2=some_value));
tables var1;
run;
3.第四列是上面的frequency1和frequency2的比值
frequency1/frequency2
4.第五列是var1的各个取值和对应的var3的聚合:
proc sql;
select var1, sum(var3)
from data_set
group by var1;
quit;
希望用proc tabulate实现,谢谢