PROC TABULATE by Example, Second Edition

Use the CLASSDATA Option

If you still cannot get the exact table that you want, even with all of these possible CLASS statement options, then there is another feature for you to try. The CLASSDATA= option lets you create a data set that contains the exact combinations of class variables that you want included in your table. To see why this option might be useful, look at the following code:

PROC TABULATE DATA=TEMP;
   CLASS GENDER CTRY MARITAL;
      TABLE MARITAL, CTRY=" "*GENDER=" "*N=" "*F=8.
      / BOX='Number of Observations';
RUN;

In Output 14.20, you can see that this table needs a little work. First, there is no data for South American females.

Output 14.20 Incomplete Table

We could fix this by using the PRELOADFMT and PRINTMISS options to ...