topic Re: PROC TABULATE use variable names instead of labels in SAS Programming

PROC TABULATE use variable names instead of labels

whs278 — Fri, 09 Apr 2021 14:56:06 GMT

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

Re: PROC TABULATE use variable names instead of labels

PaigeMiller — Fri, 09 Apr 2021 14:58:48 GMT

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

options nolabel;

which affects all PROCs until you turn it off.

Re: PROC TABULATE use variable names instead of labels

whs278 — Fri, 09 Apr 2021 15:59:16 GMT

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.

Re: PROC TABULATE use variable names instead of labels

ballardw — Fri, 09 Apr 2021 15:59:24 GMT

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.