【SAS NOTE】tabulate
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|
--------------------------------------
