I want to change the following code ,using %do %to, to be more efficient. If the file name includes "bridge02_08" and then change the name like "b _2008 ", ..................... Removing the redundudnt part. /**** Read all files in my directory ****************************/ filename ren pipe 'dir "C:\data\age_years\*"/b' ; data ren; infile ren; input old : $250.; /***** Need to change the file name because I call each file from the same sql code. data ren_new ; set ren; old=tranwrd(old, "bridge02_08", "b_2008"); old=tranwrd(old, "bridge02_09", "b_2009"); old=tranwrd(old, "bridge02_10", "b_2010"); old=tranwrd(old, "bridge02_11", "b_2011"); old=tranwrd(old, "bridge02_12", "b_2012"); old=tranwrd(old, "bridge02_13", "b_2013"); old=tranwrd(old, "bridge02_14", "b_2014"); old=tranwrd(old, "bridge02_15", "b_2015"); old=tranwrd(old, "bridge02_16", "b_2016"); old=tranwrd(old, "bridge02_17", "b_2017"); old=tranwrd(old, "bridge02_18", "b_2018"); old=tranwrd(old, "bridge02_19", "b_2019"); old=tranwrd(old, "bridge02_20", "b_2020"); old=tranwrd(old, "bridge02_21", "b_2021"); old=tranwrd(old, "bridge02_22", "b_2022"); put old; run;
... View more