Hi, I have created a list of variables ending with months and years in the format costMMYYYY (cost12017 as an example). I need to rename the set of variables to cost_MMYYYY (cost_012017), however, there are a lot of them to do using a simple RENAME (4 years worth). I tried an array and do loop and my code is creating the correct var names, but the values are inaccurate. I was trying to set them equal to the original and was planning to then drop the original: DATA want SET have; array old(12) cost12012 cost22012 cost32012 cost42012 cost52012 cost62012 72012 cost82012 cost92012 cost102012 cost112012 cost122012; array new (12) cost_12012 cost_22012 cost_32012 cost_42012 cost_52012 cost_62012 cost_72012 cost_82012 cost_92012 cost_102012 cost_112012 cost_122012; do i=1 to dim(old); do j=1 to dim(new); new(j)=old_hci(i); end; end; RUN; Any suggestions on how to either correct this array/loop OR another way to rename my vars? Thank you!
... View more