topic Re: Many to one merge without linking variable in SAS Programming

Many to one merge without linking variable

endofline — Wed, 21 Sep 2016 21:10:58 GMT

Hello All,

i'm trying to merge two databases that do not have a unique linking variable between the two of them.

My first database consists of IDs, with only one ID for each obersvation.

My second database consists of a procedure ID, percents and other information. How I'd like the final data set to look is something like:

ID Procedure

1 2

1 3

1 4

1 5

1 6

2 2

2 3

2 4

2 5

2 6

Thanks for the help!

ballardw — Wed, 21 Sep 2016 21:23:41 GMT

Proc sql;

create table want as

select dataset1.* , dataset2.*

from dataset1 , dataset2;

quit;

Reeza — Thu, 22 Sep 2016 03:12:57 GMT

Known as a Cartesian Join and in SQL is a cross join.

Proc sql;

create table want as

select a.name, b.age

from sashelp.class as a

cross join sashelp.class as b;

quit;