In a SAS table, there are more than 100 columns with variable name length of more than 32 characters, instead of renaming all the variables manually, I want to write the code that will replace or remove specific character strings from all the columns.
For example in the below-mentioned variable, I want to remove character strings "LAST_" and "MTH_" from the variable name.
Existing Variable Name
New Variable Name
X_USED_CAR_LOAN_DPD_LAST_12_MTH_CNT_SUB
X_USED_CAR_LOAN_DPD_12_CNT_SUB
X_USED_CAR_LOAN_DPD_LAST_12_MTH_CNT_DBT
X_USED_CAR_LOAN_DPD_12_CNT_DBT
X_USED_CAR_LOAN_DPD_LAST_12_MTH_CNT_LSS
X_USED_CAR_LOAN_DPD_12_CNT_LSS
X_USED_CAR_LOAN_DPD_LAST_12_MTH_CNT_XXX
X_USED_CAR_LOAN_DPD_12_CNT_XXX
Note:- This is not an actual table, I just took four variable names for explanation purpose
If I rename the variable names will the label name change as well, currently variable names and label names are the same?
... View more