PROC TABULATE by Example, Second Edition

Break Up the Table

PROC TABULATE drops all observations that have missing data on any of the class variables in your table. This means that if you have one class variable with a lot of missing data, you will lose these observations for all of the other class variables as well. Even if the other class variables have valid data, these observations will be dropped from the entire table.

For example, in the following table, the MISSING option is used to spot a large cluster of missing data for the variable NUMKIDS:

PROC TABULATE DATA=TEMP MISSING;
   CLASS MARITAL NUMKIDS EDUC;
   TABLE EDUC ALL, (MARITAL NUMKIDS)*N;
RUN;

In Output 12.15, you can see that there are 251 observations with missing data for a number of children. When we remove the MISSING ...