O'Reilly logo

PROC TABULATE by Example, Second Edition by Lauren Haworth Lake, Julie McKnight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Percentages for Three-Dimensional Tables

Using the PCTN Statistic

It is possible to add percentages to three-dimensional tables. It’s not difficult to write the code to create three-dimensional percentages. The challenge is in understanding what the resulting tables are showing. Percentages can be rather confusing across three-dimensional tables because you cannot always see how they add up when looking at a single page.
For our example, we will use the following code:
PROC TABULATE DATA=TEMP;
   CLASS SAT CTRY GENDER;
   TABLE SAT ALL, CTRY ALL, (GENDER ALL)*N;
RUN;
This code produces a table with a page for each level of satisfaction plus a totals page. Each page shows country by gender with totals for the rows and columns. For this example, we ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required