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 (December 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 9 Dec 2002 04:34:21 -0800
Reply-To:     Paul von Hippel -- Ohio State <pvh@CCRMA.STANFORD.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Paul von Hippel -- Ohio State <pvh@CCRMA.STANFORD.EDU>
Subject:      Re: merge without overwrite
Content-Type: TEXT/PLAIN; charset=US-ASCII

Thanks. Renaming the variables certainly works. But unfortunately in the real application there are ~100 variables.

On Sun, 8 Dec 2002, Steven Goins wrote:

>Use the RENAME dataset option in your last DATA step. > >data ab; > merge a(Rename = (y = YA)) b(ReName=(y=YB)); > by x; >run; > > > hth, >Steve > >"Paul von Hippel -- Ohio State" <pvh@ccrma.Stanford.EDU> wrote in message >news:Pine.LNX.4.44.0212081851280.3095-100000@ccrma-gate.stanford.edu... >> Suppose I'm match-merging two data sets A and B, whose variables >> have the same names. SAS' default behavior is for the B variables >> to overwrite the A variables, but actually I want to keep both >> with appropriately modified names. That is, I would like the output >> of the code below to be >> X Ya Yb >> 1 2 3 >> instead of >> X Y >> 1 3 >> Short of changing the variable names in A or B, is there a simple >> way to make this happen? >> >> data a; >> input x y; >> datalines; >> 1 2 >> ; >> run; >> >> data b; >> input x y; >> datalines; >> 1 3 >> ; >> run; >> >> data ab; >> merge a b; by x; >> run; >> >> proc print data=ab; run; >> > > >


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