Macro Variable in Proc Tabulate

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Macro Variable in Proc Tabulate

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.


Accepted Solutions
Solution
‎10-07-2015 04:40 PM
Super User
Posts: 19,851

Re: Macro Variable in Proc Tabulate

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

View solution in original post


All Replies
Super User
Posts: 5,516

Re: Macro Variable in Proc Tabulate

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.

New Contributor
Posts: 3

Re: Macro Variable in Proc Tabulate

Posted in reply to Astounding

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.

Solution
‎10-07-2015 04:40 PM
Super User
Posts: 19,851

Re: Macro Variable in Proc Tabulate

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
New Contributor
Posts: 3

Re: Macro Variable in Proc Tabulate

Thank you! very helpful!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 428 views
  • 3 likes
  • 3 in conversation