topic Re: Dynamically rename range list in SAS in SAS Programming

Dynamically rename range list in SAS

Pradeepbanu — Thu, 05 Nov 2020 02:44:07 GMT

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?

Re: Dynamically rename range list in SAS

Astounding — Thu, 05 Nov 2020 04:09:25 GMT

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?

Re: Dynamically rename range list in SAS

andreas_lds — Thu, 05 Nov 2020 05:22:29 GMT

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.