topic renmae multiple name in SAS Programming

renmae multiple name

GeorgeSAS — Fri, 29 Jul 2016 17:39:33 GMT

Hello everyone,

I want rename multiple varaibles (they have common begin characters var_)in data three, but not work,please help.

data one;

var_1=1;var_2=2;var_3=3;var_4=4; var5=5;output;

run;

data two;

set one;

rename var_3=var_3_new;

*rename var_:=varname(var_: )||_new;

run;

data three;

set one;

rename var_:=varname(var_: )||_new;/*this not work*/

run;

Thanks!

Re: renmae multiple name

Reeza — Fri, 29 Jul 2016 18:10:47 GMT

The rename only takes text, you can't use functions like that. You need to list all out.

If if you have a series with common prefix you can do the following:

rename x1-x5 = new_x1-new_x5;

Use prefixes rather than suffixes to make your life easier.

Re: renmae multiple name

Ksharp — Sat, 30 Jul 2016 05:50:50 GMT

You could create a map file to describe how to rename these variables.




data one;
var_1=1;var_2=2;var_3=3;var_4=4; var5=5;output;
run;

proc transpose data=one(obs=0) out=temp;
var _all_;
run;

data temp;
 set temp;
 new=catx('_',_name_,'new');
run;

data _null_;
 set temp end=last;
 if _n_=1 then call execute('proc datasets lib=work nolist nodetails;modify one;rename ');
 call execute(catx('=',_name_,new));
 if last then call execute(';quit;');
run;