topic how to rename the selected multiple variables in datasets in SAS Programming

how to rename the selected multiple variables in datasets

gsreddy — Mon, 08 Apr 2019 11:54:03 GMT

Hi,

I have multiple data sets in a library and some of the datasets have same variable(ex: Id).

Now i want to rename all the variables from ID to EMP_ID.

Thank you

Re: how to rename the selected multiple variables in datasets

PaigeMiller — Mon, 08 Apr 2019 12:14:05 GMT

proc datasets library=work nolist;
    modify datasetname;
    rename id=emp_id;
run;
quit;

Re: how to rename the selected multiple variables in datasets

PeterClemmensen — Mon, 08 Apr 2019 12:47:04 GMT

data one;
ID=1;var=1;
run;

data two;
var=1;
run;

data three;
ID=1;var=1;
run;

data _null_;
   set sashelp.vcolumn(where=(libname='WORK' and name='ID'));
   string=compbl(cat(
      "
      proc datasets library=work nolist;
         modify ", memname, ";
         rename id=emp_id;
      run;quit;
      "
      ));
   output;
   call execute(string);
run;