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

shasank — Mon, 26 Feb 2024 20:29:57 GMT

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

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

Reeza — Mon, 26 Feb 2024 20:49:43 GMT

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;

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

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

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