PROC TABULATE by Example, Second Edition

Repeat a Table for a Series of Time Periods - II

Sometimes, you want to build tables with so many different combinations of variables and time periods that even building a macro with parameters is too much work. It can take a long time to set up all the macro calls with the appropriate variable and time period selections. In this case, you might want to set up your macro so that it loops through the various combinations of variables and time periods.

For example, suppose you want to produce tables of income by gender for each of four class variables, and you want to repeat these tables for each of 12 years. If you set up a query with parameters for the class variable and year, you would have to set up 48 (12x4) macro calls!

Alternatively, you ...