If a percentage statistic is requested for an analysis variable with PROC TABULATE, the original variable name is appended as a suffix to the associated output data set variable name beginning in the third maintenance release of SAS^® 9.4 (TS1M3).

To illustrate the change, use the following sample code:

proc tabulate data=sashelp.class out=out;
   class sex; 
   var age height;
   table sex, height*colpctsum age*pctsum<height>;
run;

proc print data=out;
run;

In SAS^® 9.3, the variable names are:

    Height_PctSum_0 
    Age_PctSum_1

In SAS 9.4, the variable names are:

    Height_PctSum_0_Height
    Age_PctSum_1_Height

This change is to prevent different denominator crossings from resolving to the same data set variable, which can result in incorrect data.

If the percentage statistic name in the output data set can exceed 32 characters, then the name becomes Pctn<n> or Pctsum<n>. This is also documented in Usage Note 45710, "Naming convention for statistics in an output data set created by PROC TABULATE."

Operating System and Release Information