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?
Did you know:
If you need different column headings, why not use variable labels instead of trying to change the variable names?
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.