PROC TABULATE by Example, Second Edition

"Class Variable Is Missing on Every Observation"

The previous examples show problems that come up because of faulty PROC TABULATE code. This message usually refers to a problem with the data set itself. When you see the message "WARNING: A class, frequency, or weight variable is missing on every observation", you know that you have a data set problem.

This message is only a warning, but it might as well be an error, because PROC TABULATE cannot build a table when there is a missing CLASS value for every observation. To see how this problem occurs, consider the following code:

PROC TABULATE DATA=TEMP;
   CLASS APPR MTRAIN UNION OCCUP;
   TABLE OCCUP=' ',
   (APPR MTRAIN)*UNION=' '*N=' '*F=10.
   / ROW=FLOAT BOX='Programs Offered';
RUN;

This code produces ...