PROC TABULATE use variable names instead of labels

[whs278]

Is there way to use the variable names in PROC TABULATE instead of labels?

[PaigeMiller · Accepted solution]

If you remove the labels from the variable names, then all SAS PROCs (as far as I know) use the variable name.

Or

options nolabel;

which affects all PROCs until you turn it off.

[whs278]

Thanks, this worked!

I was thinking there would be a NOLABELS options for PROC TABULATE as there is for PROC MEANS but there evidently isn't.  I guess this actually makes sense because it would be rare that you would prefer the variable name when using PROC TABULATE.  In any case, your solution worked. 

[ballardw]

Don't know if this helps as you don't say how many variables might be involved.

You can override the default label for any variable in a Table statement by using variablename='Label text' in Proc tabulate.

This works for statistics as well such as Sum='Sum of xxxx'

Example

proc tabulate data=sashelp.cars;
   class drivetrain;
   var mpg_city;
   tables drivetrain='Drivetrain',
          mpg_city='MPG'*mean;
run;

The above will display "Drivetrain" instead of "Drive Train" and "MPG" instead of assigned label of "MPG (City)";

Or provide a Label statement.

proc tabulate data=sashelp.cars;
   class drivetrain;
   var mpg_city;
   tables drivetrain,
          mpg_city*mean;
   label drivetrain='Drivetrain'
         mpg_city='MPG'
   ;

run;

The equivalent for statistics would be KEYLABEL: Keylabel mean='Average'; for example would display 'Average' for all mean statistics.