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