| Date: | Tue, 25 Jan 2005 21:53:48 -0000 |
| Reply-To: | MA015b8234 <ma015b8234@BLUEYONDER.CO.UK> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | MA015b8234 <ma015b8234@BLUEYONDER.CO.UK> |
| Subject: | Seeking a sql solution |
| In-Reply-To: | <BAY101-F376056F590F71C10626404DE850@phx.gbl> |
| Content-Type: | text/plain; charset="us-ascii" |
Dear SAS-L Readers
I have tow datasets which look like this:
Dataset A
A B C
1 2 1
2 3 2
1 1 1
4 1 2
Data set B
C D
1 3
2 4
I want to combine the two such that
Data Set AB;
A B C D
1 2 1 3
2 3 2 4
1 1 1 3
4 1 2 4
Thanks for your help in advance.
John
|