PROC TABULATE by Example, Second Edition

Some of the Values of the Class Variable Are Not Shown

Most of the time, when you create a table, you expect to see certain rows and columns in the result. When a variable has three categories (for example, ‘red,’ ‘white,’ and ‘blue’), then you expect a table to show rows and columns for all three colors. If you get just ‘red’ and ‘white,’ then something is wrong.

Take the case of the following table. The row variable is GRADE. According to the variable’s format, the values for this variable are A, B, C, D, and F.

PROC TABULATE DATA=TEMP;
   CLASS GRADE CTRY;
   TABLE GRADE, CTRY=' '*N*F=8.;
RUN;

But if you look at Output 17.4, you can see that the table has values for A, B, C, and F only. There are no records with a grade of D.

Output 17.4 Table ...