Merging datasets without a unique identifier

Accepted Solution Solved
Reply
Contributor
Posts: 65
Accepted Solution

Merging datasets without a unique identifier

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;


Accepted Solutions
Solution
‎09-09-2016 01:50 PM
Respected Advisor
Posts: 4,649

Re: Merging datasets without a unique identifier

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;

PG

View solution in original post


All Replies
Solution
‎09-09-2016 01:50 PM
Respected Advisor
Posts: 4,649

Re: Merging datasets without a unique identifier

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;

PG
Contributor
Posts: 65

Re: Merging datasets without a unique identifier

This worked beautifully!

 

Thank you!

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 273 views
  • 0 likes
  • 2 in conversation