I tried to use this code and change values in column , "old". This data file name. I want to change to b_2008.sas7bdat, b_2009.sas7bdat, b_2010.sas7bdat............b_2022.sas7bdat. In your code, I put : old=%sysfunc(tranwrd(old, &oldname, &newname)); However, it doesn't work. %do year = 2008 to 2022 ;
%let twodigit = %substr(&year,3);
%let oldname=bridge02_&twodigit;
%let newname=b_20&twodigit;
old=%sysfunc(tranwrd(old, &oldname, &newname));
%end;
... View more