topic Copying Each Observation from One Dataset to Each Observation of Another During Merge in SAS Programming

Copying Each Observation from One Dataset to Each Observation of Another During Merge

brandon_hall — Thu, 11 Jul 2019 16:07:15 GMT

Good afternoon,

I have two datasets I am merging together, one has observations for each participant (age and gender), the other dataset has only a date for each observation:

Obs patient age sex
1 1 23 M
2 2 43 F
3 3 62 F
4 4 41 M
5 5 42 M

Obs date
1 21380
2 21387
3 21394

I'm trying to get each patient to have a row per date:

Obs patient age sex date

1 1 23 M 21380

1 1 23 M 21387

1 1 23 M 21394
2 2 43 F 21380

2 2 43 F 21387

2 2 43 F 21394
3 3 62 F 21380

3 3 62 F 21387

3 3 62 F 21394
4 4 41 M 21380

4 4 41 M 21387

4 4 41 M 21394
5 5 42 M 21380

5 5 42 M 21387

5 5 42 M 21394

Thank you for your help!

Re: Copying Each Observation from One Dataset to Each Observation of Another During Merge

novinosrin — Thu, 11 Jul 2019 16:11:57 GMT

A simple cartesian???

proc sql;
create table want as
select a.*,date
from one a,two 
order by a.patient,date;
quit;

Re: Copying Each Observation from One Dataset to Each Observation of Another During Merge

brandon_hall — Thu, 11 Jul 2019 16:29:49 GMT

That did it! Thanks for such a quick response.