Merging datasets without a unique identifier

[einstein]

Is there a way to merge two datasets that do not have a unique identifier:

For example:

Dataset 1 has:

ID    Name     Color

1     Bob         Red

2     Jane       Blue

And Dataset 2 has:

Food    Drink

Pasta   Soda

Pizza   Water

So that when you merge the two it would look like:

ID    Name     Color    Food    Drink

1     Bob         Red      Pasta   Soda

1     Bob         Red      Pizza    Water

2     Jane       Blue      Pasta   Soda

2     Jane       Blue      Pizza    Water

 A simple statement like below does not work:

Data one;

merge color food;

run;

[PGStats · Accepted solution]

What you describe is the cartesian product of the two datasets

proc sql;

create table dataset3 as

select dataset1.*, dataset2.*

from dataset1 cross join dataset2;

quit;

[einstein]

This worked beautifully!

Thank you!