topic Re: how do repeat the ID for every patient 11 times in New SAS User

how do repeat the ID for every patient 11 times

sasgyro — Mon, 10 Aug 2020 01:32:29 GMT

how do repeat the ID for every patient so that they have 11 instances they appear in the dataset. Some patients appear 3 4 7 or 11 times but I want everyone to be featured 11 times.

Re: how do repeat the ID for every patient 11 times

Shmuel — Mon, 10 Aug 2020 04:04:13 GMT

What other variables are in your dataset? Should they be missing or with any initial value?

Please post an sample of your dataset.

Why do you want the IDs to be in 11 observations ? what is the logic or needs?

One way to do it is to select distinct IDs, replicate them to have 11 times each and then

remerge them with your dataset by ID and maybe some other variable (like a date).

Re: how do repeat the ID for every patient 11 times

sasgyro — Mon, 10 Aug 2020 13:59:24 GMT

Yes,

i need every instance repeated 11 times because I want the data to reflect the patient at different time intervals. the intervals for the experiment are the same for each patient and we took their vitals at each instance so there are other variables. however some patients died during before the full time length of experiment so there is no data for times above when they died. I still want to include them to 11 times for continuity and mark them as Status=0 for dead at this time interval. Im trying to put the data in a counting style.

The data wu

ID. T1T2StatusTrtNumberSizeZ

1	0	3	1	1	1	3	12.3
1	3	10	1	1	1	3	14.7
1	10	15	1	1	1	3	13.8
1	15	23	0	1	1	3	15.5

2	0	3	1	1	1	5	12.3
2	3	10	1	1	1	3	14.7
2	10	15	0	1	1	3	13.8
2	15	23	0	1	1	3	15.5

Re: how do repeat the ID for every patient 11 times

Shmuel — Mon, 10 Aug 2020 14:36:13 GMT

Looking at your table posted each observation have a unique KEY made of

ID T1 and T2.

What values should T1, T2 have in next added observations ?

Steps to result will be:

1) select distinct values of ID taken from current dataset

2) replicate IDs 11 times including T1 T2 values creating a skeleton dataset

3) merging the skeleton with the current dataset by ID T1 T2

Re: how do repeat the ID for every patient 11 times

Angel_Larrion — Mon, 10 Aug 2020 14:51:44 GMT

The following code should work, it repeats the last observation of each id until there is 11 observations per id.

data want;
set have;
by id;
retain i 1;

if first.id then do;
    i=1;
    i=i+1;
    output;
end;

else if last.id=0 and first.id=0 then do;
    i=i+1;
    output;
end;


else if last.id then do;
    do until (i=12);
        i=i+1;
        output;

        status=0;
    end;
end;
 
drop i;
run;