LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2004, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Sat, 24 Jan 2004 17:30:16 -0500
Reply-To:   "Isson, Jean-Paul" <Jean-Paul.Isson@MICROCELL.CA>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Isson, Jean-Paul" <Jean-Paul.Isson@MICROCELL.CA>
Subject:   How to rename variables.
Content-Type:   text/plain; charset="iso-8859-1"

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


Back to: Top of message | Previous page | Main SAS-L page