Date:         Thu, 9 Sep 2010 13:02:00 -0400
Reply-To:     Suzanne McCoy <suzanne.mccoy@CATALINAMARKETING.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Suzanne McCoy <suzanne.mccoy@CATALINAMARKETING.COM>
Subject:      Re: monthly update

I would use proc datasets modify to rename the columns then join or merge
the new data as column m0.

something like this:

proc datasets library=abc;
 modify xyz;
   rename m62 = m63
          m61 = m62 ......;
 run;
quit;


On Thu, 9 Sep 2010 10:51:42 -0400, Chang Chung <chang_y_chung@HOTMAIL.COM>
wrote:

>An interesting question posted somewhere else. It goes, in part:
>
>"I've got a data table with text variables named m0, m1 up to m62. Each
month
>this dataset is updated, with the latest month's data stored in m0 while
all
>the rest need to move up on index, i.e. m0 should be renamed m1, m1
should be
>renamed m2, etc. up to m62 which should be renamed m63."