How to duplicate rows in one table based on # of IDs in another dataset and merge them

[shasank]

Hi Community, 

I have an issue that I am trying to resolve and much appreciate any help that can be given. Thank you for your time and help. 

I have a dataset that has a list of visits(Shown below)  

Visit Name	Order
Screening	1
First Visit	2
Week a	3
Week aa	4
Week b	5
Week bb	6
Week c	7
Week cc	8

List of Subject IDs. 

IDs
1
2
3
4
5
6
7
8

I need to merge these to create a list of visits for each subject. I have shown below how the end dataset should look like for 1 subject. But need it for all the subjects in the same dataset.

ID	Visit Name	Order
1	Screening	1
1	First Visit	2
1	Week a	3
1	Week aa	4
1	Week b	5
1	Week bb	6
1	Week c	7
1	Week cc	8

[Reeza · Accepted solution]

Use a cross join.

proc sql;
create table want as
select id, visit_name, order
from table1 cross join table2
order by id, order;
quit;