DATA Step, Macro, Functions and more

Many to one merge without linking variable

Reply
Contributor
Posts: 27

Many to one merge without linking variable

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! 

Super User
Posts: 11,343

Re: Many to one merge without linking variable

Posted in reply to endofline

Proc sql;

   create table want as

   select dataset1.* , dataset2.*

   from dataset1 , dataset2;

quit;

Super User
Posts: 19,878

Re: Many to one merge without linking variable

[ Edited ]
Posted in reply to endofline

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;

Ask a Question
Discussion stats
  • 2 replies
  • 254 views
  • 2 likes
  • 3 in conversation