topic Rename var in proc transpose?? in SAS Programming

Rename var in proc transpose??

Q1983 — Wed, 07 Apr 2021 23:17:00 GMT

data have;
input Mgr $ Exception $ CNT ;
datalines;
Smith Transfer 1
Smith Transfer 1
Smith Cancel 1
Brown Reinstate 1
Brown Terminate 1
Saunders Transfer 1
Saunders Cancel 1
;
run;

proc sql;
create table have2 as
select Mgr,Exception,sum(cnt) as tot_cnt
from have
group by Mgr,Exception
;quit;

proc transpose data=have2 out=want let;
id Exception;
var tot_cnt;
by Mgr;
run;

1. Is it possible to rename tot_cnt as My_Count

2. If I had multiple var could I rename each var as desired?

Re: Rename var in proc transpose??

Phil_NZ — Wed, 07 Apr 2021 23:42:28 GMT

You can, just using the option rename.

proc transpose data=have2 out=want (rename=(_NAME_=My_Count)) let;
id Exception;
var tot_cnt;
by Mgr;
run;

Re: Rename var in proc transpose??

andreas_lds — Thu, 08 Apr 2021 04:51:18 GMT

Your dataset "want" looks like a report. Do you really need a dataset?

If not, try proc tabulate:

proc tabulate data=have format=5.;
   class Mgr Exception;
   var cnt;
   
   table Mgr= ' ', Exception*cnt= ' ' / box= 'Mgr';
   
   keylabel sum= ' ';
run;