"PCTN Base Is Not in Table" and "PCTN Crossing Has No Denominator"
If you are building
tables with percentages, you are going to run into these messages
sooner or later. These two messages always appear together. They are
caused by the same problem: your denominator definition does not match
your table design. Whatever you put between the brackets of the
PCTN<> or PCTSUM<> does
not match up to the column, row, or cell that it is being applied
to.
There are infinite ways
that you can trigger this message. This example illustrates one of
the more common causes and its solution.
This code triggers the error messages shown here. What’s causing the problem is the variable ALL. This variable is used in the row dimension, but it is not in the denominator ...
Get PROC TABULATE by Example, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
