topic Re: Merging datasets without a unique identifier in SAS Programming

Merging datasets without a unique identifier

einstein — Fri, 09 Sep 2016 17:18:09 GMT

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 — Fri, 09 Sep 2016 17:47:18 GMT

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 — Fri, 09 Sep 2016 17:50:59 GMT

This worked beautifully!

Thank you!