PROC TABULATE by Example, Second Edition

Percentages for Multiple Column Variables

Overview

This next example looks at a similar table, but this time we are computing percentages for multiple column variables. Again, we will be building percentages for more than one variable at a time.

Our starting point is a table similar to the one in the previous examples. It shows a breakdown of customers by country, gender, business type, and business size. Only this time, there are multiple row variables and multiple column variables. The following code produces a table that shows the number of customers in each category:

PROC TABULATE DATA=TEMP;
   CLASS GENDER CTRY CUSTTYPE SIZE;
   TABLE CTRY*GENDER, (CUSTTYPE SIZE)*N;
RUN;

Again, it would be much more interesting to see some percentages. This ...