Hello everybody, 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.

Thanks.

Jean-Paul Isson Senior Manager Customer Behavior Modeling Database Marketing phone:514-937-2121ext 7326