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
Thank you for your assistance.