name of columns in output data set of proc tabulate

Ronein — Sun, 14 Apr 2019 04:06:27 GMT

Hello

I am using proc tabulate procedure with out option to create output data set.

My question is how to control the name of the columns in the output data set.(without using rename statement!!!)

for example:

Instead of names:

MSRP_Mean

MSRP_Max

MSRP_Min

I want to have name:

x_avg

x_Max

x_Min

proc tabulate data = sashelp.cars  out=bbb;
class origin;
var msrp;
table origin,
        msrp*mean msrp*max  msrp*min ;
run;

Re: name of columns in output data set of proc tabulate

SASKiwi — Sun, 14 Apr 2019 05:53:43 GMT

I don't see any other way of doing this inside TABULATE except using RENAME = like so:

out = bbb (rename = (CurrentName = NewName))