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 (September 2010, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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."

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