Date: Thu, 11 Feb 2010 08:53:34 -0800
Reply-To: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Terjeson, Mark" <Mterjeson@RUSSELL.COM>
Subject: Re: Join data horizontally
Content-Type: text/plain; charset="US-ASCII"
Well, as we know, most languages do not
allow more than one variable with the
same variable name. However, for dataset
one and two, you could distinguish them
by renaming them to A1 and A2 and B1 and B2.
The dataset option "rename" prior to a merge
in a datastep, or mere renames when using SQL
can accomplish this.
Hope this is helpful.
Investment Business Intelligence
Investment Management & Research
Global Leaders in Multi-Manager Investing
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Sent: Thursday, February 11, 2010 7:48 AM
Subject: Join data horizontally
I want to join data horizontally without any common columns replacing
other. I want to have the joined data set to have all the datasets side
side with each other.
A B C
AR SE 44
TX SE 32
NY NE 30
I want to join above three datasets in one single dataset with each
side by side with the other. My final dataset would be:
A B A B C Species Cost
st 1 AR SE 44 SW 32
ts 2 TX SE 32 HW 22
NY NE 30