topic Re: Macro Variable in Proc Tabulate in SAS Programming

Macro Variable in Proc Tabulate

dlin — Wed, 07 Oct 2015 19:37:29 GMT

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.

Re: Macro Variable in Proc Tabulate

Astounding — Wed, 07 Oct 2015 19:44:14 GMT

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.

Re: Macro Variable in Proc Tabulate

dlin — Wed, 07 Oct 2015 20:19:53 GMT

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.

Re: Macro Variable in Proc Tabulate

Reeza — Wed, 07 Oct 2015 20:31:26 GMT

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

Re: Macro Variable in Proc Tabulate

dlin — Wed, 07 Oct 2015 20:40:42 GMT

Thank you! very helpful!