how to rename the selected multiple variables in datasets

[gsreddy]

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

[PaigeMiller]

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

[PeterClemmensen · Accepted solution]

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;