I Have a dataset with 150 variables let say V1 TO V150 .
Each variable end up with the year month definition.
( V1_200304 V1_200305 V1_200306 V1_200307 V1_200308 ,
V2_200304 V2_200305 V2_200306 V2_200307 V2_200308 ,
V150_200304 V150_200305 V150_200306 V150_200307 V150_200308 )
I would like to rename those variables in order to have
( V1_M4 V1_M3 V1_M2 V1_M1 V1_M0 ,
V2_M4 V2_M3 V2_M2 V2_M1 V2_M0 ,
V150_M4 V150_M3 V150_M2 V150_M1 V150_M0 ).
I don't want to rename each variable one by one (going trough 150 variables
using rename=(v1_200304 =V1_M4.. and so forth..).
All ideas or hint are very welcome.
Senior Manager Customer Behavior Modeling