topic Re: Rename variables in New SAS User

Rename variables

SASPhile — Fri, 04 Oct 2019 19:37:27 GMT

There are some variables that end in "zz". How to rename only those variables by removing "zz" from variable name?

For example Temperaturezz should be renamed to Temperature.

Re: Rename variables

PeterClemmensen — Fri, 04 Oct 2019 20:07:29 GMT

And you want to do so for all variables in a specific data set?

Re: Rename variables

SASPhile — Fri, 04 Oct 2019 20:10:20 GMT

Yes. Most of the variables end with "zz" so would like to remove zz and those without zz Would like to keep them as is

Re: Rename variables

PeterClemmensen — Fri, 04 Oct 2019 20:21:57 GMT

Ok. Here is one way

data test;
input onezz two threezz;
datalines;
1 2 3
;
 
data _null_;
   set sashelp.vcolumn end=lr;
   where libname='WORK' and memname='TEST';
 
   if _n_ = 1 then 
      call execute('proc datasets lib=work nolist; modify test;');
 
   if substr(name,length(name)-1,2)='zz' then
      call execute(compbl(cat('rename ', name, '=', tranwrd(name, 'zz', ''), ';')));
 
   if lr then call execute('quit;');
run;

Re: Rename variables

Tom — Fri, 04 Oct 2019 23:14:12 GMT

Looks good, but you probably will want to tighten up the logic.

Make sure test for names that end in ZZ or zZ or Zz also.

lowcase(substr(name,length(name)-1,2))='zz'

Also you don't want to remove the zz from the middle of a name like PIzzazz.

 call execute(catx(' ','rename',name,'=',substr(name,1,length(name)-2)))