PROC TABULATE by Example, Second Edition

Format Percentages

You might have noticed in the chapters about percentages that when PROC TABULATE computes percentages, it does not include percent signs in the results. If we use row or column headings that clearly label the results as percentages, this is okay. But what about when we want to get rid of excess headings, as in the following table?

PROC TABULATE DATA=TEMP;
   CLASS OCCUP GENDER;
   TABLE OCCUP*PCTN=" ", GENDER ALL / ROW=FLOAT;
RUN;

In Output 10.8, you can see that the table is not very clear. The values displayed are percentages, but there is no easy way to see that from the labeling of the table.

Output 10.8 Values without Percent Signs

What we need to do is use the FORMAT= option to apply an appropriate format. The following ...