I have this code, but i need it to run a certain number of times using the do loop.
proc sql ;
create table _02_pt_regimen as
select distinct a.PatientID, a.last_visit, a.death_date, a.MetDiagnosisDate, a.Birthyear, a.age, a.VisitDate,b.StartDate , b.EndDate, b.LineName
from derived.pt_cohort as a
inner join dfi_panc.lineoftherapy as b
on a.PatientID = b.PatientID
where year(b.StartDate) in (2015,2016,2017) and (b.LineName in ('FOLFIRINOX', 'FOLFIRI')
order by PatientID, StartDate ;
quit ; /*3396*/
/*GETTING THE FIRST START DATE */
data _02_first_epi ;
set _02_pt_regimen ;
format episode1_start episode1_end mmddyy10. ;
by PatientID StartDate;
if first.PatientID ;
episode1_start= StartDate ;
episode1_end = min(death_date, episode1_start +180) ;
run ; /*2575*/
/*MERGING WITH THE TREATMENT LEVEL DATASET*/
proc sql ;
create table _02_second_epi as
select b.PatientID , a.episode1_start, a.episode1_end,b.StartDate, b.EndDate, b.LineName, a.death_date
from _02_first_epi as a
inner join _02_pt_regimen as b
on a.PatientID=b.PatientID
order by b.PatientID, b.StartDate;
quit ; /*5330*/
/* WHEN PATIENT STARTS THE SECOND EPISODE */
data _02_second_epi2;
set _02_second_epi ;
format episode2_start episode2_end mmddyy10. ;
by PatientID StartDate ;
episode2_start = episode1_end+1 ;
if (episode2_start le EndDate) then do ;
episode2_start =max(StartDate, episode2_start) ;
episode2_end= episode2_start +180 ;
output ;
end ;
run ;
/*NOW WE WANT TO ADD A DO LOOP THAT WILL CHANGE OUR EPISODE2_START = EPISODE1_END +1 EVERY TIME WE CALCULATE THE NEXT EPISODE,
FOR EG. EPISODE3_START = EPISODE2_END+1 AND SO ON */
proc sort data = _02_second_epi2 ;
by PatientID episode2_start ;
run ;
data _02_second_test ;
set _02_second_epi2 ;
by PatientID episode2_start ;
if first.PatientID ;
run ;
| F002F4C07392F | 08/19/2015 | 02/15/2016 | 08/19/2015 | 04/05/2016 | FOLFIRINOX | 02/16/2016 | 08/14/2016 |
| 2 | F002F4C07392F | 08/19/2015 | 02/15/2016 | 04/06/2016 | 05/11/2016 | Gemcitabine,Paclitaxel Protein-Bound | 04/06/2016 | 10/03/2016 |
| 3 | F00314B361B6A | 11/28/2016 | 05/27/2017 | 11/28/2016 | 08/21/2017 | Gemcitabine,Paclitaxel Protein-Bound | 05/28/2017 | 11/24/2017 |
| 4 | F00314B361B6A | 11/28/2016 | 05/27/2017 | 08/22/2017 | 03/07/2018 | FOLFOX | 08/22/2017 | 02/18/2018 |
| 5 | F007499692F0D | 08/28/2017 | 02/24/2018 | 11/01/2017 | 03/26/2018 | Gemcitabine,Paclitaxel Protein-Bound | 02/25/2018 | 08/24/2018 |
| 6 | F00CC20661EE3 | 10/19/2015 | 04/16/2016 | 10/19/2015 | 05/03/2016 | Gemcitabine,Paclitaxel Protein-Bound | 04/17/2016 | 10/14/2016 |
| 7 | F00CC20661EE3 | 10/19/2015 | 04/16/2016 | 05/04/2016 | 05/09/2016 | FOLFIRINOX | 05/04/2016 | 10/31/2016 |
| 8 | F015E4ADD6564 | 10/11/2016 | 10/15/2016 | 10/11/2016 | 10/28/2016 | FOLFOX | 10/16/2016 | 04/14/2017 |
| 9 | F016977DDEFE8 | 05/04/2016 | 10/31/2016 | 09/21/2016 | 05/24/2017 | Gemcitabine,Paclitaxel Protein-Bound | 11/01/2016 | 04/30/2017 |
| 10 | F016AAE0393FF | 07/31/2015 | 12/15/2015 | 07/31/2015 | 12/22/2015 | Gemcitabine,Paclitaxel Protein-Bound | 12/16/2015 | 06/13/2016 |
Now i want it to show me for all episodes eg, episode 3 ,4 ,5 and so on until the very end that is EndDate reaches. I have to use a do loop but i am not sure how many iterations I would need for it.
Click image to register for webinar
