Macro Variable in Proc Tabulate

[dlin]

This is my first post here. I would like to create mutiple tables by using proc tabulate. I have 20 different names in the variable called 'group', and would like to create 20 tables for each of the group. I could restrict each group in WHERE statement within proc tabulate. But rather than write my codes 20 times, I'm wondering if there is a way to put macro in there. Appreciate any suggestions.

[Astounding]

You have a couple of relatively simple choices (no macro language needed).

(1) Sort your data by this GROUP variable, and run a single PROC TABULATE adding the statement BY GROUP;

(2) If your table is two-dimensional, add a third dimension which would be GROUP.  For this to be the paging dimension of the table, it has to appear first:

tables GROUP, (row dimension), (column dimension);

Good luck.

[dlin]

Thank you so much! It provides me a new approach, but I kinda would like to gerenerate 20 tables seperately, because I'd like to export each table into one spreadsheet within one big excel workbook.

[Reeza · Accepted solution]

Use the BY variable processing with ODS TAGSETS.EXCELXP - it will create each tab for you by default.

http://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data

[dlin]

Thank you! very helpful!