1 data mysas.mms; 2 infile 'E:\SAS\mysas\mms.txt' dlm='09'x firstobs=2; 3 input date city wangnei wangjian guoji shangxing wangneid wangjiand guojid 4 alld allwangnei allwangjian allguoji allall upfeetiao downfeetiao; 5 run; 6 proc print data=mysas.mms; 7 run; 8 proc tabulate data=mysas.mms; 9 class date;10 var wangnei;11 table date all,sum*wangnei*ALL;12 run;
tabulate过程可以用于生成交叉表，列联表，其中变量可以进行运算。注意 table后的变量顺序是页，行，列，并且中间用逗号隔开。
--------------------------------------
| | Sum | | |------------| | | wangnei | | |------------| | | All | |-----------------------+------------| |date | | |-----------------------| | |201207 | 36452433.00| |-----------------------+------------| |201208 | 31663842.00| |-----------------------+------------| |201209 | 34185344.00| |-----------------------+------------| |201210 | 38972453.00| |-----------------------+------------| |201211 | 33754486.00| |-----------------------+------------| |201212 | 45384882.00| |-----------------------+------------| |All |1998704690.0| --------------------------------------