Date:         Wed, 20 Sep 2006 14:43:46 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: Question on merging datasets
Comments: To: aaron.anderson@THIRDWAVERESEARCH.COM
In-Reply-To:  <1158762827.044586.111710@i3g2000cwc.googlegroups.com>
Content-Type: text/plain; format=flowed

Assuming thevariables arent named the same in both data sets:

Proc SQl ;
Create Table Need As
  Select A.* , B.*
    From A AS A ,
            B AS B ;
Quit ;



Toby Dunn

When everything is coming at you all at once, your in the wrong lane.

A truly happy person is someone who can smile and enjoy the scenery on a
detour.





From: Pete <aaron.anderson@THIRDWAVERESEARCH.COM>
Reply-To: Pete <aaron.anderson@THIRDWAVERESEARCH.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: Question on merging datasets
Date: Wed, 20 Sep 2006 07:33:47 -0700

my hypothetical situation: (I'm a newbie so please be gentle)
Two datasets  (A and B)

A = 3 Oservations
B = 3 Observations

How do I do a one to many merge that creates a dataset with
9observations? Each observation from dataset B should be repeated 3
times (once for every observation in dataset A).

Dataset A
1
2
3

Dataset B
A
B
C

Merged output
A 1
A 2
A 3
B 1
B 2
B 3
C 1
C 2
C 3


Many thanks, pete