topic Re: Repeated set of observations for each patient in SAS Programming

Repeated set of observations for each patient

jomag — Fri, 06 Oct 2017 20:40:06 GMT

I am a relatively new SAS user. I use SAS 9.4. I have 260 patients with their Patient IDs in sequential order from 1 to 260. I would like for each of the patient to have a set of set of repeated observations which I can use for further analysis. However, I am stuck on how to create a set of repeated observations in SAS. I do not want to manually enter the observations for each of the 260 patients.I would really appreciate suggestions. Thanks!

I would like the data set to look like this in the end:

Study_ID Age_in_Days Mean_HF

1 2 10

1 15 42

1 70 45

2 2 10

2 15 42

2 70 45

3 2 10

3 15 42

3 70 45

Re: Repeated set of observations for each patient

Reeza — Fri, 06 Oct 2017 20:54:59 GMT

And what are you starting with? What are the rules for repeating data? Post sample data.

Re: Repeated set of observations for each patient

jomag — Fri, 06 Oct 2017 21:23:58 GMT

Hi Reeza,

Below are the two variables and the set of observations that I would like to repeat for each of my patients (From 1 to 260). The first variable is Age_In_Days and the second variable is Mean_HF value.

SAMPLE:

Age in days	Mean Hf
45	75
90	40.4
150	31.8
225	28.1
315	24.6
405	21.8
495	19.5

I just want to create a data set that has these values repeated for each patient to look like this (I only have 3 patients here but I need it similar for all 260 patients):

1	45	75
1	90	40.4
1	150	31.8
1	225	28.1
1	315	24.6
1	405	21.8
1	495	19.5
2	45	75
2	90	40.4
2	150	31.8
2	225	28.1
2	315	24.6
2	405	21.8
2	495	19.5
3	45	75
3	90	40.4
3	150	31.8
3	225	28.1
3	315	24.6
3	405	21.8
3	495	19.5

Re: Repeated set of observations for each patient

Reeza — Fri, 06 Oct 2017 21:30:11 GMT

That's known as a cross join or cartesian product.

proc sql;
create table want as
select *
from table1, table2;
quit;

Re: Repeated set of observations for each patient

jomag — Fri, 06 Oct 2017 21:40:45 GMT

Thank you, Reeza.