Skip to Main Content
PROC TABULATE by Example, Second Edition
book

PROC TABULATE by Example, Second Edition

by Lauren Haworth Lake, Julie McKnight
May 2015
Intermediate to advanced content levelIntermediate to advanced
348 pages
11h 31m
English
SAS Institute
Content preview from PROC TABULATE by Example, Second Edition

"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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SAS 9.4 Language Reference, 6th Edition

SAS 9.4 Language Reference, 6th Edition

SAS Institute

Publisher Resources

ISBN: 9781607649908