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;
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;
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;
This worked beautifully!
Thank you!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.