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.
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.
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.
Thank you! very helpful!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.