【sas note】实践

data guanhui.usergroup1;
    set guanhui.usergroup;
    fee1=fee;
run;
proc format;
    value freqgroup
    low-5='1~5'
    6-10='5~10'
    11-20='10~20'
    21-40='21-40'
    41-high='>40';
run;
proc format;
    value feegroup
    low-100='1~100'
    101-200='100~200'
    201-500='200~500'
    501-1000='500-1000'
    1001-2000='1000~2000'
    2001-high='>2000';
run;
ods html file="'E:\用户消费次数及金额分组.xls";
proc tabulate data=guanhui.usergroup1;
    var fee;
    class freq fee1;
    table freq all,fee1*n*all;
    format fee1 feegroup.;
    format freq freqgroup.;
run;
ods html close;

 

原数据为号码 金额 次数三个字段，想了半天怎么能实现以金额和次数为行列的按区间统计表。

中间的种种磨难不多表

解决方案：copy复制一个金额字段，用下述代码实现--一点变通

proc tabulate data=guanhui.usergroup1;
    var fee;
    class freq fee1;
    table freq all,fee1*n*all;
    format fee1 feegroup.;
    format freq freqgroup.;
run;