Dynamically rename range list in SAS

[Pradeepbanu]

Hello Everyone,

My dataset columns looks like below

ID Name ORG_ID Products Var_1 Var_2 Var_3 Var_4 Var_5

I want to rename only the range lists which is Var_1--var_5, like

Var_1 = Current month ending date

Var_2= Prev month ending date....

My dataset would be like

ID Name ORG_ID Products 30Nov2020 31Oct2020  30Sep2020 .... so on

How can I achieve this?

[Astounding]

Did you know:

• 30Nov2020 would normally be an invalid name for a variable.
• That name can be used, but becomes very clumsy.  To program with it, you would need to refer to it as "30Nov2020"n

If you need different column headings, why not use variable labels instead of trying to change the variable names?

[andreas_lds]

So you want data in variables names. This is, in almost any case i came across, a bad idea an will make further usage of the data unnecessary difficult. So i would start by transposing the data to something like ID / Name / ORG_ID / Products / Date / Value.