Hello,

I have a large dataset where there are numerous variables with the prefix HospYQ (ie: HospYQelite, HospYQhawaii, HospYQsize). Not all of the variables have this prefix. I would like to rename the variables so they do not have the pre-fix (ie:, elite, hawaii, size).

While I could do a numerous rename statements, I would like for the code to be more efficient and easier to update since the variables with HospYQ prefix may not be the same each quarter when the data is pulled. For example, when the data is pulled in the spring, hospyelite is in the dataset however, when the data is pulled in the fall, hospyqelite is not there.

Thank you for your assistance. Catima