|Date: ||Fri, 30 Sep 2011 16:38:43 -0700|
|Reply-To: ||Fareeza Khurshed <fkhurshed@GMAIL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Fareeza Khurshed <fkhurshed@GMAIL.COM>|
|Subject: ||Re: Interleaving unrelated datasets|
|Content-Type: ||text/plain; charset=ISO-8859-1|
You're looking for whats called a cross join.
Tom's code works, the following works as well.
create table want as
CROSS JOIN have2;
On Fri, Sep 30, 2011 at 4:21 PM, Bruce Johnson <email@example.com>wrote:
> I have a situation that I cannot figure out how to resolve...
> I have two datasets. One has a field called svcarea. The other table has
> field called prodline. The tables look something like this:
> Table One:
> Table Two:
> What I am trying to get is a table that looks like this:
> Table Three:
> NORTH SURGICAL
> NORTH MEDICAL
> SOUTH SURGICAL
> SOUTH MEDICAL
> EAST SURGICAL
> EAST MEDICAL
> WEST SURGICAL
> WEST MEDICAL
> Is this possible?