gen str filenumber1 =substr( filenumber ,1,10) order filenumber1 , before( filenumber) label var filenumber1 "UCI id" sum Age,de preserve drop if Specifyotherdiagnosis=="." tab Specifyotherdiagnosis duplicates tag Srno , generate(dupvarSrno) duplicates tag filenumber1, generate(dupvarUCIID) *****************///// Non-Hodgkin lymphoma *//////////////////////////// gen NHL= 1 if strpos( Specifyotherdiagnosis , "NON HODGKINS LYMPHOMA") replace NHL= 1 if strpos( Specifyotherdiagnosis , "Non Hodgkins Lymphoma") replace NHL= 1 if strpos( Specifyotherdiagnosis , "NHL") gen BL= 1 if strpos( Specifyotherdiagnosis , "BURKITTS LYMPHOMA") replace BL= 1 if strpos( Specifyotherdiagnosis , "BL") gen HGLL= 1 if strpos( Specifyotherdiagnosis , "HIGH GRADE LYMPHOBLASTIC LYMPHOMA") gen HGL= 1 if strpos( Specifyotherdiagnosis , "High Grade Lymphoma") gen MCL= 1 if strpos( Specifyotherdiagnosis , "MANTLE CELL LYMPHOMA") gen MF= 1 if strpos( Specifyotherdiagnosis , "Mycosis Fungoides") gen Otherdiagnosis=1 if NHL==1 replace Otherdiagnosis=2 if BL==1 replace Otherdiagnosis=3 if HGLL==1 replace Otherdiagnosis=4 if HGL==1 replace Otherdiagnosis=5 if MCL==1 replace Otherdiagnosis=6 if MF==1 label define Otherdiagnosis 1 "NHL" 2 "BL" 3 "HGLL" 4 "HGL" 5 "MCL" 6 "MF" label value Otherdiagnosis Otherdiagnosis tab Otherdiagnosis tab Lymphomastage restore tab Lymphomastage tab comorbidity tab comorbidity,m tab ECOGbeforechemotherapy tab ECOGbeforechemotherapy,m tab BSymptoms tab Bmi preserve drop Bmi drop BMI generate BMI = (Weight/height)*100 tab BMI sum BMI,de gen studyarm=1 if EPOCHregimen!=. replace studyarm=0 if CHOPRegimen!=. label var studyarm "Study Arm" label var surtimedays "Survival time in days" replace Dateoflastencounter = date("10jan2012","DMY") in 83 replace surtimedays = Dateoflastencounter - Enrolmentdate label define studyarm 1 "EPOCH" 0 "CHOP" label value studyarm studyarm replace surtimemonths=surtimedays/30 gen surtimeyears=surtimedays/365 label var surtimemonths "Survival time in months" label var surtimeyears "Survival time in years" gen analysed=1 if Age>=18 replace analysed=0 if analysed==. gen Diagnosis_1= Diagnosis recode Diagnosis_1 (3=2) (4=3) (5=9) replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "NHL") replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "HODGKINS") replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "Hodgkins") replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "MANTLE CELL LYMPHOMA") replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "High Grade Lymphoma") replace Diagnosis_1 = 5 if strpos( Specifyotherdiagnosis , "BL") replace Diagnosis_1 = 5 if strpos( Specifyotherdiagnosis , "BURKITTS LYMPHOMA") replace Diagnosis_1 = 5 if strpos( Specifyotherdiagnosis , "NHL Burkitts type") replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "HIGH GRADE LYMPHOBLASTIC LYMPHOMA") replace Diagnosis_1 = 4 if strpos( Specifyotherdiagnosis , "Mycosis Fungoides") label define Diagnosis_1 1 "Diffuse large B-cell lymphoma (DLBCL)" 2 "Diffuse Large cell lymphoma" 3 "Plasmablastic lymphoma" 4 "NHL Other" 5 "Burkitts" 9 "Other Cancer" label value Diagnosis_1 Diagnosis_1 gen Mortalityoutcome_1= Mortalityoutcome recode Mortalityoutcome_1 (1 4=0) (2=1) (3=2) label define Mortalityoutcome_1 0 "Alive" 1 "Dead" 2 "Lossed to FUP" label value Mortalityoutcome_1 Mortalityoutcome_1 label var Mortalityoutcome_1 "Mortality 3 groups" gen Mortalityoutcome_2= Mortalityoutcome recode Mortalityoutcome_2 (1 3 4=0) (2=1) label define Mortalityoutcome_2 0 "Alive" 1 "Dead" label value Mortalityoutcome_2 Mortalityoutcome_2 label var Mortalityoutcome_2 "Mortality 2 groups" gen Weight_1=Weight gen height_1=height gen BMI_1=BMI replace Weight_1=60.06 if Weight==. replace height_1=166.85 if height==. replace BMI_1=35.96 if BMI==. rename ECOGbeforechemotherapy ECOG recode ECOG (.=6) label define yn 0 "No" 1 "Yes" recode comorbidity (2=0) recode comorbidity (.=0) label value comorbidity yn recode gender (2=0) label define gender 0 "Female" 1 "Male" label value gender gender recode BSymptoms (2=0) label value BSymptoms yn replace rxcompleted=1 if EPOCHcompletion==1 replace rxcompleted=1 if CHOPCompletion==1 & rxcompleted==. replace rxcompleted=0 if rxcompleted==. label var rxcompleted "Rx completed as prescribed" label value rxcompleted yn rename TenofovirLamivudineEfavirenzStar TLE_Start rename TenofovirLamivudineEfavirenzStop TLE_Stop rename TenofovirLamivudineEfavirenzModi TLE_Modi rename ZidovudineLamivudineEfavirenzSta ZLE_Start rename ZidovudineLamivudineEfavirenzSto ZLE_Stop rename ZidovudineLamivudineEfavirenzMod ZLE_Modi rename TenofovirLamivudineNevirapineSta TLN_Start rename TenofovirLamivudineNevirapineSto TLN_Stop rename TenofovirLamivudineNevirapineMod TLN_Modi rename ZidovudineLamivudineNevirapineSt ZLN_Start rename V1 ZLN_Stop rename ZidovudineLamivudineNevirapineMo ZLN_Modi rename AbacavirLamivudineDolutegravirSt ALD_Start rename V2 ALD_Stop rename AbacavirLamivudineDolutegravirMo ALD_Modi rename AbacavirLamivudineEfavirenzStart ALE_Start rename AbacavirLamivudineEfavirenzStopd ALE_Stop rename AbacavirLamivudineEfavirenzModif ALE_Modi rename AbacavirLamivudineNevirapineStar ALN_Start rename AbacavirLamivudineNevirapineStop ALN_Stop rename AbacavirLamivudineNevirapineModi ALN_Modi rename Specifystartdateotherfirstlineag OtherFirstline_Start rename Specifystopdateotherfirstlineage OtherFirstline_Stop rename Specifymodificationotherfirstlin OtherFirstline_Modi rename TenofovirLamivudineAtazanavir_ri TLA2_Start rename V3 TLA2_Stop rename V4 TLA2_Modi rename ZidovudineLamivudineAtazanavir_r ZLA_Start rename V5 ZLA_Stop rename V6 ZLA_Modi rename AbacavirLamivudineAtazanavir_rit ALA_Start rename V7 ALA_Stop rename V8 ALA_Modi rename TenofovirLamivudineLopinavir_rit TLL_Start rename V9 TLL_Stop rename V10 TLL_Modi rename ZidovudineLamivudineLopinavir_ri ZLL_Start rename V11 ZLL_Stop rename V12 ZLL_Modi rename AbacavirLamivudineLopinavir_rito ALL_Start rename V13 ALL_Stop rename V14 ALL_Modi rename Specifystartdateforothersecondli Other2nsline_Start rename Specifystopdateforothersecondlin Other2nsline_Stop rename Specifymodificationforothersecon Other2nsline_Modi rename responsetochemotherapy DiseaseResponse rename Waschemotherapyinterrupted Chemo_interrupted rename reasonfornoncompletionofchemothe Reasonfornoncompletionofchemo recode DiseaseResponse (.=5) recode Reasonfornoncompletionofchemo (.=3) recode TLE_Start - ALN_Modi OtherFirstline_Start - ALL_Modi Other2nsline_Start - DapsoneModification Specifystartdateforotherconcomit Specifystopdateforotherconcomita modificationforotherconcomitantm (.=0) label define modif 0 "NA" 1 "Switch" 2 "Suspension" 3 "None", modify label values TLE_Modi ZLE_Modi TLN_Modi ZLN_Modi ALD_Modi ALE_Modi ALN_Modi OtherFirstline_Modi modif label values TLA2_Modi ZLA_Modi ALA_Modi TLL_Modi ZLL_Modi ALL_Modi Other2nsline_Modi modif label define start 0 "Not started" 1 "Before chemo" 2 "With chemo" 3 "After chemo", modify label values TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart start recode TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart (1/2=1) (3=2) recode TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart (2=0) label define start1 0 "Not started" 1 "Before/With chemo" label values TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart start1 recode TLA2_Start ZLA_Start ALA_Start TLL_Start ZLL_Start ALL_Start Other2nsline_Start (0 3=0) (1/2=1) label values TLA2_Start ZLA_Start ALA_Start TLL_Start ZLL_Start ALL_Start Other2nsline_Start start1 gen ARVs_2ndline=1 if TLA2_Start==1 | ZLA_Start==1 | ALA_Start==1 | TLL_Start==1 | ZLL_Start==1 | ALL_Start==1 replace ARVs_2ndline=0 if ARVs_2ndline==. label value ARVs_2ndline start1 order ARVs_2ndline, after(ALL_Modi) label var ARVs_2ndline "On second line ARVs" recode CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 (0/.=.) replace CotrimoStartdt_1= CotrimoStartdt replace DapsoneStartdate_1= DapsoneStartdate replace otherconcostartdt_1= otherconcostartdt label value CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 start recode CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 (1/2=1) (3=2) label define start2 0 "Not started" 1 "Before/With chemo" 2 "After chemo", modify label value CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 start2 *recode CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 (0 3=0) (1/2=1) *label value CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 start1 order CotrimoStartdt_1, after(CotrimoStartdt) order DapsoneStartdate_1, after(DapsoneStartdate) order otherconcostartdt_1, after(otherconcostartdt) recode Chemo_interrupted (2=0) label value Chemo_interrupted yn gen Mortalityoutcome_11= Mortalityoutcome label define Mortalityoutcome_11 1 "Alive after 1 years from time of enrol1mentto UCI" 2 "Died before 1 year follow up period" 3 "Loss to follow up before end of 1 yr FUP period" 0 "Still on follow up, not yet completed 1 yr of FUP" label value Mortalityoutcome_11 Mortalityoutcome_11 recode Mortalityoutcome_11 (4=0) gen DiseaseResponse_11=DiseaseResponse recode DiseaseResponse_11 (5=0) label define DiseaseResponse_11 3 "Stable disease" 1 "Complete response" 2 "Partial response" 4 "Progressive disease" 0 "No restaging done" label value DiseaseResponse_11 DiseaseResponse_11 replace reasonforinterruption_11=reasonforinterruption recode reasonforinterruption_11 (3=0) label define reasonforinterruption_11 1 "Adverse events" 2 "Other" 0 "NA" 4 "Unknown", modify label value reasonforinterruption_11 reasonforinterruption_11 label define reasonforinterruption 1 "Adverse events" 2 "Other" 3 "NA" 4 "Unknown", modify label value reasonforinterruption reasonforinterruption label define Reasonfornoncompletionofchemo 1 "Adverse events" 2 "Other" 3 "NA" 4 "Unknown", modify label value Reasonfornoncompletionofchemo Reasonfornoncompletionofchemo replace Reasonfornoncompletionofchemo_11=Reasonfornoncompletionofchemo recode Reasonfornoncompletionofchemo_11 (3=0) label define Reasonfornoncompletionofchemo_11 1 "Adverse events" 2 "Other" 0 "NA" 4 "Unknown", modify label value Reasonfornoncompletionofchemo_11 Reasonfornoncompletionofchemo_11 gen BMI_2= Weight_1 * 100 * 100/ (height_1 * height_1) tabstat Age Weight_1 height_1 BMI_2, stat(n mean sd q iqr min max range) bysort studyarm: tabstat Age Weight_1 height_1 BMI_2, stat(n mean sd q iqr min max range) ttest Age, by(studyarm) ttest BMI_2, by(studyarm) ttest Weight_1, by(studyarm) ttest height_1, by(studyarm) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout gender studyarm using Table1.xls, cell(freq col) tabout Diagnosis_1 studyarm using Table1.xls, cell(freq col) append tabout ECOG studyarm using Table1.xls, cell(freq col) append tabout BSymptoms studyarm using Table1.xls, cell(freq col) append tabout comorbidity studyarm using Table1.xls, cell(freq col) append tabout Lymphomastage studyarm using Table1.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart gender Diagnosis_1 ECOG BSymptoms comorbidity Lymphomastage, file(Table11.xlsx) by(studyarm) conprec(1) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout TLE_Start studyarm using Table2.xls, cell(freq col) tabout ZLE_Start studyarm using Table2.xls, cell(freq col) append tabout TLN_Start studyarm using Table2.xls, cell(freq col) append tabout ZLN_Start studyarm using Table2.xls, cell(freq col) append tabout ALD_Start studyarm using Table2.xls, cell(freq col) append tabout ALE_Start studyarm using Table2.xls, cell(freq col) append tabout ALN_Start studyarm using Table2.xls, cell(freq col) append tabout OtherFirstlineStart studyarm using Table2.xls, cell(freq col) append tabout TLA2_Start studyarm using Table2.xls, cell(freq col) tabout ZLA_Start studyarm using Table2.xls, cell(freq col) append tabout ALA_Start studyarm using Table2.xls, cell(freq col) append tabout TLL_Start studyarm using Table2.xls, cell(freq col) append tabout ZLL_Start studyarm using Table2.xls, cell(freq col) append tabout ALL_Start studyarm using Table2.xls, cell(freq col) append tabout ARVs_2ndline studyarm using Table2.xls, cell(freq col) append tabout Other2nsline_Start studyarm using Table2.xls, cell(freq col) append tabout CotrimoStartdt_1 studyarm using Table2.xls, cell(freq col) append tabout DapsoneStartdate_1 studyarm using Table2.xls, cell(freq col) append tabout otherconcostartdt_1 studyarm using Table2.xls, cell(freq col) append tabout numberofcycles_1 studyarm using Table2.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart TLA2_Start ZLA_Start ALA_Start TLL_Start ZLL_Start ALL_Start ARVs_2ndline Other2nsline_Start CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 numberofcycles_1, file(Table22.xlsx) by(studyarm) conprec(1) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout TLE_Stop studyarm using Table3.xls, cell(freq col) tabout ZLE_Stop studyarm using Table3.xls, cell(freq col) append tabout TLN_Stop studyarm using Table3.xls, cell(freq col) append tabout ZLN_Stop studyarm using Table3.xls, cell(freq col) append tabout ALD_Stop studyarm using Table3.xls, cell(freq col) append tabout ALE_Stop studyarm using Table3.xls, cell(freq col) append tabout ALN_Stop studyarm using Table3.xls, cell(freq col) append tabout OtherFirstline_Stop studyarm using Table3.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout TLE_Modi studyarm using Table4.xls, cell(freq col) tabout ZLE_Modi studyarm using Table4.xls, cell(freq col) append tabout TLN_Modi studyarm using Table4.xls, cell(freq col) append tabout ZLN_Modi studyarm using Table4.xls, cell(freq col) append tabout ALD_Modi studyarm using Table4.xls, cell(freq col) append tabout ALE_Modi studyarm using Table4.xls, cell(freq col) append tabout ALN_Modi studyarm using Table4.xls, cell(freq col) append tabout OtherFirstline_Modi studyarm using Table4.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart TLE_Modi ZLE_Modi TLN_Modi ZLN_Modi ALD_Modi ALE_Modi ALN_Modi OtherFirstline_Modi, file(Table44.xlsx) by(studyarm) conprec(1) order numberofcycles_1, after(numberofcycles) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout TLA2_Start studyarm using Table5.xls, cell(freq col) tabout ZLA_Start studyarm using Table5.xls, cell(freq col) append tabout ALA_Start studyarm using Table5.xls, cell(freq col) append tabout TLL_Start studyarm using Table5.xls, cell(freq col) append tabout ZLL_Start studyarm using Table5.xls, cell(freq col) append tabout ALL_Start studyarm using Table5.xls, cell(freq col) append tabout ARVs_2ndline studyarm using Table5.xls, cell(freq col) append tabout Other2nsline_Start studyarm using Table5.xls, cell(freq col) append tabout CotrimoStartdt_1 studyarm using Table5.xls, cell(freq col) append tabout DapsoneStartdate_1 studyarm using Table5.xls, cell(freq col) append tabout otherconcostartdt_1 studyarm using Table5.xls, cell(freq col) append tabout numberofcycles_1 studyarm using Table5.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart TLA2_Start ZLA_Start ALA_Start TLL_Start ZLL_Start ALL_Start ARVs_2ndline Other2nsline_Start CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 numberofcycles_1, file(Table55.xlsx) by(studyarm) conprec(1) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout TLA2_Stop studyarm using Table6.xls, cell(freq col) tabout ZLA_Stop studyarm using Table6.xls, cell(freq col) append tabout ALA_Stop studyarm using Table6.xls, cell(freq col) append tabout TLL_Stop studyarm using Table6.xls, cell(freq col) append tabout ZLL_Stop studyarm using Table6.xls, cell(freq col) append tabout ALL_Stop studyarm using Table6.xls, cell(freq col) append tabout Other2nsline_Stop studyarm using Table6.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout TLA2_Modi studyarm using Table7.xls, cell(freq col) tabout ZLA_Modi studyarm using Table7.xls, cell(freq col) append tabout ALA_Modi studyarm using Table7.xls, cell(freq col) append tabout TLL_Modi studyarm using Table7.xls, cell(freq col) append tabout ZLL_Modi studyarm using Table7.xls, cell(freq col) append tabout ALL_Modi studyarm using Table7.xls, cell(freq col) append tabout Other2nsline_Modi studyarm using Table7.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout CotrimoxazoleStartdate studyarm using Table8.xls, cell(freq col) tabout DapsoneStartdate studyarm using Table8.xls, cell(freq col) append tabout Specifystartdateforotherconcomit studyarm using Table8.xls, cell(freq col) append tabout CotrimoxazoleStopdate studyarm using Table8.xls, cell(freq col) append tabout DapsoneStopdate studyarm using Table8.xls, cell(freq col) append tabout Specifystopdateforotherconcomita studyarm using Table8.xls, cell(freq col) append tabout CotrimoxazoleModification studyarm using Table8.xls, cell(freq col) append tabout DapsoneModification studyarm using Table8.xls, cell(freq col) append tabout modificationforotherconcomitantm studyarm using Table8.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout rxcompleted studyarm using Table99.xls, cell(freq col) tabout Reasonfornoncompletionofchemo_11 studyarm using Table99.xls, cell(freq col) append tabout Chemo_interrupted studyarm using Table99.xls, cell(freq col) append tabout reasonforinterruption_11 studyarm using Table99.xls, cell(freq col) append tabout DiseaseResponse studyarm using Table99.xls, cell(freq col) append tabout Mortalityoutcome studyarm using Table99.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart rxcompleted Reasonfornoncompletionofchemo_11 Chemo_interrupted reasonforinterruption_11 DiseaseResponse_11 Mortalityoutcome_11, file(Table99_1.xlsx) by(studyarm) conprec(1) tab1 rxcompleted Reasonfornoncompletionofchemo_11 Chemo_interrupted reasonforinterruption_11 DiseaseResponse_11 Mortalityoutcome_11 tab1 rxcompleted Reasonfornoncompletionofchemo_11 Chemo_interrupted reasonforinterruption_11 DiseaseResponse_11 Mortalityoutcome_11, nol tabulate rxcompleted studyarm, chi2 exact tabulate Reasonfornoncompletionofchemo_11 studyarm, chi2 exact tabulate Chemo_interrupted studyarm, chi2 exact tabulate reasonforinterruption_11 studyarm, chi2 exact tabulate DiseaseResponse studyarm, chi2 exact tabulate Mortalityoutcome studyarm, chi2 exact cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *rename OtherFirstline_Start OtherFirstlineStart partchart TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart, file(Table20.xlsx) by(studyarm) conprec(1) partchart TLE_Stop ZLE_Stop TLN_Stop ZLN_Stop ALD_Stop ALE_Stop ALN_Stop OtherFirstline_Stop, file(Table21.xlsx) by(studyarm) conprec(1) partchart TLE_Modi ZLE_Modi TLN_Modi ZLN_Modi ALD_Modi ALE_Modi ALN_Modi OtherFirstline_Modi, file(Table22.xlsx) by(studyarm) conprec(1) partchart TLA2_Start ZLA_Start ALA_Start TLL_Start ZLL_Start ALL_Start Other2nsline_Start, file(Table23.xlsx) by(studyarm) conprec(1) partchart TLA2_Stop ZLA_Stop ALA_Stop TLL_Stop ZLL_Stop ALL_Stop Other2nsline_Stop, file(Table24.xlsx) by(studyarm) conprec(1) partchart TLA2_Modi ZLA_Modi ALA_Modi TLL_Modi ZLL_Modi ALL_Modi Other2nsline_Modi, file(Table25.xlsx) by(studyarm) conprec(1) partchart CotrimoStartdt CotrimoxazoleStodt CotrimoModif, file(Table26.xlsx) by(studyarm) conprec(1) partchart DapsoneStartdate DapsoneStopdate DapsoneModification, file(Table27.xlsx) by(studyarm) conprec(1) partchart otherconcostartdt otherconcostopdt otherconcomodif, file(Table28.xlsx) by(studyarm) conprec(1) *rename Specifystartdateforotherconcomit otherconcostartdt *rename Specifystopdateforotherconcomita otherconcostopdt *rename modificationforotherconcomitantm otherconcomodif gen chemoNOTcompleted_1=1 if AnaemiaHbg_dLatbaseline!=. | AnaemiaHbgdLGradeatbaseline!=. | AnaemiaHbg_dLCycle1!=. | AnaemiaHbgdLGradeCycle1!=. | /// AnaemiaHbg_dLCycle2!=. | AnaemiaHbgdLGradeCycle2!=. | AnaemiaHbg_dLCycle3!=. | AnaemiaHbgdLGradeCycle3!=. | /// AnaemiaHbg_dLCycle4!=. | AnaemiaHbgdLGradeCycle4!=. | AnaemiaHbg_dLCycle5!=. | AnaemiaHbgdLGradeCycle5!=. | /// AnaemiaHbg_dLCycle6!=. | AnaemiaHbgdLGradeCycle6!=. | /// Thrombocytopenia_mm3baseline!=. | Thrombocytopenia_mm3Gradeatbasel!=. | Thrombocytopenia_mm3Cycle1!=. | Thrombocytopenia_mm3GradeCycle1!=. | /// Thrombocytopenia_mm3Cycle2!=. | Thrombocytopenia_mm3GradeCycle2!=. | Thrombocytopenia_mm3Cycle3!=. | Thrombocytopenia_mm3GradeCycle3!=. | /// Thrombocytopenia_mm3Cycle4!=. | Thrombocytopenia_mm3GradeCycle4!=. | Thrombocytopenia_mm3Cycle5!=. | Thrombocytopenia_mm3GradeCycle5!=. | /// Thrombocytopenia_mm3Cycle6!=. | Thrombocytopenia_mm3GradeCycle6!=. | /// ElevatedtotalBilirubinumol_Lbase!=. | ElevatedtotalBilirubinumol_LGrad!=. | ElevatedtotalBilirubinumol_LCycl!=. | V15!=. | /// V16!=. | V17!=. | V18!=. | V19!=. | /// V20!=. | V21!=. | V22!=. | V23!=. | /// V24!=. | V25!=. | /// ElevatedALTIUbaseline!=. | ElevatedALTIUGradebaseline!=. | ElevatedALTIUCycle1!=. | ElevatedALTIUGradeCycle1!=. | /// ElevatedALTIUCycle2!=. | ElevatedALTIUGradeCycle2!=. | ElevatedALTIUCycle3!=. | ElevatedALTIUGradeCycle3!=. | /// ElevatedALTIUCycle4!=. | ElevatedALTIUGradeCycle4!=. | ElevatedALTIUCycle5!=. | ElevatedALTIUGradeCycle5!=. | /// ElevatedALTIUCycle6!=. | ElevatedALTIUGradeCycle6!=. | /// ElevatedASTIUbaseline!=. | ElevatedASTIUGradebaseline!=. | ElevatedASTIUCycle1!=. | ElevatedASTIUGradeCycle1!=. | /// ElevatedASTIUCycle2!=. | ElevatedASTIUGradeCycle2!=. | ElevatedASTIUCycle3!=. | ElevatedASTIUGradeCycle3!=. | /// ElevatedASTIUCycle4!=. | ElevatedASTIUGradeCycle4!=. | ElevatedASTIUCycle5!=. | ElevatedASTIUGradeCycle5!=. | /// ElevatedASTIUCycle6!=. | ElevatedASTIUGradeCycle6!=. | /// ElevatedLDHIUbaseline!=. | ElevatedLDHIUGradebaseline!=. | ElevatedLDHIUCycle1!=. | ElevatedLDHIUGradeCycle1!=. | /// ElevatedLDHIUCycle2!=. | ElevatedLDHIUGradeCycle2!=. | ElevatedLDHIUCycle3!=. | ElevatedLDHIUGradeCycle3!=. | /// ElevatedLDHIUCycle4!=. | ElevatedLDHIUGradeCycle4!=. | ElevatedLDHIUCycle5!=. | ElevatedLDHIUGradeCycle5!=. | /// ElevatedLDHIUCycle6!=. | ElevatedLDHIUGradeCycle6!=. | /// OtherAEatbaseline!=. | OtherAEGradebaseline!=. | OtherAECycle1!=. | OtherAEGradeCycle1!=. | /// OtherAECycle2!=. | OtherAEGradeCycle2!=. | OtherAECycle3!=. | OtherAEGradeCycle3!=. | /// OtherAECycle4!=. | OtherAEGradeCycle4!=. | OtherAECycle5!=. | OtherAEGradeCycle5!=. | /// OtherAECycle6!=. | OtherAEGradeCycle6!=. gen chemointerrupted_1=1 if AnaemiaHbg_dLatCycle1_reasonfori!=. | AnaemiaHbg_dLGradeatCycle1_reaso!=. | AnaemiaHbg_dLatCycle2_reasonfori!=. | AnaemiaHbg_dLGradeatCycle2_reaso!=. | /// AnaemiaHbg_dLatCycle3_reasonfori!=. | AnaemiaHbg_dLGradeatCycle3_reaso!=. | AnaemiaHbg_dLatCycle4_reasonfori!=. | AnaemiaHbg_dLGradeatCycle4_reaso!=. | /// AnaemiaHbg_dLatCycle5_reasonfori!=. | AnaemiaHbg_dLGradeatCycle5_reaso!=. | AnaemiaHbg_dLatCycle6_reasonfori!=. | AnaemiaHbg_dLGradeatCycle6_reaso!=. | /// Thrombocytopenia_mm3Cycle1_reaso!=. | Thrombocytopenia_mm3GradeCycle1_!=. | Thrombocytopenia_mm3Cycle2_reaso!=. | Thrombocytopenia_mm3GradeCycle2_!=. | /// Thrombocytopenia_mm3Cycle3_reaso!=. | Thrombocytopenia_mm3GradeCycle3_!=. | Thrombocytopenia_mm3Cycle4_reaso!=. | Thrombocytopenia_mm3GradeCycle4_!=. | /// Thrombocytopenia_mm3Cycle5_reaso!=. | Thrombocytopenia_mm3GradeCycle5_!=. | Thrombocytopenia_mm3Cycle6_reaso!=. | Thrombocytopenia_mm3GradeCycle6_!=. | /// ElevatedtotalBilirubinumol_LatCy!=. | V26!=. | V27!=. | V28!=. | /// V29!=. | V30!=. | V31!=. | V32!=. | /// V33!=. | V34!=. | V35!=. | V36!=. | /// ElevatedALTIUatCycle1_reasonfori!=. | ElevatedALTIUGradeatCycle1_reaso!=. | ElevatedALTIUatCycle2_reasonfori!=. | ElevatedALTIUGradeatCycle2_reaso!=. | /// ElevatedALTIUatCycle3_reasonfori!=. | ElevatedALTIUGradeatCycle3_reaso!=. | ElevatedALTIUatCycle4_reasonfori!=. | ElevatedALTIUGradeatCycle4_reaso!=. | /// ElevatedALTIUatCycle5_reasonfori!=. | ElevatedALTIUGradeatCycle5_reaso!=. | ElevatedALTIUatCycle6_reasonfori!=. | ElevatedALTIUGradeatCycle6_reaso!=. | /// ElevatedASIUatCycle1_reasonforin!=. | ElevatedASIUGradeatCycle1_reason!=. | ElevatedASIUatCycle2_reasonforin!=. | ElevatedASIUGradeatCycle2_reason!=. | /// ElevatedASIUatCycle3_reasonforin!=. | ElevatedASIUGradeatCycle3_reason!=. | ElevatedASIUatCycle4_reasonforin!=. | ElevatedASIUGradeatCycle4_reason!=. | /// ElevatedASIUatCycle5_reasonforin!=. | ElevatedASIUGradeatCycle5_reason!=. | ElevatedASIUatCycle6_reasonforin!=. | ElevatedASIUGradeatCycle6_reason!=. | /// ElevatedLDHIUatCycle1_reasonfori!=. | ElevatedLDHIUGradeatCycle1_reaso!=. | ElevatedLDHIUatCycle2_reasonfori!=. | ElevatedLDHIUGradeatCycle2_reaso!=. | /// ElevatedLDHIUatCycle3_reasonfori!=. | ElevatedLDHIUGradeatCycle3_reaso!=. | ElevatedLDHIUatCycle4_reasonfori!=. | ElevatedLDHIUGradeatCycle4_reaso!=. | /// ElevatedLDHIUatCycle5_reasonfori!=. | ElevatedLDHIUGradeatCycle5_reaso!=. | ElevatedLDHIUatCycle6_reasonfori!=. | ElevatedLDHIUGradeatCycle6_reaso!=. | /// OtherAEatCycle1_reasonforinterru!=. | OtherAEGradeatCycle1_reasonforin!=. | OtherAEatCycle2_reasonforinterru!=. | OtherAEGradeatCycle2_reasonforin!=. | /// OtherAEatCycle3_reasonforinterru!=. | OtherAEGradeatCycle3_reasonforin!=. | OtherAEatCycle4_reasonforinterru!=. | OtherAEGradeatCycle4_reasonforin!=. | /// OtherAEatCycle5_reasonforinterru!=. | OtherAEGradeatCycle5_reasonforin!=. | OtherAEatCycle6_reasonforinterru!=. | OtherAEGradeatCycle6_reasonforin!=. gen Anaemia_bl=1 if AnaemiaHbg_dLatbaseline!=. gen Anaemia_Cycle1=1 if AnaemiaHbg_dLCycle1!=. gen Anaemia_Cycle2=1 if AnaemiaHbg_dLCycle2!=. gen Anaemia_Cycle3=1 if AnaemiaHbg_dLCycle3!=. gen Anaemia_Cycle4=1 if AnaemiaHbg_dLCycle4!=. gen Anaemia_Cycle5=1 if AnaemiaHbg_dLCycle5!=. gen Anaemia_Cycle6=1 if AnaemiaHbg_dLCycle6!=. gen Thrombocytopenia_bl=1 if Thrombocytopenia_mm3baseline!=. gen Thrombocytopenia_Cyclel=1 if Thrombocytopenia_mm3Cycle1!=. gen Thrombocytopenia_Cycle2=1 if Thrombocytopenia_mm3Cycle2!=. gen Thrombocytopenia_Cycle3=1 if Thrombocytopenia_mm3Cycle3!=. gen Thrombocytopenia_Cycle4=1 if Thrombocytopenia_mm3Cycle4!=. gen Thrombocytopenia_Cycle5=1 if Thrombocytopenia_mm3Cycle5!=. gen Thrombocytopenia_Cycle6=1 if Thrombocytopenia_mm3Cycle6!=. gen Bilirubin_bl=1 if ElevatedtotalBilirubinumol_Lbase!=. gen Bilirubin_Cyclel=1 if ElevatedtotalBilirubinumol_LCycl!=. gen Bilirubin_Cycle2=1 if V16!=. gen Bilirubin_Cycle3=1 if V18!=. gen Bilirubin_Cycle4=1 if V20!=. gen Bilirubin_Cycle5=1 if V22!=. gen Bilirubin_Cycle6=1 if V24!=. gen ALT_bl=1 if ElevatedALTIUbaseline!=. gen ALT_Cyclel=1 if ElevatedALTIUCycle1!=. gen ALT_Cycle2=1 if ElevatedALTIUCycle2!=. gen ALT_Cycle3=1 if ElevatedALTIUCycle3!=. gen ALT_Cycle4=1 if ElevatedALTIUCycle4!=. gen ALT_Cycle5=1 if ElevatedALTIUCycle5!=. gen ALT_Cycle6=1 if ElevatedALTIUCycle6!=. gen AST_bl=1 if ElevatedASTIUbaseline!=. gen AST_Cyclel=1 if ElevatedASTIUCycle1!=. gen AST_Cycle2=1 if ElevatedASTIUCycle2!=. gen AST_Cycle3=1 if ElevatedASTIUCycle3!=. gen AST_Cycle4=1 if ElevatedASTIUCycle4!=. gen AST_Cycle5=1 if ElevatedASTIUCycle5!=. gen AST_Cycle6=1 if ElevatedASTIUCycle6!=. gen LDH_bl=1 if ElevatedLDHIUbaseline!=. gen LDH_Cyclel=1 if ElevatedLDHIUCycle1!=. gen LDH_Cycle2=1 if ElevatedLDHIUCycle2!=. gen LDH_Cycle3=1 if ElevatedLDHIUCycle3!=. gen LDH_Cycle4=1 if ElevatedLDHIUCycle4!=. gen LDH_Cycle5=1 if ElevatedLDHIUCycle5!=. gen LDH_Cycle6=1 if ElevatedLDHIUCycle6!=. gen OtherAEs_bl=1 if OtherAEatbaseline!=. gen OtherAEs_Cycle1=1 if OtherAECycle1!=. gen OtherAEs_Cycle2=1 if OtherAECycle2!=. gen OtherAEs_Cycle3=1 if OtherAECycle3!=. gen OtherAEs_Cycle4=1 if OtherAECycle4!=. gen OtherAEs_Cycle5=1 if OtherAECycle5!=. gen OtherAEs_Cycle6=1 if OtherAECycle6!=. recode Anaemia_bl-OtherAEs_Cycle6 (.=3) if rxcompleted==1 recode Anaemia_bl-OtherAEs_Cycle6 (.=2) if rxcompleted==0 label define noncompletion 1 "Yes" 2 "Unknown" 3 "NA" label values Anaemia_bl-OtherAEs_Cycle6 noncompletion label var Anaemia_bl "Anaemia baseline" label var Anaemia_Cycle1 "Anaemia cycle 1" label var Anaemia_Cycle2 "Anaemia cycle 2" label var Anaemia_Cycle3 "Anaemia cycle 3" label var Anaemia_Cycle4 "Anaemia cycle 4" label var Anaemia_Cycle5 "Anaemia cycle 5" label var Anaemia_Cycle6 "Anaemia cycle 6" label var Thrombocytopenia_bl "Thrombocytopenia baseline" label var Thrombocytopenia_Cyclel "Thrombocytopenia cycle 1" label var Thrombocytopenia_Cycle2 "Thrombocytopenia cycle 2" label var Thrombocytopenia_Cycle3 "Thrombocytopenia cycle 3" label var Thrombocytopenia_Cycle4 "Thrombocytopenia cycle 4" label var Thrombocytopenia_Cycle5 "Thrombocytopenia cycle 5" label var Thrombocytopenia_Cycle6 "Thrombocytopenia cycle 6" label var Bilirubin_bl "Elevated Bilirubin baseline" label var Bilirubin_Cyclel "Elevated Bilirubin cycle 1" label var Bilirubin_Cycle2 "Elevated Bilirubin cycle 2" label var Bilirubin_Cycle3 "Elevated Bilirubin cycle 3" label var Bilirubin_Cycle4 "Elevated Bilirubin cycle 4" label var Bilirubin_Cycle5 "Elevated Bilirubin cycle 5" label var Bilirubin_Cycle6 "Elevated Bilirubin cycle 6" label var ALT_bl "Elevated ALT baseline" label var ALT_Cyclel "Elevated ALT cycle 1" label var ALT_Cycle2 "Elevated ALT cycle 2" label var ALT_Cycle3 "Elevated ALT cycle 3" label var ALT_Cycle4 "Elevated ALT cycle 4" label var ALT_Cycle5 "Elevated ALT cycle 5" label var ALT_Cycle6 "Elevated ALT cycle 6" label var AST_bl "Elevated AST baseline " label var AST_Cyclel "Elevated AST cycle 1" label var AST_Cycle2 "Elevated AST cycle 2" label var AST_Cycle3 "Elevated AST cycle 3" label var AST_Cycle4 "Elevated AST cycle 4" label var AST_Cycle5 "Elevated AST cycle 5" label var AST_Cycle6 "Elevated AST cycle 6" label var LDH_bl "Elevated LDH baseline" label var LDH_Cyclel "Elevated LDH cycle 1" label var LDH_Cycle2 "Elevated LDH cycle 2" label var LDH_Cycle3 "Elevated LDH cycle 3" label var LDH_Cycle4 "Elevated LDH cycle 4" label var LDH_Cycle5 "Elevated LDH cycle 5" label var LDH_Cycle6 "Elevated LDH cycle 6" label var OtherAEs_bl "Other AEs baseline" label var OtherAEs_Cycle1 "Other AEs cycle 1" label var OtherAEs_Cycle2 "Other AEs cycle 2" label var OtherAEs_Cycle3 "Other AEs cycle 3" label var OtherAEs_Cycle4 "Other AEs cycle 4" label var OtherAEs_Cycle5 "Other AEs cycle 5" label var OtherAEs_Cycle6 "Other AEs cycle 6" gen Anaemia_Cycle11=1 if AnaemiaHbg_dLatCycle1_reasonfori!=. gen Anaemia_Cycle22=1 if AnaemiaHbg_dLatCycle2_reasonfori!=. gen Anaemia_Cycle33=1 if AnaemiaHbg_dLatCycle3_reasonfori!=. gen Anaemia_Cycle44=1 if AnaemiaHbg_dLatCycle4_reasonfori!=. gen Anaemia_Cycle55=1 if AnaemiaHbg_dLatCycle5_reasonfori!=. gen Anaemia_Cycle66=1 if AnaemiaHbg_dLatCycle6_reasonfori!=. gen Thrombocytopenia_Cyclel1=1 if Thrombocytopenia_mm3Cycle1_reaso!=. gen Thrombocytopenia_Cycle22=1 if Thrombocytopenia_mm3Cycle2_reaso!=. gen Thrombocytopenia_Cycle33=1 if Thrombocytopenia_mm3Cycle3_reaso!=. gen Thrombocytopenia_Cycle44=1 if Thrombocytopenia_mm3Cycle4_reaso!=. gen Thrombocytopenia_Cycle55=1 if Thrombocytopenia_mm3Cycle5_reaso!=. gen Thrombocytopenia_Cycle66=1 if Thrombocytopenia_mm3Cycle6_reaso!=. gen Bilirubin_Cyclel1=1 if ElevatedtotalBilirubinumol_LatCy!=. gen Bilirubin_Cycle22=1 if V27!=. gen Bilirubin_Cycle33=1 if V29!=. gen Bilirubin_Cycle44=1 if V31!=. gen Bilirubin_Cycle55=1 if V33!=. gen Bilirubin_Cycle66=1 if V35!=. gen ALT_Cyclel1=1 if ElevatedALTIUatCycle1_reasonfori!=. gen ALT_Cycle22=1 if ElevatedALTIUatCycle2_reasonfori!=. gen ALT_Cycle33=1 if ElevatedALTIUatCycle3_reasonfori!=. gen ALT_Cycle44=1 if ElevatedALTIUatCycle4_reasonfori!=. gen ALT_Cycle55=1 if ElevatedALTIUatCycle5_reasonfori!=. gen ALT_Cycle66=1 if ElevatedALTIUatCycle6_reasonfori!=. gen AST_Cyclel1=1 if ElevatedASIUatCycle1_reasonforin!=. gen AST_Cycle22=1 if ElevatedASIUatCycle2_reasonforin!=. gen AST_Cycle33=1 if ElevatedASIUatCycle3_reasonforin!=. gen AST_Cycle44=1 if ElevatedASIUatCycle4_reasonforin!=. gen AST_Cycle55=1 if ElevatedASIUatCycle5_reasonforin!=. gen AST_Cycle66=1 if ElevatedASIUatCycle6_reasonforin!=. gen LDH_Cyclel1=1 if ElevatedLDHIUatCycle1_reasonfori!=. gen LDH_Cycle22=1 if ElevatedLDHIUatCycle2_reasonfori!=. gen LDH_Cycle33=1 if ElevatedLDHIUatCycle3_reasonfori!=. gen LDH_Cycle44=1 if ElevatedLDHIUatCycle4_reasonfori!=. gen LDH_Cycle55=1 if ElevatedLDHIUatCycle5_reasonfori!=. gen LDH_Cycle66=1 if ElevatedLDHIUatCycle6_reasonfori!=. gen OtherAEs_Cycle11=1 if OtherAEatCycle1_reasonforinterru!=. gen OtherAEs_Cycle22=1 if OtherAEatCycle2_reasonforinterru!=. gen OtherAEs_Cycle33=1 if OtherAEatCycle3_reasonforinterru!=. gen OtherAEs_Cycle44=1 if OtherAEatCycle4_reasonforinterru!=. gen OtherAEs_Cycle55=1 if OtherAEatCycle5_reasonforinterru!=. gen OtherAEs_Cycle66=1 if OtherAEatCycle6_reasonforinterru!=. recode Anaemia_Cycle11 - OtherAEs_Cycle66 (.=3) if Chemo_interrupted==0 recode Anaemia_Cycle11 - OtherAEs_Cycle66 (.=2) if Chemo_interrupted==1 label define forinterruption 1 "Yes" 2 "Unknown" 3 "NA" label values Anaemia_Cycle11 - OtherAEs_Cycle66 forinterruption label var Anaemia_Cycle11 "Anaemia cycle 1" label var Anaemia_Cycle22 "Anaemia cycle 2" label var Anaemia_Cycle33 "Anaemia cycle 3" label var Anaemia_Cycle44 "Anaemia cycle 4" label var Anaemia_Cycle55 "Anaemia cycle 5" label var Anaemia_Cycle66 "Anaemia cycle 6" label var Thrombocytopenia_Cyclel1 "Thrombocytopenia cycle 1" label var Thrombocytopenia_Cycle22 "Thrombocytopenia cycle 2" label var Thrombocytopenia_Cycle33 "Thrombocytopenia cycle 3" label var Thrombocytopenia_Cycle44 "Thrombocytopenia cycle 4" label var Thrombocytopenia_Cycle55 "Thrombocytopenia cycle 5" label var Thrombocytopenia_Cycle66 "Thrombocytopenia cycle 6" label var Bilirubin_Cyclel1 "Elevated Bilirubin cycle 1" label var Bilirubin_Cycle22 "Elevated Bilirubin cycle 2" label var Bilirubin_Cycle33 "Elevated Bilirubin cycle 3" label var Bilirubin_Cycle44 "Elevated Bilirubin cycle 4" label var Bilirubin_Cycle55 "Elevated Bilirubin cycle 5" label var Bilirubin_Cycle66 "Elevated Bilirubin cycle 6" label var ALT_Cyclel1 "Elevated ALT cycle 1" label var ALT_Cycle22 "Elevated ALT cycle 2" label var ALT_Cycle33 "Elevated ALT cycle 3" label var ALT_Cycle44 "Elevated ALT cycle 4" label var ALT_Cycle55 "Elevated ALT cycle 5" label var ALT_Cycle66 "Elevated ALT cycle 6" label var AST_Cyclel1 "Elevated AST cycle 1" label var AST_Cycle22 "Elevated AST cycle 2" label var AST_Cycle33 "Elevated AST cycle 3" label var AST_Cycle44 "Elevated AST cycle 4" label var AST_Cycle55 "Elevated AST cycle 5" label var AST_Cycle66 "Elevated AST cycle 6" label var LDH_Cyclel1 "Elevated LDH cycle 1" label var LDH_Cycle22 "Elevated LDH cycle 2" label var LDH_Cycle33 "Elevated LDH cycle 3" label var LDH_Cycle44 "Elevated LDH cycle 4" label var LDH_Cycle55 "Elevated LDH cycle 5" label var LDH_Cycle66 "Elevated LDH cycle 6" label var OtherAEs_Cycle11 "Other AEs cycle 1" label var OtherAEs_Cycle22 "Other AEs cycle 2" label var OtherAEs_Cycle33 "Other AEs cycle 3" label var OtherAEs_Cycle44 "Other AEs cycle 4" label var OtherAEs_Cycle55 "Other AEs cycle 5" label var OtherAEs_Cycle66 "Other AEs cycle 6" tab TotalnumberofCHOPcyclesrecieved tab TotalnumberofEPOCHcyclesreceived bysort studyarm:mrtab Anaemia_bl - OtherAEs_Cycle6, title(Type of AEs for non completion of chemo) width(80) mrtab Anaemia_Cycle11 - OtherAEs_Cycle66, by(studyarm) title(Type of AEs for Chemo interruption) width(80) gen numberofcycles=TotalnumberofCHOPcyclesrecieved replace numberofcycles=TotalnumberofEPOCHcyclesreceived if numberofcycles==. label var numberofcycles "Number cycles received" gen exactly_one_yr= 365 + Enrolmentdate format exactly_one_yr %td gen exactlyoneyr_days= exactly_one_yr - Enrolmentdate gen exactlyoneyr_mths=exactlyoneyr_days/30 gen exactlyoneyr_yrs=exactlyoneyr_days/365 replace exactlyoneyr_days=surtimedays if surtimeyears<1 replace exactlyoneyr_mths=surtimemonths if surtimeyears<1 replace exactlyoneyr_yrs=surtimeyears if surtimeyears<1 replace exactlyoneyr_mths=12 if surtimeyears>1 replace Mortalityoutcome_analysis=Mortalityoutcome replace Mortalityoutcome_analysis=1 if surtimeyears>1 label define Mortalityoutcome_analysis 1 "Alive after 1 years from time of enrolment to UCI" /// 2 "Died before 1 year follow up period" /// 3 "Loss to follow up before end of 1 year follow-up period" /// 4 "Still on follow up, not yet completed 1 year of follow-up", modify label value Mortalityoutcome_analysis Mortalityoutcome_analysis replace Mortalityoutcome_analysis_1=Mortalityoutcome_analysis recode Mortalityoutcome_analysis_1 (2=1) (1 4=0) (3=2) label define Mortalityoutcome_analysis_1 0 "Alive" 1 "Dead" 2 "Lost to follow-up", modify label value Mortalityoutcome_analysis_1 Mortalityoutcome_analysis_1 stset exactlyoneyr_mths, failure(Mortalityoutcome_analysis_1==1) id(Srno) stsum stsum, by(studyarm) stci, median stci, by(studyarm) median tabstat exactly_one_yr exactlyoneyr_mths exactlyoneyr_days, stat(n mean sd q iqr min max range) bysort studyarm:tabstat exactly_one_yr exactlyoneyr_mths exactlyoneyr_days, stat(n mean sd q iqr min max range) stci, by(studyarm) rmean ttest exactlyoneyr_mths, by(studyarm) /* stset surtimeyears, failure(Mortalityoutcome_1==1) stsum stsum, by(studyarm) stci, median stci, by(studyarm) median */ stdescribe stsum stci, median strate sts list sts list, by(studyarm) stci, by(studyarm) rmean sts graph, ytitle(Survival Probability) xtitle(Time (Months)) sts graph, by(studyarm) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival by Study Arm) censored(single) sts graph, by(AE) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival Overall by AE) censored(single) sts graph if studyarm==1, by(AE) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival EPOCH by AE) censored(single) sts graph if studyarm==0, by(AE) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival CHOP by AE) censored(single) sts graph, by(Neutropenia_1) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival Overall by Neutropenia) censored(single) sts graph, by(anaemia_1) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival by Anaemia) censored(single) sts graph, by(thrombocytopenia_1) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival by Thrombocytopenia) censored(single) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" gr combine Graph_Survival_Curve_Overall.gph Graph_Survival_CurvesbyStudyarm.gph, col(1) iscale(1) gr combine Graph_Survival_Curve_Overall.gph Graph_Survival_CurvesbyStudyarm.gph gr combine Graph_Survival_CurvesbyhavinganAE.gph GraphSurvivalCurvesbyNeutropenia.gph GraphSurvivalCurvesbyAnaemia.gph GraphSurvivalCurvesbyThrombocytopenia.gph gr combine GraphSurvivalCurvesCHOPbyhavinganAE.gph GraphSurvivalCurvesEPOCHbyhavinganAE.gph rename AnaemiaHbgdLGradeatbaseline Anaemia_GCycle0 rename AnaemiaHbgdLGradeCycle1 Anaemia_GCycle1 rename AnaemiaHbgdLGradeCycle2 Anaemia_GCycle2 rename AnaemiaHbgdLGradeCycle3 Anaemia_GCycle3 rename AnaemiaHbgdLGradeCycle4 Anaemia_GCycle4 rename AnaemiaHbgdLGradeCycle5 Anaemia_GCycle5 rename AnaemiaHbgdLGradeCycle6 Anaemia_GCycle6 rename Thrombocytopenia_mm3Gradeatbasel Thrombocytopenia_GCycle0 rename Thrombocytopenia_mm3GradeCycle1 Thrombocytopenia_GCycle1 rename Thrombocytopenia_mm3GradeCycle2 Thrombocytopenia_GCycle2 rename Thrombocytopenia_mm3GradeCycle3 Thrombocytopenia_GCycle3 rename Thrombocytopenia_mm3GradeCycle4 Thrombocytopenia_GCycle4 rename Thrombocytopenia_mm3GradeCycle5 Thrombocytopenia_GCycle5 rename Thrombocytopenia_mm3GradeCycle6 Thrombocytopenia_GCycle6 rename ElevatedtotalBilirubinumol_LGrad ElevatedtotalBilirubin_GCycle0 rename V15 ElevatedtotalBilirubin_GCycle1 rename V17 ElevatedtotalBilirubin_GCycle2 rename V19 ElevatedtotalBilirubin_GCycle3 rename V21 ElevatedtotalBilirubin_GCycle4 rename V23 ElevatedtotalBilirubin_GCycle5 rename V25 ElevatedtotalBilirubin_GCycle6 rename ElevatedALTIUGradebaseline ElevatedALT_GCycle0 rename ElevatedALTIUGradeCycle1 ElevatedALT_GCycle1 rename ElevatedALTIUGradeCycle2 ElevatedALT_GCycle2 rename ElevatedALTIUGradeCycle3 ElevatedALT_GCycle3 rename ElevatedALTIUGradeCycle4 ElevatedALT_GCycle4 rename ElevatedALTIUGradeCycle5 ElevatedALT_GCycle5 rename ElevatedALTIUGradeCycle6 ElevatedALT_GCycle6 rename ElevatedASTIUGradebaseline ElevatedAST_GCycle0 rename ElevatedASTIUGradeCycle1 ElevatedAST_GCycle1 rename ElevatedASTIUGradeCycle2 ElevatedAST_GCycle2 rename ElevatedASTIUGradeCycle3 ElevatedAST_GCycle3 rename ElevatedASTIUGradeCycle4 ElevatedAST_GCycle4 rename ElevatedASTIUGradeCycle5 ElevatedAST_GCycle5 rename ElevatedASTIUGradeCycle6 ElevatedAST_GCycle6 rename ElevatedLDHIUGradebaseline ElevatedLDH_GCycle0 rename ElevatedLDHIUGradeCycle1 ElevatedLDH_GCycle1 rename ElevatedLDHIUGradeCycle2 ElevatedLDH_GCycle2 rename ElevatedLDHIUGradeCycle3 ElevatedLDH_GCycle3 rename ElevatedLDHIUGradeCycle4 ElevatedLDH_GCycle4 rename ElevatedLDHIUGradeCycle5 ElevatedLDH_GCycle5 rename ElevatedLDHIUGradeCycle6 ElevatedLDH_GCycle6 rename OtherAEGradebaseline OtherAE_GCycle0 rename OtherAEGradeCycle1 OtherAE_GCycle1 rename OtherAEGradeCycle2 OtherAE_GCycle2 rename OtherAEGradeCycle3 OtherAE_GCycle3 rename OtherAEGradeCycle4 OtherAE_GCycle4 rename OtherAEGradeCycle5 OtherAE_GCycle5 rename OtherAEGradeCycle6 OtherAE_GCycle6 rename AnaemiaHbg_dLGradeatCycle1_reaso Anaemia_GCycle11 rename AnaemiaHbg_dLGradeatCycle2_reaso Anaemia_GCycle22 rename AnaemiaHbg_dLGradeatCycle3_reaso Anaemia_GCycle33 rename AnaemiaHbg_dLGradeatCycle4_reaso Anaemia_GCycle44 rename AnaemiaHbg_dLGradeatCycle5_reaso Anaemia_GCycle55 rename AnaemiaHbg_dLGradeatCycle6_reaso Anaemia_GCycle66 rename Thrombocytopenia_mm3GradeCycle1_ Thrombocytopenia_GCycle11 rename Thrombocytopenia_mm3GradeCycle2_ Thrombocytopenia_GCycle22 rename Thrombocytopenia_mm3GradeCycle3_ Thrombocytopenia_GCycle33 rename Thrombocytopenia_mm3GradeCycle4_ Thrombocytopenia_GCycle44 rename Thrombocytopenia_mm3GradeCycle5_ Thrombocytopenia_GCycle55 rename Thrombocytopenia_mm3GradeCycle6_ Thrombocytopenia_GCycle66 rename V26 ElevatedtotalBilirubin_GCycle11 rename V28 ElevatedtotalBilirubin_GCycle22 rename V30 ElevatedtotalBilirubin_GCycle33 rename V32 ElevatedtotalBilirubin_GCycle44 rename V34 ElevatedtotalBilirubin_GCycle55 rename V36 ElevatedtotalBilirubin_GCycle66 rename ElevatedALTIUGradeatCycle1_reaso ElevatedALT_GCycle11 rename ElevatedALTIUGradeatCycle2_reaso ElevatedALT_GCycle22 rename ElevatedALTIUGradeatCycle3_reaso ElevatedALT_GCycle33 rename ElevatedALTIUGradeatCycle4_reaso ElevatedALT_GCycle44 rename ElevatedALTIUGradeatCycle5_reaso ElevatedALT_GCycle55 rename ElevatedALTIUGradeatCycle6_reaso ElevatedALT_GCycle66 rename ElevatedASIUGradeatCycle1_reason ElevatedAST_GCycle11 rename ElevatedASIUGradeatCycle2_reason ElevatedAST_GCycle22 rename ElevatedASIUGradeatCycle3_reason ElevatedAST_GCycle33 rename ElevatedASIUGradeatCycle4_reason ElevatedAST_GCycle44 rename ElevatedASIUGradeatCycle5_reason ElevatedAST_GCycle55 rename ElevatedASIUGradeatCycle6_reason ElevatedAST_GCycle66 rename ElevatedLDHIUGradeatCycle1_reaso ElevatedLDH_GCycle11 rename ElevatedLDHIUGradeatCycle2_reaso ElevatedLDH_GCycle22 rename ElevatedLDHIUGradeatCycle3_reaso ElevatedLDH_GCycle33 rename ElevatedLDHIUGradeatCycle4_reaso ElevatedLDH_GCycle44 rename ElevatedLDHIUGradeatCycle5_reaso ElevatedLDH_GCycle55 rename ElevatedLDHIUGradeatCycle6_reaso ElevatedLDH_GCycle66 rename OtherAEGradeatCycle1_reasonforin OtherAE_GCycle11 rename OtherAEGradeatCycle2_reasonforin OtherAE_GCycle22 rename OtherAEGradeatCycle3_reasonforin OtherAE_GCycle33 rename OtherAEGradeatCycle4_reasonforin OtherAE_GCycle44 rename OtherAEGradeatCycle5_reasonforin OtherAE_GCycle55 rename OtherAEGradeatCycle6_reasonforin OtherAE_GCycle66 *AEs due to non-completion of Chemo bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_bl AnaemiaHbg_dLatbaseline Anaemia_GCycle0 if Anaemia_bl==1 bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_Cycle1 AnaemiaHbg_dLCycle1 Anaemia_GCycle1 if Anaemia_Cycle1==1 & numberofcycles==1 bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_Cycle2 AnaemiaHbg_dLCycle2 Anaemia_GCycle2 if Anaemia_Cycle2==1 & numberofcycles==2 bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_Cycle3 AnaemiaHbg_dLCycle3 Anaemia_GCycle3 if Anaemia_Cycle3==1 & numberofcycles==3 bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_Cycle4 AnaemiaHbg_dLCycle4 Anaemia_GCycle4 if Anaemia_Cycle4==1 & numberofcycles==4 bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_Cycle5 AnaemiaHbg_dLCycle5 Anaemia_GCycle5 if Anaemia_Cycle5==1 & numberofcycles==5 bysort studyarm:list Srno numberofcycles Reasonfornoncompletionofchemo Anaemia_Cycle6 AnaemiaHbg_dLCycle6 Anaemia_GCycle6 if Anaemia_Cycle6==1 & numberofcycles==6 *replace Anaemia_GCycle1=2 if Anaemia_GCycle1==. & Srno==79 *replace Anaemia_GCycle3=3 if Anaemia_GCycle3==. & Srno==41 *replace Anaemia_GCycle4=2 if Anaemia_GCycle4==. & Srno==86 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tab AnaemiaHbg_dLatbaseline if studyarm==0 tabout AnaemiaHbg_dLCycle1 Anaemia_GCycle1 if studyarm==0 using Anaemia_nonco.xls, cell(freq col) tabout AnaemiaHbg_dLCycle2 Anaemia_GCycle2 if studyarm==0 using Anaemia_nonco.xls, cell(freq col) append tabout AnaemiaHbg_dLCycle3 Anaemia_GCycle3 if studyarm==0 using Anaemia_nonco.xls, cell(freq col) append tabout AnaemiaHbg_dLCycle4 Anaemia_GCycle4 if studyarm==0 using Anaemia_nonco.xls, cell(freq col) append *tabout AnaemiaHbg_dLCycle5 Anaemia_GCycle5 if studyarm==0 using Anaemia_nonco.xls, cell(freq col) append *tabout AnaemiaHbg_dLCycle6 Anaemia_GCycle6 if studyarm==0 using Anaemia_nonco.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tab AnaemiaHbg_dLatbaseline if studyarm==1 *tabout AnaemiaHbg_dLCycle1 Anaemia_GCycle1 if studyarm==1 using Anaemia1_nonco.xls, cell(freq col) *tabout AnaemiaHbg_dLCycle2 Anaemia_GCycle2 if studyarm==1 using Anaemia1_nonco.xls, cell(freq col) *tabout AnaemiaHbg_dLCycle3 Anaemia_GCycle3 if studyarm==1 using Anaemia1_nonco.xls, cell(freq col) *tabout AnaemiaHbg_dLCycle4 Anaemia_GCycle4 if studyarm==1 using Anaemia1_nonco.xls, cell(freq col) *tabout AnaemiaHbg_dLCycle5 Anaemia_GCycle5 if studyarm==1 using Anaemia1_nonco.xls, cell(freq col) *tabout AnaemiaHbg_dLCycle6 Anaemia_GCycle6 if studyarm==1 using Anaemia1_nonco.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3baseline Thrombocytopenia_GCycle0 if Thrombocytopenia_bl!=3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3Cycle1 Thrombocytopenia_GCycle1 if Thrombocytopenia_Cyclel!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3Cycle2 Thrombocytopenia_GCycle2 if Thrombocytopenia_Cycle2!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3Cycle3 Thrombocytopenia_GCycle3 if Thrombocytopenia_Cycle3!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3Cycle4 Thrombocytopenia_GCycle4 if Thrombocytopenia_Cycle4!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3Cycle5 Thrombocytopenia_GCycle5 if Thrombocytopenia_Cycle5!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo Thrombocytopenia_mm3Cycle6 Thrombocytopenia_GCycle6 if Thrombocytopenia_Cycle6!=3 & numberofcycles==6 *recode Thrombocytopenia_mm3Cycle3 (468.000=.) if Srno==27 *replace Thrombocytopenia_GCycle3=1 if Thrombocytopenia_GCycle3==. & Srno==41 *replace Thrombocytopenia_GCycle3=. if Thrombocytopenia_GCycle3==1 & Srno==27 *recode Thrombocytopenia_mm3Cycle2 (257.000=.) if Srno==77 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tab Thrombocytopenia_mm3baseline if studyarm==0 tabout Thrombocytopenia_mm3Cycle1 Thrombocytopenia_GCycle1 if studyarm==0 using Thrombocytopenia_nonco.xls, cell(freq col) *tabout Thrombocytopenia_mm3Cycle2 Thrombocytopenia_GCycle2 if studyarm==0 using Thrombocytopenia_nonco.xls, cell(freq col) append tabout Thrombocytopenia_mm3Cycle3 Thrombocytopenia_GCycle3 if studyarm==0 using Thrombocytopenia_nonco.xls, cell(freq col) append *tabout Thrombocytopenia_mm3Cycle4 Thrombocytopenia_GCycle4 if studyarm==0 using Thrombocytopenia_nonco.xls, cell(freq col) append *tabout Thrombocytopenia_mm3Cycle5 Thrombocytopenia_GCycle5 if studyarm==0 using Thrombocytopenia_nonco.xls, cell(freq col) append *tabout Thrombocytopenia_mm3Cycle6 Thrombocytopenia_GCycle6 if studyarm==0 using Thrombocytopenia_nonco.xls, cell(freq col) append bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedtotalBilirubinumol_Lbase ElevatedtotalBilirubin_GCycle0 if Bilirubin_bl!=3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedtotalBilirubinumol_LCycl ElevatedtotalBilirubin_GCycle1 if Bilirubin_Cyclel!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo V16 ElevatedtotalBilirubin_GCycle2 if Bilirubin_Cycle2!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo V18 ElevatedtotalBilirubin_GCycle3 if Bilirubin_Cycle3!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo V20 ElevatedtotalBilirubin_GCycle4 if Bilirubin_Cycle4!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo V22 ElevatedtotalBilirubin_GCycle5 if Bilirubin_Cycle5!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo V24 ElevatedtotalBilirubin_GCycle6 if Bilirubin_Cycle6!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tab ElevatedtotalBilirubinumol_Lbase if studyarm==0 *tabout ElevatedtotalBilirubinumol_LCycl ElevatedtotalBilirubin_GCycle1 if studyarm==0 using Bilirubin_nonco.xls, cell(freq col) *tabout V16 ElevatedtotalBilirubin_GCycle2 if studyarm==0 using Bilirubin_nonco.xls, cell(freq col) *tabout V18 ElevatedtotalBilirubin_GCycle3 if studyarm==0 using Bilirubin_nonco.xls, cell(freq col) *tabout V20 ElevatedtotalBilirubin_GCycle4 if studyarm==0 using Bilirubin_nonco.xls, cell(freq col) *tabout V22 ElevatedtotalBilirubin_GCycle5 if studyarm==0 using Bilirubin_nonco.xls, cell(freq col) *tabout V24 ElevatedtotalBilirubin_GCycle6 if studyarm==0 using Bilirubin_nonco.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUbaseline ElevatedALT_GCycle0 if ALT_bl!=3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUCycle1 ElevatedALT_GCycle1 if ALT_Cyclel!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUCycle2 ElevatedALT_GCycle2 if ALT_Cycle2!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUCycle3 ElevatedALT_GCycle3 if ALT_Cycle3!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUCycle4 ElevatedALT_GCycle4 if ALT_Cycle4!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUCycle5 ElevatedALT_GCycle5 if ALT_Cycle5!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedALTIUCycle6 ElevatedALT_GCycle6 if ALT_Cycle6!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tab ElevatedALTIUbaseline if studyarm==0 *tabout ElevatedALTIUCycle1 ElevatedALT_GCycle1 if studyarm==0 using ALT_nonco.xls, cell(freq col) *tabout ElevatedALTIUCycle2 ElevatedALT_GCycle2 if studyarm==0 using ALT_nonco.xls, cell(freq col) *tabout ElevatedALTIUCycle3 ElevatedALT_GCycle3 if studyarm==0 using ALT_nonco.xls, cell(freq col) *tabout ElevatedALTIUCycle4 ElevatedALT_GCycle4 if studyarm==0 using ALT_nonco.xls, cell(freq col) *tabout ElevatedALTIUCycle5 ElevatedALT_GCycle5 if studyarm==0 using ALT_nonco.xls, cell(freq col) *tabout ElevatedALTIUCycle6 ElevatedALT_GCycle6 if studyarm==0 using ALT_nonco.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUbaseline ElevatedAST_GCycle0 if AST_bl!=3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUCycle1 ElevatedAST_GCycle1 if AST_Cyclel!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUCycle2 ElevatedAST_GCycle2 if AST_Cycle2!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUCycle3 ElevatedAST_GCycle3 if AST_Cycle3!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUCycle4 ElevatedAST_GCycle4 if AST_Cycle4!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUCycle5 ElevatedAST_GCycle5 if AST_Cycle5!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedASTIUCycle6 ElevatedAST_GCycle6 if AST_Cycle6!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tab ElevatedASTIUbaseline if studyarm==0 *tabout ElevatedASTIUCycle1 ElevatedAST_GCycle1 if studyarm==0 using AST_nonco.xls, cell(freq col) *tabout ElevatedASTIUCycle2 ElevatedAST_GCycle2 if studyarm==0 using AST_nonco.xls, cell(freq col) *tabout ElevatedASTIUCycle3 ElevatedAST_GCycle3 if studyarm==0 using AST_nonco.xls, cell(freq col) *tabout ElevatedASTIUCycle4 ElevatedAST_GCycle4 if studyarm==0 using AST_nonco.xls, cell(freq col) *tabout ElevatedASTIUCycle5 ElevatedAST_GCycle5 if studyarm==0 using AST_nonco.xls, cell(freq col) *tabout ElevatedASTIUCycle6 ElevatedAST_GCycle6 if studyarm==0 using AST_nonco.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUbaseline ElevatedLDH_GCycle0 if LDH_bl!=3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUCycle1 ElevatedLDH_GCycle1 if LDH_Cyclel!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUCycle2 ElevatedLDH_GCycle2 if LDH_Cycle2!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUCycle3 ElevatedLDH_GCycle3 if LDH_Cycle3!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUCycle4 ElevatedLDH_GCycle4 if LDH_Cycle4!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUCycle5 ElevatedLDH_GCycle5 if LDH_Cycle5!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo ElevatedLDHIUCycle6 ElevatedLDH_GCycle6 if LDH_Cycle6!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tab ElevatedLDHIUbaseline if studyarm==0 *tabout ElevatedLDHIUCycle1 ElevatedLDH_GCycle1 if studyarm==0 using LDH_nonco.xls, cell(freq col) *tabout ElevatedLDHIUCycle2 ElevatedLDH_GCycle2 if studyarm==0 using LDH_nonco.xls, cell(freq col) *tabout ElevatedLDHIUCycle3 ElevatedLDH_GCycle3 if studyarm==0 using LDH_nonco.xls, cell(freq col) *tabout ElevatedLDHIUCycle4 ElevatedLDH_GCycle4 if studyarm==0 using LDH_nonco.xls, cell(freq col) *tabout ElevatedLDHIUCycle5 ElevatedLDH_GCycle5 if studyarm==0 using LDH_nonco.xls, cell(freq col) *tabout ElevatedLDHIUCycle6 ElevatedLDH_GCycle6 if studyarm==0 using LDH_nonco.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAEatbaseline OtherAE_GCycle0 if OtherAEs_bl!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAECycle1 OtherAE_GCycle1 if OtherAEs_Cycle1!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAECycle2 OtherAE_GCycle2 if OtherAEs_Cycle2!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAECycle3 OtherAE_GCycle3 if OtherAEs_Cycle3!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAECycle4 OtherAE_GCycle4 if OtherAEs_Cycle4!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAECycle5 OtherAE_GCycle5 if OtherAEs_Cycle5!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles Reasonfornoncompletionofchemo SpecifyotherAdverseEvents OtherAECycle6 OtherAE_GCycle6 if OtherAEs_Cycle6!=3 & numberofcycles==6 *tab OtherAEatbaseline if studyarm==0 *tab SpecifyotherAdverseEvents if studyarm==0 list Srno SpecifyotherAdverseEvents OtherAECycle1 OtherAE_GCycle1 if OtherAE_GCycle1!=. list Srno SpecifyotherAdverseEvents OtherAECycle2 OtherAE_GCycle2 if OtherAE_GCycle2!=. list Srno SpecifyotherAdverseEvents OtherAECycle3 OtherAE_GCycle3 if OtherAE_GCycle3!=. list Srno SpecifyotherAdverseEvents OtherAECycle4 OtherAE_GCycle4 if OtherAE_GCycle4!=. list Srno SpecifyotherAdverseEvents OtherAECycle5 OtherAE_GCycle5 if OtherAE_GCycle5!=. list Srno SpecifyotherAdverseEvents OtherAECycle6 OtherAE_GCycle6 if OtherAE_GCycle6!=. edit if Srno==13 | Srno==23 | Srno==24 | Srno==25 | Srno==29 | Srno==39 | Srno==71 | Srno==91 | Srno==93 | Srno==129 | Srno==130 | Srno==131 tab SpecifyotherAdverseEvents studyarm tab Specifyotherreasonsforinterrupti studyarm edit if studyarm==0 replace OtherAE_GCycle3=4 if OtherAE_GCycle3==. & Srno==76 replace OtherAECycle3=20 if OtherAECycle3==. & Srno==76 replace OtherAE_GCycle3=4 if OtherAE_GCycle3==. & Srno==86 replace OtherAECycle3=300 if OtherAECycle3==. & Srno==86 replace OtherAE_GCycle2=3 if OtherAE_GCycle2==. & Srno==40 replace OtherAECycle2=540 if OtherAECycle2==. & Srno==40 replace OtherAE_GCycle2=3 if OtherAE_GCycle2==. & Srno==27 replace OtherAECycle2=900 if OtherAECycle2==. & Srno==27 replace OtherAE_GCycle1=3 if OtherAE_GCycle1==. & Srno==25 replace OtherAECycle1=630 if OtherAECycle1==. & Srno==25 replace OtherAE_GCycle1=4 if OtherAE_GCycle1==. & Srno==128 replace OtherAECycle1=200 if OtherAECycle1==. & Srno==128 *replace OtherAE_GCycle0=. if OtherAE_GCycle0==. & Srno==68 replace OtherAEatbaseline=7.36 if OtherAEatbaseline==. & Srno==68 *replace OtherAEs_Cycle4=3 if OtherAEs_Cycle4!=3 & Srno==52 * replace OtherAE_GCycle6=3 if OtherAE_GCycle6==. & Srno==40 * replace OtherAECycle6=540 if OtherAECycle6==. & Srno==40 * replace OtherAE_GCycle6=4 if OtherAE_GCycle6==. & Srno==128 * replace OtherAECycle6=200 if OtherAECycle6==. & Srno==128 * replace OtherAE_GCycle6=3 if OtherAE_GCycle6==. & Srno==70 * replace OtherAECycle6=500 if OtherAECycle6==. & Srno==70 * replace OtherAE_GCycle6=4 if OtherAE_GCycle6==. & Srno==77 * replace OtherAECycle6=30 if OtherAECycle6==. & Srno==77 * replace OtherAE_GCycle6=3 if OtherAE_GCycle6==. & Srno==27 * replace OtherAECycle6=900 if OtherAECycle6==. & Srno==27 * replace OtherAE_GCycle6=4 if OtherAE_GCycle6==. & Srno==68 * replace OtherAECycle6=7 if OtherAECycle6==. & Srno==68 * replace OtherAE_GCycle6=4 if OtherAE_GCycle6==. & Srno==76 * replace OtherAECycle6=20 if OtherAECycle6==. & Srno==76 * replace OtherAE_GCycle6=4 if OtherAE_GCycle6==. & Srno==126 * replace OtherAECycle6=300 if OtherAECycle6==. & Srno==126 * replace OtherAE_GCycle6=3 if OtherAE_GCycle6==. & Srno==79 * replace OtherAECycle6=580 if OtherAECycle6==. & Srno==79 * replace OtherAE_GCycle6=4 if OtherAE_GCycle6==. & Srno==86 * replace OtherAECycle6=300 if OtherAECycle6==. & Srno==86 * Cleaning the above entries /* replace OtherAE_GCycle6=. if OtherAE_GCycle6==3 & Srno==40 replace OtherAECycle6=. if OtherAECycle6==540 & Srno==40 replace OtherAE_GCycle6=. if OtherAE_GCycle6==4 & Srno==128 replace OtherAECycle6=. if OtherAECycle6==200 & Srno==128 replace OtherAE_GCycle6=. if OtherAE_GCycle6==3 & Srno==70 replace OtherAECycle6=. if OtherAECycle6==500 & Srno==70 replace OtherAE_GCycle6=. if OtherAE_GCycle6==4 & Srno==77 replace OtherAECycle6=. if OtherAECycle6==30 & Srno==77 replace OtherAE_GCycle6=. if OtherAE_GCycle6==3 & Srno==27 replace OtherAECycle6=. if OtherAECycle6==900 & Srno==27 replace OtherAE_GCycle6=. if OtherAE_GCycle6==4 & Srno==68 replace OtherAECycle6=. if OtherAECycle6==7 & Srno==68 replace OtherAE_GCycle6=. if OtherAE_GCycle6==4 & Srno==76 replace OtherAECycle6=. if OtherAECycle6==20 & Srno==76 replace OtherAE_GCycle6=. if OtherAE_GCycle6==4 & Srno==126 replace OtherAECycle6=. if OtherAECycle6==300 & Srno==126 replace OtherAE_GCycle6=. if OtherAE_GCycle6==3 & Srno==79 replace OtherAECycle6=. if OtherAECycle6==580 & Srno==79 replace OtherAE_GCycle6=. if OtherAE_GCycle6==4 & Srno==86 replace OtherAECycle6=. if OtherAECycle6==300 & Srno==86 */ * AEs due to Chemo inetrruptions bysort studyarm:list Srno numberofcycles Anaemia_Cycle11 AnaemiaHbg_dLatCycle1_reasonfori Anaemia_GCycle11 if Anaemia_Cycle11!=3 & numberofcycles==1 bysort studyarm:list Srno numberofcycles Anaemia_Cycle22 AnaemiaHbg_dLatCycle2_reasonfori Anaemia_GCycle22 if Anaemia_Cycle22!=3 & numberofcycles==2 bysort studyarm:list Srno numberofcycles Anaemia_Cycle33 AnaemiaHbg_dLatCycle3_reasonfori Anaemia_GCycle33 if Anaemia_Cycle33!=3 & numberofcycles==3 bysort studyarm:list Srno numberofcycles Anaemia_Cycle44 AnaemiaHbg_dLatCycle4_reasonfori Anaemia_GCycle44 if Anaemia_Cycle44!=3 & numberofcycles==4 bysort studyarm:list Srno numberofcycles Anaemia_Cycle55 AnaemiaHbg_dLatCycle5_reasonfori Anaemia_GCycle55 if Anaemia_Cycle55!=3 & numberofcycles==5 bysort studyarm:list Srno numberofcycles Anaemia_Cycle66 AnaemiaHbg_dLatCycle6_reasonfori Anaemia_GCycle66 if Anaemia_Cycle55!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout AnaemiaHbg_dLatCycle1_reasonfori Anaemia_GCycle11 using Anaemia_inter.xls, cell(freq col) tabout AnaemiaHbg_dLatCycle2_reasonfori Anaemia_GCycle22 using Anaemia_inter.xls, cell(freq col) append tabout AnaemiaHbg_dLatCycle3_reasonfori Anaemia_GCycle33 using Anaemia_inter.xls, cell(freq col) append tabout AnaemiaHbg_dLatCycle4_reasonfori Anaemia_GCycle44 using Anaemia_inter.xls, cell(freq col) append tabout AnaemiaHbg_dLatCycle5_reasonfori Anaemia_GCycle55 using Anaemia_inter.xls, cell(freq col) append tabout AnaemiaHbg_dLatCycle6_reasonfori Anaemia_GCycle66 using Anaemia_inter.xls, cell(freq col) append *replace Anaemia_GCycle11=3 if Anaemia_GCycle11==. & Srno==82 *replace Anaemia_GCycle11=3 if Anaemia_GCycle11==. & Srno==102 *replace Anaemia_GCycle11=3 if Anaemia_GCycle11==. & Srno==117 *replace Anaemia_GCycle11=1 if Anaemia_GCycle11==. & Srno==91 *replace Anaemia_GCycle11=1 if Anaemia_GCycle11==. & Srno==122 bysort studyarm:lis Srno numberofcycles reasonforinterruption Thrombocytopenia_mm3Cycle1_reaso Thrombocytopenia_GCycle11 if Thrombocytopenia_Cyclel1!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles reasonforinterruption Thrombocytopenia_mm3Cycle2_reaso Thrombocytopenia_GCycle22 if Thrombocytopenia_Cycle22!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles reasonforinterruption Thrombocytopenia_mm3Cycle3_reaso Thrombocytopenia_GCycle33 if Thrombocytopenia_Cycle33!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles reasonforinterruption Thrombocytopenia_mm3Cycle4_reaso Thrombocytopenia_GCycle44 if Thrombocytopenia_Cycle44!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles reasonforinterruption Thrombocytopenia_mm3Cycle5_reaso Thrombocytopenia_GCycle55 if Thrombocytopenia_Cycle55!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles reasonforinterruption Thrombocytopenia_mm3Cycle6_reaso Thrombocytopenia_GCycle66 if Thrombocytopenia_Cycle66!=3 & numberofcycles==6 *replace Thrombocytopenia_GCycle22=2 if Thrombocytopenia_GCycle22==. & Srno==102 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tabout Thrombocytopenia_mm3Cycle1_reaso Thrombocytopenia_GCycle11 using Thrombocytopenia_inter.xls, cell(freq col) tabout Thrombocytopenia_mm3Cycle2_reaso Thrombocytopenia_GCycle22 using Thrombocytopenia_inter.xls, cell(freq col) *tabout Thrombocytopenia_mm3Cycle3_reaso Thrombocytopenia_GCycle33 using Thrombocytopenia_inter.xls, cell(freq col) append *tabout Thrombocytopenia_mm3Cycle4_reaso Thrombocytopenia_GCycle44 using Thrombocytopenia_inter.xls, cell(freq col) append *tabout Thrombocytopenia_mm3Cycle5_reaso Thrombocytopenia_GCycle55 using Thrombocytopenia_inter.xls, cell(freq col) append *tabout Thrombocytopenia_mm3Cycle6_reaso Thrombocytopenia_GCycle66 using Thrombocytopenia_inter.xls, cell(freq col) append bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedtotalBilirubinumol_LatCy ElevatedtotalBilirubin_GCycle11 if Bilirubin_Cyclel1!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles reasonforinterruption V27 ElevatedtotalBilirubin_GCycle22 if Bilirubin_Cycle22!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles reasonforinterruption V29 ElevatedtotalBilirubin_GCycle33 if Bilirubin_Cycle33!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles reasonforinterruption V31 ElevatedtotalBilirubin_GCycle44 if Bilirubin_Cycle44!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles reasonforinterruption V33 ElevatedtotalBilirubin_GCycle55 if Bilirubin_Cycle55!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles reasonforinterruption V35 ElevatedtotalBilirubin_GCycle66 if Bilirubin_Cycle66!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tabout ElevatedtotalBilirubinumol_LatCy ElevatedtotalBilirubin_GCycle11 using Bilirubin_inter.xls, cell(freq col) *tabout V27 ElevatedtotalBilirubin_GCycle22 using Bilirubin_inter.xls, cell(freq col) *tabout V29 ElevatedtotalBilirubin_GCycle33 using Bilirubin_inter.xls, cell(freq col) *tabout V31 ElevatedtotalBilirubin_GCycle44 using Bilirubin_inter.xls, cell(freq col) *tabout V33 ElevatedtotalBilirubin_GCycle55 using Bilirubin_inter.xls, cell(freq col) *tabout V35 ElevatedtotalBilirubin_GCycle66 using Bilirubin_inter.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedALTIUatCycle1_reasonfori ElevatedALT_GCycle11 if ALT_Cyclel1!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedALTIUatCycle2_reasonfori ElevatedALT_GCycle22 if ALT_Cycle22!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedALTIUatCycle3_reasonfori ElevatedALT_GCycle33 if ALT_Cycle33!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedALTIUatCycle4_reasonfori ElevatedALT_GCycle44 if ALT_Cycle44!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedALTIUatCycle5_reasonfori ElevatedALT_GCycle55 if ALT_Cycle55!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedALTIUatCycle6_reasonfori ElevatedALT_GCycle66 if ALT_Cycle66!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tabout ElevatedALTIUatCycle1_reasonfori ElevatedALT_GCycle11 using ALT_inter.xls, cell(freq col) *tabout ElevatedALTIUatCycle2_reasonfori ElevatedALT_GCycle22 using ALT_inter.xls, cell(freq col) *tabout ElevatedALTIUatCycle3_reasonfori ElevatedALT_GCycle33 using ALT_inter.xls, cell(freq col) *tabout ElevatedALTIUatCycle4_reasonfori ElevatedALT_GCycle44 using ALT_inter.xls, cell(freq col) *tabout ElevatedALTIUatCycle5_reasonfori ElevatedALT_GCycle55 using ALT_inter.xls, cell(freq col) *tabout ElevatedALTIUatCycle6_reasonfori ElevatedALT_GCycle66 using ALT_inter.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedASIUatCycle1_reasonforin ElevatedAST_GCycle11 if AST_Cyclel1!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedASIUatCycle2_reasonforin ElevatedAST_GCycle22 if AST_Cycle22!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedASIUatCycle3_reasonforin ElevatedAST_GCycle33 if AST_Cycle33!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedASIUatCycle4_reasonforin ElevatedAST_GCycle44 if AST_Cycle44!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedASIUatCycle5_reasonforin ElevatedAST_GCycle55 if AST_Cycle55!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedASIUatCycle6_reasonforin ElevatedAST_GCycle66 if AST_Cycle66!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tabout reasonforinterruption ElevatedASIUatCycle1_reasonforin ElevatedAST_GCycle11 using AST_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedASIUatCycle2_reasonforin ElevatedAST_GCycle22 using AST_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedASIUatCycle3_reasonforin ElevatedAST_GCycle33 using AST_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedASIUatCycle4_reasonforin ElevatedAST_GCycle44 using AST_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedASIUatCycle5_reasonforin ElevatedAST_GCycle55 using AST_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedASIUatCycle6_reasonforin ElevatedAST_GCycle66 using AST_inter.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedLDHIUatCycle1_reasonfori ElevatedLDH_GCycle11 if LDH_Cyclel1!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedLDHIUatCycle2_reasonfori ElevatedLDH_GCycle22 if LDH_Cycle22!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedLDHIUatCycle3_reasonfori ElevatedLDH_GCycle33 if LDH_Cycle33!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedLDHIUatCycle4_reasonfori ElevatedLDH_GCycle44 if LDH_Cycle44!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedLDHIUatCycle5_reasonfori ElevatedLDH_GCycle55 if LDH_Cycle55!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles reasonforinterruption ElevatedLDHIUatCycle6_reasonfori ElevatedLDH_GCycle66 if LDH_Cycle66!=3 & numberofcycles==6 cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" *tabout reasonforinterruption ElevatedLDHIUatCycle1_reasonfori ElevatedLDH_GCycle11 using LDH_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedLDHIUatCycle2_reasonfori ElevatedLDH_GCycle22 using LDH_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedLDHIUatCycle3_reasonfori ElevatedLDH_GCycle33 using LDH_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedLDHIUatCycle4_reasonfori ElevatedLDH_GCycle44 using LDH_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedLDHIUatCycle5_reasonfori ElevatedLDH_GCycle55 using LDH_inter.xls, cell(freq col) *tabout reasonforinterruption ElevatedLDHIUatCycle6_reasonfori ElevatedLDH_GCycle66 using LDH_inter.xls, cell(freq col) bysort studyarm:lis Srno numberofcycles reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 if OtherAEs_Cycle11!=3 & numberofcycles==1 bysort studyarm:lis Srno numberofcycles reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if OtherAEs_Cycle22!=3 & numberofcycles==2 bysort studyarm:lis Srno numberofcycles reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 if OtherAEs_Cycle33!=3 & numberofcycles==3 bysort studyarm:lis Srno numberofcycles reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 if OtherAEs_Cycle44!=3 & numberofcycles==4 bysort studyarm:lis Srno numberofcycles reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 if OtherAEs_Cycle55!=3 & numberofcycles==5 bysort studyarm:lis Srno numberofcycles reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 if OtherAEs_Cycle66!=3 & numberofcycles==6 bysort Specifyotherreasonsforinterrupti: tab OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 if Specifyotherreasonsforinterrupt!="" bysort Specifyotherreasonsforinterrupti: tab OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if Specifyotherreasonsforinterrupt!="" bysort Specifyotherreasonsforinterrupti: tab OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 if Specifyotherreasonsforinterrupt!="" bysort Specifyotherreasonsforinterrupti: tab OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 if Specifyotherreasonsforinterrupt!="" bysort Specifyotherreasonsforinterrupti: tab OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 if Specifyotherreasonsforinterrupt!="" bysort Specifyotherreasonsforinterrupti: tab OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 if Specifyotherreasonsforinterrupt!="" cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 using Other_inter.xls, cell(freq col) tabout OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 using Other_inter.xls, cell(freq col) append tabout OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 using Other_inter.xls, cell(freq col) append *tabout OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 using Other_inter.xls, cell(freq col) append tabout OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 using Other_inter.xls, cell(freq col) append *tabout OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 using Other_inter.xls, cell(freq col) append cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" bysort Specifyotherreasonsforinterrupti: tabout OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 using Other1_inter.xls, cell(freq col) bysort Specifyotherreasonsforinterrupti: tabout OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 using Other1_inter.xls, cell(freq col) append bysort Specifyotherreasonsforinterrupti: tabout OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 using Other1_inter.xls, cell(freq col) append *tabout OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 using Other1_inter.xls, cell(freq col) append bysort Specifyotherreasonsforinterrupti: tabout OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 using Other1_inter.xls, cell(freq col) append *tabout OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 using Other1_inter.xls, cell(freq col) append list Srno Specifyotherreasonsforinterrupti OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 if OtherAE_GCycle11!=. list Srno Specifyotherreasonsforinterrupti OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if OtherAE_GCycle22!=. list Srno Specifyotherreasonsforinterrupti OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 if OtherAE_GCycle33!=. list Srno Specifyotherreasonsforinterrupti OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 if OtherAE_GCycle55!=. list Srno Specifyotherreasonsforinterrupti OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 if Specifyotherreasonsforinterrupti!="" list Srno Specifyotherreasonsforinterrupti OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if Specifyotherreasonsforinterrupti!="" list Srno Specifyotherreasonsforinterrupti OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 if Specifyotherreasonsforinterrupti!="" list Srno Specifyotherreasonsforinterrupti OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 if Specifyotherreasonsforinterrupti!="" *replace OtherAE_GCycle33=3 if OtherAE_GCycle33==. & Srno==91 *replace OtherAEatCycle3_reasonforinterru=0.61 if OtherAEatCycle3_reasonforinterru==. & Srno==91 *replace OtherAEatCycle3_reasonforinterru=610 if OtherAEatCycle3_reasonforinterru==0.61 & Srno==91 *replace OtherAE_GCycle33=3 if OtherAE_GCycle33==. & Srno==102 *replace OtherAEatCycle3_reasonforinterru=680 if OtherAEatCycle3_reasonforinterru==. & Srno==102 *replace OtherAE_GCycle22=3 if OtherAE_GCycle22==. & Srno==82 *replace OtherAEatCycle2_reasonforinterru=780 if OtherAEatCycle2_reasonforinterru==. & Srno==82 by studyarm, sort : list Srno SpecifyotherAdverseEvents OtherAEatbaseline OtherAE_GCycle0 OtherAECycle1 OtherAE_GCycle1 OtherAECycle2 OtherAE_GCycle2 OtherAECycle3 OtherAE_GCycle3 OtherAECycle4 OtherAE_GCycle4 OtherAECycle5 OtherAE_GCycle5 OtherAECycle6 OtherAE_GCycle6 if rxcompleted==0 & SpecifyotherAdverseEvents!="", table separator(1) * AE for non-completion of Chemo by studyarm, sort : list Srno SpecifyotherAdverseEvents OtherAEatbaseline OtherAE_GCycle0 OtherAECycle1 OtherAE_GCycle1 OtherAECycle2 OtherAE_GCycle2 if rxcompleted==0 & SpecifyotherAdverseEvents!="" & SpecifyotherAdverseEvents!="Not specified", table separator(1) by studyarm, sort : list Srno OtherAECycle3 OtherAE_GCycle3 OtherAECycle4 OtherAE_GCycle4 OtherAECycle5 OtherAE_GCycle5 OtherAECycle6 OtherAE_GCycle6 if rxcompleted==0 & SpecifyotherAdverseEvents!=""& SpecifyotherAdverseEvents!="Not specified", table separator(1) by studyarm, sort : list Srno Reasonfornoncompletionofchemo AnaemiaHbg_dLatbaseline Anaemia_GCycle0 AnaemiaHbg_dLCycle1 Anaemia_GCycle1 AnaemiaHbg_dLCycle2 Anaemia_GCycle2 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno AnaemiaHbg_dLCycle3 Anaemia_GCycle3 AnaemiaHbg_dLCycle4 Anaemia_GCycle4 AnaemiaHbg_dLCycle5 Anaemia_GCycle5 AnaemiaHbg_dLCycle6 Anaemia_GCycle6 if rxcompleted==0 Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno Reasonfornoncompletionofchemo Thrombocytopenia_mm3baseline Thrombocytopenia_GCycle0 Thrombocytopenia_mm3Cycle1 Thrombocytopenia_GCycle1 Thrombocytopenia_mm3Cycle2 Thrombocytopenia_GCycle2 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno Thrombocytopenia_mm3Cycle3 Thrombocytopenia_GCycle3 Thrombocytopenia_mm3Cycle4 Thrombocytopenia_GCycle4 Thrombocytopenia_mm3Cycle5 Thrombocytopenia_GCycle5 Thrombocytopenia_mm3Cycle6 Thrombocytopenia_GCycle6 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno Reasonfornoncompletionofchemo ElevatedtotalBilirubinumol_Lbase ElevatedtotalBilirubin_GCycle0 ElevatedtotalBilirubinumol_LCycl ElevatedtotalBilirubin_GCycle1 V16 ElevatedtotalBilirubin_GCycle2 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno V18 ElevatedtotalBilirubin_GCycle3 V20 ElevatedtotalBilirubin_GCycle4 V22 ElevatedtotalBilirubin_GCycle5 V24 ElevatedtotalBilirubin_GCycle6 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno Reasonfornoncompletionofchemo ElevatedALTIUbaseline ElevatedALT_GCycle0 ElevatedALTIUCycle1 ElevatedALT_GCycle1 ElevatedALTIUCycle2 ElevatedALT_GCycle2 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno ElevatedALTIUCycle3 ElevatedALT_GCycle3 ElevatedALTIUCycle4 ElevatedALT_GCycle4 ElevatedALTIUCycle5 ElevatedALT_GCycle5 ElevatedALTIUCycle6 ElevatedALT_GCycle6 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno Reasonfornoncompletionofchemo ElevatedASTIUbaseline ElevatedAST_GCycle0 ElevatedASTIUCycle1 ElevatedAST_GCycle1 ElevatedASTIUCycle2 ElevatedAST_GCycle2 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno ElevatedASTIUCycle3 ElevatedAST_GCycle3 ElevatedASTIUCycle4 ElevatedAST_GCycle4 ElevatedASTIUCycle5 ElevatedAST_GCycle5 ElevatedASTIUCycle6 ElevatedAST_GCycle6 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno Reasonfornoncompletionofchemo ElevatedLDHIUbaseline ElevatedLDH_GCycle0 ElevatedLDHIUCycle1 ElevatedLDH_GCycle1 ElevatedLDHIUCycle2 ElevatedLDH_GCycle2 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) by studyarm, sort : list Srno ElevatedLDHIUCycle3 ElevatedLDH_GCycle3 ElevatedLDHIUCycle4 ElevatedLDH_GCycle4 ElevatedLDHIUCycle5 ElevatedLDH_GCycle5 ElevatedLDHIUCycle6 ElevatedLDH_GCycle6 if rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) * AE for Interruption of Chemo by studyarm, sort : list Srno reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if Chemo_interrupted==1 & Specifyotherreasonsforinterrupti!="" & Specifyotherreasonsforinterrupti!="Not specified" by studyarm, sort : list Srno OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 if Chemo_interrupted==1 & Specifyotherreasonsforinterrupti!="" & Specifyotherreasonsforinterrupti!="Not specified" by studyarm, sort : list Srno reasonforinterruption AnaemiaHbg_dLatCycle1_reasonfori Anaemia_GCycle11 AnaemiaHbg_dLatCycle2_reasonfori Anaemia_GCycle22 AnaemiaHbg_dLatCycle3_reasonfori Anaemia_GCycle33 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno AnaemiaHbg_dLatCycle4_reasonfori Anaemia_GCycle44 AnaemiaHbg_dLatCycle5_reasonfori Anaemia_GCycle55 AnaemiaHbg_dLatCycle6_reasonfori Anaemia_GCycle66 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno reasonforinterruption Thrombocytopenia_mm3Cycle1_reaso Thrombocytopenia_GCycle11 Thrombocytopenia_mm3Cycle2_reaso Thrombocytopenia_GCycle22 Thrombocytopenia_mm3Cycle3_reaso Thrombocytopenia_GCycle33 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno Thrombocytopenia_mm3Cycle4_reaso Thrombocytopenia_GCycle44 Thrombocytopenia_mm3Cycle5_reaso Thrombocytopenia_GCycle55 Thrombocytopenia_mm3Cycle6_reaso Thrombocytopenia_GCycle66 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno reasonforinterruption ElevatedtotalBilirubinumol_LatCy ElevatedtotalBilirubin_GCycle11 V27 ElevatedtotalBilirubin_GCycle22 V29 ElevatedtotalBilirubin_GCycle33 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno V31 ElevatedtotalBilirubin_GCycle44 V33 ElevatedtotalBilirubin_GCycle55 V35 ElevatedtotalBilirubin_GCycle66 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno reasonforinterruption ElevatedALTIUatCycle1_reasonfori ElevatedALT_GCycle11 ElevatedALTIUatCycle2_reasonfori ElevatedALT_GCycle22 ElevatedALTIUatCycle3_reasonfori ElevatedALT_GCycle33 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno ElevatedALTIUatCycle4_reasonfori ElevatedALT_GCycle44 ElevatedALTIUatCycle5_reasonfori ElevatedALT_GCycle55 ElevatedALTIUatCycle6_reasonfori ElevatedALT_GCycle66 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno reasonforinterruption ElevatedASIUatCycle1_reasonforin ElevatedAST_GCycle11 ElevatedASIUatCycle2_reasonforin ElevatedAST_GCycle22 ElevatedASIUatCycle3_reasonforin ElevatedAST_GCycle33 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno ElevatedASIUatCycle4_reasonforin ElevatedAST_GCycle44 ElevatedASIUatCycle5_reasonforin ElevatedAST_GCycle55 ElevatedASIUatCycle6_reasonforin ElevatedAST_GCycle66 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno reasonforinterruption ElevatedLDHIUatCycle1_reasonfori ElevatedLDH_GCycle11 ElevatedLDHIUatCycle2_reasonfori ElevatedLDH_GCycle22 ElevatedLDHIUatCycle3_reasonfori ElevatedLDH_GCycle33 if Chemo_interrupted==1 & reasonforinterruption==1 by studyarm, sort : list Srno ElevatedLDHIUatCycle4_reasonfori ElevatedLDH_GCycle44 ElevatedLDHIUatCycle5_reasonfori ElevatedLDH_GCycle55 ElevatedLDHIUatCycle6_reasonfori ElevatedLDH_GCycle66 if Chemo_interrupted==1 & reasonforinterruption==1 *AE for non-completion of Chemo log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 01.log" list Srno SpecifyotherAdverseEvents OtherAEatbaseline OtherAE_GCycle0 OtherAECycle1 OtherAE_GCycle1 OtherAECycle2 OtherAE_GCycle2 if studyarm==1 & rxcompleted==0 & SpecifyotherAdverseEvents!="" & SpecifyotherAdverseEvents!="Not specified", table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 02.log" list Srno OtherAECycle3 OtherAE_GCycle3 OtherAECycle4 OtherAE_GCycle4 OtherAECycle5 OtherAE_GCycle5 OtherAECycle6 OtherAE_GCycle6 if studyarm==1 & rxcompleted==0 & SpecifyotherAdverseEvents!="" & SpecifyotherAdverseEvents!="Not specified", table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 03.log" list Srno SpecifyotherAdverseEvents OtherAEatbaseline OtherAE_GCycle0 OtherAECycle1 OtherAE_GCycle1 OtherAECycle2 OtherAE_GCycle2 if studyarm==0 & rxcompleted==0 & SpecifyotherAdverseEvents!="" & SpecifyotherAdverseEvents!="Not specified", table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 04.log" list Srno OtherAECycle3 OtherAE_GCycle3 OtherAECycle4 OtherAE_GCycle4 OtherAECycle5 OtherAE_GCycle5 OtherAECycle6 OtherAE_GCycle6 if studyarm==0 & rxcompleted==0 & SpecifyotherAdverseEvents!="" & SpecifyotherAdverseEvents!="Not specified", table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 05.log" list Srno Reasonfornoncompletionofchemo AnaemiaHbg_dLatbaseline Anaemia_GCycle0 AnaemiaHbg_dLCycle1 Anaemia_GCycle1 AnaemiaHbg_dLCycle2 Anaemia_GCycle2 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 06.log" list Srno AnaemiaHbg_dLCycle3 Anaemia_GCycle3 AnaemiaHbg_dLCycle4 Anaemia_GCycle4 AnaemiaHbg_dLCycle5 Anaemia_GCycle5 AnaemiaHbg_dLCycle6 Anaemia_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 07.log" list Srno Reasonfornoncompletionofchemo AnaemiaHbg_dLatbaseline Anaemia_GCycle0 AnaemiaHbg_dLCycle1 Anaemia_GCycle1 AnaemiaHbg_dLCycle2 Anaemia_GCycle2 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 08.log" list Srno AnaemiaHbg_dLCycle3 Anaemia_GCycle3 AnaemiaHbg_dLCycle4 Anaemia_GCycle4 AnaemiaHbg_dLCycle5 Anaemia_GCycle5 AnaemiaHbg_dLCycle6 Anaemia_GCycle6 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 09.log" list Srno Reasonfornoncompletionofchemo Thrombocytopenia_mm3baseline Thrombocytopenia_GCycle0 Thrombocytopenia_mm3Cycle1 Thrombocytopenia_GCycle1 Thrombocytopenia_mm3Cycle2 Thrombocytopenia_GCycle2 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 10.log" list Srno Thrombocytopenia_mm3Cycle3 Thrombocytopenia_GCycle3 Thrombocytopenia_mm3Cycle4 Thrombocytopenia_GCycle4 Thrombocytopenia_mm3Cycle5 Thrombocytopenia_GCycle5 Thrombocytopenia_mm3Cycle6 Thrombocytopenia_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 11.log" list Srno Reasonfornoncompletionofchemo Thrombocytopenia_mm3baseline Thrombocytopenia_GCycle0 Thrombocytopenia_mm3Cycle1 Thrombocytopenia_GCycle1 Thrombocytopenia_mm3Cycle2 Thrombocytopenia_GCycle2 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 12.log" list Srno Thrombocytopenia_mm3Cycle3 Thrombocytopenia_GCycle3 Thrombocytopenia_mm3Cycle4 Thrombocytopenia_GCycle4 Thrombocytopenia_mm3Cycle5 Thrombocytopenia_GCycle5 Thrombocytopenia_mm3Cycle6 Thrombocytopenia_GCycle6 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 13.log" list Srno Reasonfornoncompletionofchemo ElevatedtotalBilirubinumol_Lbase ElevatedtotalBilirubin_GCycle0 ElevatedtotalBilirubinumol_LCycl ElevatedtotalBilirubin_GCycle1 V16 ElevatedtotalBilirubin_GCycle2 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 14.log" list Srno V18 ElevatedtotalBilirubin_GCycle3 V20 ElevatedtotalBilirubin_GCycle4 V22 ElevatedtotalBilirubin_GCycle5 V24 ElevatedtotalBilirubin_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 15.log" list Srno Reasonfornoncompletionofchemo ElevatedtotalBilirubinumol_Lbase ElevatedtotalBilirubin_GCycle0 ElevatedtotalBilirubinumol_LCycl ElevatedtotalBilirubin_GCycle1 V16 ElevatedtotalBilirubin_GCycle2 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 16.log" list Srno V18 ElevatedtotalBilirubin_GCycle3 V20 ElevatedtotalBilirubin_GCycle4 V22 ElevatedtotalBilirubin_GCycle5 V24 ElevatedtotalBilirubin_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==0, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 17.log" list Srno Reasonfornoncompletionofchemo ElevatedALTIUbaseline ElevatedALT_GCycle0 ElevatedALTIUCycle1 ElevatedALT_GCycle1 ElevatedALTIUCycle2 ElevatedALT_GCycle2 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 18.log" list Srno ElevatedALTIUCycle3 ElevatedALT_GCycle3 ElevatedALTIUCycle4 ElevatedALT_GCycle4 ElevatedALTIUCycle5 ElevatedALT_GCycle5 ElevatedALTIUCycle6 ElevatedALT_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 19.log" list Srno Reasonfornoncompletionofchemo ElevatedALTIUbaseline ElevatedALT_GCycle0 ElevatedALTIUCycle1 ElevatedALT_GCycle1 ElevatedALTIUCycle2 ElevatedALT_GCycle2 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 20.log" list Srno ElevatedALTIUCycle3 ElevatedALT_GCycle3 ElevatedALTIUCycle4 ElevatedALT_GCycle4 ElevatedALTIUCycle5 ElevatedALT_GCycle5 ElevatedALTIUCycle6 ElevatedALT_GCycle6 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 21.log" list Srno Reasonfornoncompletionofchemo ElevatedASTIUbaseline ElevatedAST_GCycle0 ElevatedASTIUCycle1 ElevatedAST_GCycle1 ElevatedASTIUCycle2 ElevatedAST_GCycle2 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 22.log" list Srno ElevatedASTIUCycle3 ElevatedAST_GCycle3 ElevatedASTIUCycle4 ElevatedAST_GCycle4 ElevatedASTIUCycle5 ElevatedAST_GCycle5 ElevatedASTIUCycle6 ElevatedAST_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 23.log" list Srno Reasonfornoncompletionofchemo ElevatedASTIUbaseline ElevatedAST_GCycle0 ElevatedASTIUCycle1 ElevatedAST_GCycle1 ElevatedASTIUCycle2 ElevatedAST_GCycle2 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 24.log" list Srno ElevatedASTIUCycle3 ElevatedAST_GCycle3 ElevatedASTIUCycle4 ElevatedAST_GCycle4 ElevatedASTIUCycle5 ElevatedAST_GCycle5 ElevatedASTIUCycle6 ElevatedAST_GCycle6 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 25.log" list Srno Reasonfornoncompletionofchemo ElevatedLDHIUbaseline ElevatedLDH_GCycle0 ElevatedLDHIUCycle1 ElevatedLDH_GCycle1 ElevatedLDHIUCycle2 ElevatedLDH_GCycle2 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 26.log" list Srno ElevatedLDHIUCycle3 ElevatedLDH_GCycle3 ElevatedLDHIUCycle4 ElevatedLDH_GCycle4 ElevatedLDHIUCycle5 ElevatedLDH_GCycle5 ElevatedLDHIUCycle6 ElevatedLDH_GCycle6 if studyarm==1 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 27.log" list Srno Reasonfornoncompletionofchemo ElevatedLDHIUbaseline ElevatedLDH_GCycle0 ElevatedLDHIUCycle1 ElevatedLDH_GCycle1 ElevatedLDHIUCycle2 ElevatedLDH_GCycle2 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Non Completion of Chemo 28.log" list Srno ElevatedLDHIUCycle3 ElevatedLDH_GCycle3 ElevatedLDHIUCycle4 ElevatedLDH_GCycle4 ElevatedLDHIUCycle5 ElevatedLDH_GCycle5 ElevatedLDHIUCycle6 ElevatedLDH_GCycle6 if studyarm==0 & rxcompleted==0 & Reasonfornoncompletionofchemo==1, table separator(1) log close *AE for Interruption of Chemo log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 01.log" list Srno reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if studyarm==1 & Chemo_interrupted==1 & Specifyotherreasonsforinterrupti!="" & Specifyotherreasonsforinterrupti!="Not specified" log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 02.log" list Srno OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 if studyarm==1 & Chemo_interrupted==1 & Specifyotherreasonsforinterrupti!="" & Specifyotherreasonsforinterrupti!="Not specified" log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 03.log" list Srno reasonforinterruption Specifyotherreasonsforinterrupti OtherAEatCycle1_reasonforinterru OtherAE_GCycle11 OtherAEatCycle2_reasonforinterru OtherAE_GCycle22 if studyarm==0 & Chemo_interrupted==1 & Specifyotherreasonsforinterrupti!="" & Specifyotherreasonsforinterrupti!="Not specified" log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 04.log" list Srno OtherAEatCycle3_reasonforinterru OtherAE_GCycle33 OtherAEatCycle4_reasonforinterru OtherAE_GCycle44 OtherAEatCycle5_reasonforinterru OtherAE_GCycle55 OtherAEatCycle6_reasonforinterru OtherAE_GCycle66 if studyarm==0 & Chemo_interrupted==1 & Specifyotherreasonsforinterrupti!="" & Specifyotherreasonsforinterrupti!="Not specified" log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 05.log" list Srno reasonforinterruption AnaemiaHbg_dLatCycle1_reasonfori Anaemia_GCycle11 AnaemiaHbg_dLatCycle2_reasonfori Anaemia_GCycle22 AnaemiaHbg_dLatCycle3_reasonfori Anaemia_GCycle33 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 06.log" list Srno AnaemiaHbg_dLatCycle4_reasonfori Anaemia_GCycle44 AnaemiaHbg_dLatCycle5_reasonfori Anaemia_GCycle55 AnaemiaHbg_dLatCycle6_reasonfori Anaemia_GCycle66 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 07.log" list Srno reasonforinterruption AnaemiaHbg_dLatCycle1_reasonfori Anaemia_GCycle11 AnaemiaHbg_dLatCycle2_reasonfori Anaemia_GCycle22 AnaemiaHbg_dLatCycle3_reasonfori Anaemia_GCycle33 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 08.log" list Srno AnaemiaHbg_dLatCycle4_reasonfori Anaemia_GCycle44 AnaemiaHbg_dLatCycle5_reasonfori Anaemia_GCycle55 AnaemiaHbg_dLatCycle6_reasonfori Anaemia_GCycle66 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 09.log" list Srno reasonforinterruption Thrombocytopenia_mm3Cycle1_reaso Thrombocytopenia_GCycle11 Thrombocytopenia_mm3Cycle2_reaso Thrombocytopenia_GCycle22 Thrombocytopenia_mm3Cycle3_reaso Thrombocytopenia_GCycle33 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 10.log" list Srno Thrombocytopenia_mm3Cycle4_reaso Thrombocytopenia_GCycle44 Thrombocytopenia_mm3Cycle5_reaso Thrombocytopenia_GCycle55 Thrombocytopenia_mm3Cycle6_reaso Thrombocytopenia_GCycle66 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 11.log" list Srno reasonforinterruption Thrombocytopenia_mm3Cycle1_reaso Thrombocytopenia_GCycle11 Thrombocytopenia_mm3Cycle2_reaso Thrombocytopenia_GCycle22 Thrombocytopenia_mm3Cycle3_reaso Thrombocytopenia_GCycle33 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 12.log" list Srno Thrombocytopenia_mm3Cycle4_reaso Thrombocytopenia_GCycle44 Thrombocytopenia_mm3Cycle5_reaso Thrombocytopenia_GCycle55 Thrombocytopenia_mm3Cycle6_reaso Thrombocytopenia_GCycle66 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 13.log" list Srno reasonforinterruption ElevatedtotalBilirubinumol_LatCy ElevatedtotalBilirubin_GCycle11 V27 ElevatedtotalBilirubin_GCycle22 V29 ElevatedtotalBilirubin_GCycle33 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 14.log" list Srno V31 ElevatedtotalBilirubin_GCycle44 V33 ElevatedtotalBilirubin_GCycle55 V35 ElevatedtotalBilirubin_GCycle66 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 15.log" list Srno reasonforinterruption ElevatedtotalBilirubinumol_LatCy ElevatedtotalBilirubin_GCycle11 V27 ElevatedtotalBilirubin_GCycle22 V29 ElevatedtotalBilirubin_GCycle33 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 16.log" list Srno V31 ElevatedtotalBilirubin_GCycle44 V33 ElevatedtotalBilirubin_GCycle55 V35 ElevatedtotalBilirubin_GCycle66 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 17.log" list Srno reasonforinterruption ElevatedALTIUatCycle1_reasonfori ElevatedALT_GCycle11 ElevatedALTIUatCycle2_reasonfori ElevatedALT_GCycle22 ElevatedALTIUatCycle3_reasonfori ElevatedALT_GCycle33 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 18.log" list Srno ElevatedALTIUatCycle4_reasonfori ElevatedALT_GCycle44 ElevatedALTIUatCycle5_reasonfori ElevatedALT_GCycle55 ElevatedALTIUatCycle6_reasonfori ElevatedALT_GCycle66 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 19.log" list Srno reasonforinterruption ElevatedALTIUatCycle1_reasonfori ElevatedALT_GCycle11 ElevatedALTIUatCycle2_reasonfori ElevatedALT_GCycle22 ElevatedALTIUatCycle3_reasonfori ElevatedALT_GCycle33 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 20.log" list Srno ElevatedALTIUatCycle4_reasonfori ElevatedALT_GCycle44 ElevatedALTIUatCycle5_reasonfori ElevatedALT_GCycle55 ElevatedALTIUatCycle6_reasonfori ElevatedALT_GCycle66 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 21.log" list Srno reasonforinterruption ElevatedASIUatCycle1_reasonforin ElevatedAST_GCycle11 ElevatedASIUatCycle2_reasonforin ElevatedAST_GCycle22 ElevatedASIUatCycle3_reasonforin ElevatedAST_GCycle33 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 22.log" list Srno ElevatedASIUatCycle4_reasonforin ElevatedAST_GCycle44 ElevatedASIUatCycle5_reasonforin ElevatedAST_GCycle55 ElevatedASIUatCycle6_reasonforin ElevatedAST_GCycle66 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 23.log" list Srno reasonforinterruption ElevatedASIUatCycle1_reasonforin ElevatedAST_GCycle11 ElevatedASIUatCycle2_reasonforin ElevatedAST_GCycle22 ElevatedASIUatCycle3_reasonforin ElevatedAST_GCycle33 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 24.log" list Srno ElevatedASIUatCycle4_reasonforin ElevatedAST_GCycle44 ElevatedASIUatCycle5_reasonforin ElevatedAST_GCycle55 ElevatedASIUatCycle6_reasonforin ElevatedAST_GCycle66 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 25.log" list Srno reasonforinterruption ElevatedLDHIUatCycle1_reasonfori ElevatedLDH_GCycle11 ElevatedLDHIUatCycle2_reasonfori ElevatedLDH_GCycle22 ElevatedLDHIUatCycle3_reasonfori ElevatedLDH_GCycle33 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 26.log" list Srno ElevatedLDHIUatCycle4_reasonfori ElevatedLDH_GCycle44 ElevatedLDHIUatCycle5_reasonfori ElevatedLDH_GCycle55 ElevatedLDHIUatCycle6_reasonfori ElevatedLDH_GCycle66 if studyarm==1 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 27.log" list Srno reasonforinterruption ElevatedLDHIUatCycle1_reasonfori ElevatedLDH_GCycle11 ElevatedLDHIUatCycle2_reasonfori ElevatedLDH_GCycle22 ElevatedLDHIUatCycle3_reasonfori ElevatedLDH_GCycle33 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\AEs for Interruption of Chemo 28.log" list Srno ElevatedLDHIUatCycle4_reasonfori ElevatedLDH_GCycle44 ElevatedLDHIUatCycle5_reasonfori ElevatedLDH_GCycle55 ElevatedLDHIUatCycle6_reasonfori ElevatedLDH_GCycle66 if studyarm==0 & Chemo_interrupted==1 & reasonforinterruption==1 log close gen anaemia=1 if AnaemiaHbg_dLCycle1!=. | AnaemiaHbg_dLCycle2!=. | AnaemiaHbg_dLCycle3!=. | AnaemiaHbg_dLCycle4!=. | AnaemiaHbg_dLCycle5!=. | AnaemiaHbg_dLCycle6!=. gen thrombocytopenia=1 if Thrombocytopenia_mm3Cycle1!=. | Thrombocytopenia_mm3Cycle2!=. | Thrombocytopenia_mm3Cycle3!=. | Thrombocytopenia_mm3Cycle4!=. | Thrombocytopenia_mm3Cycle5!=. | Thrombocytopenia_mm3Cycle6!=. gen bilirubin=1 if ElevatedtotalBilirubinumol_LCycl!=. | V16!=. | V18!=. | V20!=. | V22!=. | V24!=. gen alt=1 if ElevatedALTIUCycle1!=. | ElevatedALTIUCycle2!=. | ElevatedALTIUCycle3!=. | ElevatedALTIUCycle4!=. | ElevatedALTIUCycle5!=. | ElevatedALTIUCycle6!=. gen ast=1 if ElevatedASTIUCycle1!=. | ElevatedASTIUCycle2!=. | ElevatedASTIUCycle3!=. | ElevatedASTIUCycle4!=. | ElevatedASTIUCycle5!=. | ElevatedASTIUCycle6!=. gen ldh=1 if ElevatedLDHIUCycle1!=. | ElevatedLDHIUCycle2!=. | ElevatedLDHIUCycle3!=. | ElevatedLDHIUCycle4!=. | ElevatedLDHIUCycle5!=. | ElevatedLDHIUCycle6!=. gen Neutropenia=1 if SpecifyotherAdverseEvents=="Neutropenia" gen Sepsis=1 if SpecifyotherAdverseEvents=="SEPSIS" gen Death=1 if SpecifyotherAdverseEvents=="Death" gen HEncephalopathy=1 if SpecifyotherAdverseEvents=="Hepatic Encephalopathy" gen LFUP=1 if SpecifyotherAdverseEvents=="Lost to FUP for 2 years 2009-2011" gen anaemia1=1 if AnaemiaHbg_dLatCycle1_reasonfori!=. | AnaemiaHbg_dLatCycle2_reasonfori!=. | AnaemiaHbg_dLatCycle3_reasonfori!=. | AnaemiaHbg_dLatCycle4_reasonfori!=. | AnaemiaHbg_dLatCycle5_reasonfori!=. | AnaemiaHbg_dLatCycle6_reasonfori!=. gen thrombocytopenia1=1 if Thrombocytopenia_mm3Cycle1_reaso!=. | Thrombocytopenia_mm3Cycle2_reaso!=. | Thrombocytopenia_mm3Cycle3_reaso!=. | Thrombocytopenia_mm3Cycle4_reaso!=. | Thrombocytopenia_mm3Cycle5_reaso!=. | Thrombocytopenia_mm3Cycle6_reaso!=. gen bilirubin1=1 if ElevatedtotalBilirubinumol_LatCy!=. | V27!=. | V29!=. | V31!=. | V33!=. | V35!=. gen alt1=1 if ElevatedALTIUatCycle1_reasonfori!=. | ElevatedALTIUatCycle2_reasonfori!=. | ElevatedALTIUatCycle3_reasonfori!=. | ElevatedALTIUatCycle4_reasonfori!=. | ElevatedALTIUatCycle5_reasonfori!=. | ElevatedALTIUatCycle6_reasonfori!=. gen ast1=1 if ElevatedASIUatCycle1_reasonforin!=. | ElevatedASIUatCycle2_reasonforin!=. | ElevatedASIUatCycle3_reasonforin!=. | ElevatedASIUatCycle4_reasonforin!=. | ElevatedASIUatCycle5_reasonforin!=. | ElevatedASIUatCycle6_reasonforin!=. gen ldh1=1 if ElevatedLDHIUatCycle1_reasonfori!=. | ElevatedLDHIUatCycle2_reasonfori!=. | ElevatedLDHIUatCycle3_reasonfori!=. | ElevatedLDHIUatCycle4_reasonfori!=. | ElevatedLDHIUatCycle5_reasonfori!=. | ElevatedLDHIUatCycle6_reasonfori!=. gen Neutropenia1=1 if Specifyotherreasonsforinterrupti=="Neutropenia" gen Sepsis1=1 if Specifyotherreasonsforinterrupti=="SEPSIS" gen Death1=1 if Specifyotherreasonsforinterrupti=="Death" gen HEncephalopathy1=1 if Specifyotherreasonsforinterrupti=="Hepatic Encephalopathy" gen LFUP1=1 if Specifyotherreasonsforinterrupti=="Lost to FUP for 2 years 2009-2011" order HEncephalopathy1, before(LFUP1) order HEncephalopathy, before(LFUP) gen anaemia_1=1 if anaemia==1 replace anaemia_1=1 if anaemia1==1 & anaemia_1==. gen thrombocytopenia_1=1 if thrombocytopenia==1 replace thrombocytopenia_1=1 if thrombocytopenia1==1 & thrombocytopenia_1==. gen bilirubin_1=1 if bilirubin==1 replace bilirubin_1=1 if bilirubin1==1 & bilirubin_1==. gen alt_1=1 if alt==1 replace alt_1=1 if alt1==1 & alt_1==. gen ast_1=1 if ast==1 replace ast_1=1 if ast1==1 & ast_1==. gen ldh_1=1 if ldh==1 replace ldh_1=1 if ldh1==1 & ldh_1==. gen Neutropenia_1=1 if Neutropenia==1 replace Neutropenia_1=1 if Neutropenia1==1 & Neutropenia_1==. gen Sepsis_1=1 if Sepsis==1 replace Sepsis_1=1 if Sepsis1==1 & Sepsis_1==. gen Death_1=1 if Death==1 replace Death_1=1 if Death1==1 & Death_1 gen HEncephalopathy_1=1 if HEncephalopathy==1 replace HEncephalopathy_1=1 if HEncephalopathy1==1 & HEncephalopathy_1==. gen LFUP_1=1 if LFUP==1 replace LFUP_1=1 if LFUP1==1 & LFUP_1==. egen anaemia_grade = concat(Anaemia_GCycle1 Anaemia_GCycle2 Anaemia_GCycle3 Anaemia_GCycle4 Anaemia_GCycle5 Anaemia_GCycle6) if anaemia==1 egen Neutropenia_grade = concat(OtherAE_GCycle1 OtherAE_GCycle2 OtherAE_GCycle3 OtherAE_GCycle4 OtherAE_GCycle5 OtherAE_GCycle6) if Neutropenia==1 egen thrombocytopenia_grade = concat(Thrombocytopenia_GCycle1 Thrombocytopenia_GCycle2 Thrombocytopenia_GCycle3 Thrombocytopenia_GCycle4 Thrombocytopenia_GCycle5 Thrombocytopenia_GCycle6) if thrombocytopenia==1 egen anaemia1_grade = concat(Anaemia_GCycle11 Anaemia_GCycle22 Anaemia_GCycle33 Anaemia_GCycle44 Anaemia_GCycle55 Anaemia_GCycle66) if anaemia1==1 egen Neutropenia1_grade = concat(OtherAE_GCycle11 OtherAE_GCycle22 OtherAE_GCycle33 OtherAE_GCycle44 OtherAE_GCycle55 OtherAE_GCycle66) if Neutropenia1==1 egen thrombocytopenia1_grade = concat(Thrombocytopenia_GCycle11 Thrombocytopenia_GCycle22 Thrombocytopenia_GCycle33 Thrombocytopenia_GCycle44 Thrombocytopenia_GCycle55 Thrombocytopenia_GCycle66) if thrombocytopenia1==1 egen anaemia_value = concat(AnaemiaHbg_dLatbaseline AnaemiaHbg_dLCycle1 AnaemiaHbg_dLCycle2 AnaemiaHbg_dLCycle3 AnaemiaHbg_dLCycle4 AnaemiaHbg_dLCycle5 AnaemiaHbg_dLCycle6) if anaemia==1 egen Neutropenia_value = concat(OtherAEatbaseline OtherAECycle1 OtherAECycle2 OtherAECycle3 OtherAECycle4 OtherAECycle5 OtherAECycle6) if Neutropenia==1 egen thrombocytopenia_value = concat(Thrombocytopenia_mm3baseline Thrombocytopenia_mm3Cycle1 Thrombocytopenia_mm3Cycle2 Thrombocytopenia_mm3Cycle3 Thrombocytopenia_mm3Cycle4 Thrombocytopenia_mm3Cycle5 Thrombocytopenia_mm3Cycle6) if thrombocytopenia==1 egen anaemia1_value = concat(AnaemiaHbg_dLatCycle1_reasonfori AnaemiaHbg_dLatCycle2_reasonfori AnaemiaHbg_dLatCycle3_reasonfori AnaemiaHbg_dLatCycle4_reasonfori AnaemiaHbg_dLatCycle5_reasonfori AnaemiaHbg_dLatCycle6_reasonfori) if anaemia1==1 egen Neutropenia1_value = concat(OtherAEatCycle1_reasonforinterru OtherAEatCycle2_reasonforinterru OtherAEatCycle3_reasonforinterru OtherAEatCycle4_reasonforinterru OtherAEatCycle5_reasonforinterru OtherAEatCycle6_reasonforinterru) if Neutropenia1==1 egen thrombocytopenia1_value = concat(Thrombocytopenia_mm3Cycle1_reaso Thrombocytopenia_mm3Cycle2_reaso Thrombocytopenia_mm3Cycle3_reaso Thrombocytopenia_mm3Cycle4_reaso Thrombocytopenia_mm3Cycle5_reaso Thrombocytopenia_mm3Cycle6_reaso) if thrombocytopenia1==1 gen Neutropenia_grade1 = subinstr(Neutropenia_grade,".","",.) gen thrombocytopenia_grade1 = subinstr( thrombocytopenia_grade,".","",.) gen anaemia1_grade1 = subinstr( anaemia1_grade ,".","",.) gen Neutropenia1_grade1 = subinstr( Neutropenia1_grade ,".","",.) gen thrombocytopenia1_grade1 = subinstr( thrombocytopenia1_grade ,".","",.) replace Neutropenia_grade1="3" if Neutropenia_grade1=="33" replace Neutropenia_grade1="4" if Neutropenia_grade1=="44" replace Neutropenia1_grade1="3" if Neutropenia1_grade1=="33" gen Anaemia2_grade=anaemia_grade1 replace Anaemia2_grade=anaemia1_grade1 if Anaemia2_grade=="" gen Neutropenia2_grade=Neutropenia_grade1 replace Neutropenia2_grade=Neutropenia1_grade1 if Neutropenia2_grade=="" gen thrombocytopenia2_grade1= thrombocytopenia_grade1 replace thrombocytopenia2_grade1= thrombocytopenia1_grade1 if thrombocytopenia2_grade1=="" destring Anaemia2_grade Neutropenia2_grade thrombocytopenia2_grade1, generate(Anaemia22_grade Neutropenia22_grade thrombocytopenia22_grade) force float gen Other_AEs=1 if Sepsis_1==1 | HEncephalopathy_1==1 | LFUP_1==1 replace Other_AEs=0 if Other_AEs==. recode anaemia - LFUP_1 Other_AEs (.=0) label values anaemia - LFUP_1 Other_AEs yn gen onfirstlinearvs=1 if TLE_Start==1 | ZLE_Start==1 | TLN_Start==1 | ZLN_Start==1 | ALD_Start==1 | ALE_Start==1 | ALN_Start==1 | OtherFirstlineStart==1 recode onfirstlinearvs (.=0) label var onfirstlinearvs "On first line ARVs" label value onfirstlinearvs yn /* Srno - _Inumberofc_1 TLE_Start_0 - otherconcomodif_0 rename (TLE_Start TLE_Stop TLE_Modi ZLE_Start ZLE_Stop ZLE_Modi TLN_Start TLN_Stop TLN_Modi ZLN_Start ZLN_Stop ZLN_Modi ALD_Start ALD_Stop /// ALD_Modi ALE_Start ALE_Stop ALE_Modi ALN_Start ALN_Stop ALN_Modi Specifyotherfirstlineagents OtherFirstlineStart OtherFirstline_Stop /// OtherFirstline_Modi TLA2_Start TLA2_Stop TLA2_Modi ZLA_Start ZLA_Stop ZLA_Modi ALA_Start ALA_Stop ALA_Modi TLL_Start TLL_Stop TLL_Modi ZLL_Start /// ZLL_Stop ZLL_Modi ALL_Start ALL_Stop ALL_Modi SpecifyotherSecondlineAgents1 Other2nsline_Start Other2nsline_Stop Other2nsline_Modi CotrimoStartdt /// CotrimoxazoleStodt CotrimoModif DapsoneStartdate DapsoneStopdate DapsoneModification Otherconcomitantmedication otherconcostartdt otherconcostopdt /// otherconcomodif) /// (TLE_Start_0 TLE_Stop_0 TLE_Modi_0 ZLE_Start_0 ZLE_Stop_0 ZLE_Modi_0 TLN_Start_0 TLN_Stop_0 TLN_Modi_0 ZLN_Start_0 ZLN_Stop_0 ZLN_Modi_0 /// ALD_Start_0 ALD_Stop_0 ALD_Modi_0 ALE_Start_0 ALE_Stop_0 ALE_Modi_0 ALN_Start_0 ALN_Stop_0 ALN_Modi_0 Specifyotherfirstlineagents_0 /// OtherFirstlineStart_0 OtherFirstline_Stop_0 OtherFirstline_Modi_0 TLA2_Start_0 TLA2_Stop_0 TLA2_Modi_0 ZLA_Start_0 ZLA_Stop_0 ZLA_Modi_0 /// ALA_Start_0 ALA_Stop_0 ALA_Modi_0 TLL_Start_0 TLL_Stop_0 TLL_Modi_0 ZLL_Start_0 ZLL_Stop_0 ZLL_Modi_0 ALL_Start_0 ALL_Stop_0 ALL_Modi_0 /// SpecifyotherSecondlineAgents1_0 Other2nsline_Start_0 Other2nsline_Stop_0 Other2nsline_Modi_0 CotrimoStartdt_0 CotrimoxazoleStodt_0 CotrimoModif_0 /// DapsoneStartdate_0 DapsoneStopdate_0 DapsoneModification_0 Otherconcomitantmedication_0 otherconcostartdt_0 otherconcostopdt_0 otherconcomodif_0) merge 1:1 Srno using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\EPOCH_Analysis n120 - Copy 03DEC19.dta", assert(match) keep(match) keepusing(TLE_Start_0 - otherconcomodif_0) generate(ARVs_merge) log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\bivcoxregression16Dec2019_1.log", replace */ gen numberofcycles_1= numberofcycles recode numberofcycles_1 (1/5=0) (6/10=1) label var numberofcycles_1 "Number of cycles completed" label define numberofcycles_1 0 "Less than 6 cycles" 1 "6 and above cycles" label value numberofcycles_1 numberofcycles_1 gen afterchemo1stline=1 if TLE_Start_0==3 | ZLE_Start_0==3 | TLN_Start_0==3 | ZLN_Start_0==3 | ALD_Start_0==3 | ALE_Start_0==3 | ALN_Start_0==3 | OtherFirstlineStart_0==3 gen afterchemo2ndline=1 if TLA2_Start_0==3 | ZLA_Start_0==3 | ALA_Start_0==3 | TLL_Start_0==3 | ZLL_Start_0==3 | ALL_Start_0==3 | Other2nsline_Start_0==3 recode afterchemo1stline afterchemo2ndline (.=0) label value afterchemo1stline afterchemo2ndline yn replace ARVs_2ndline=1 if Other2nsline_Start==1 & ARVs_2ndline!=1 gen onconmeds=1 if CotrimoStartdt_1==1 | DapsoneStartdate_1==1 | otherconcostartdt_1==1 recode onconmeds (.=0) label value onconmeds yn label var onconmeds "On conmeds" replace conmedafterchemo=1 if CotrimoStartdt_0==3 | DapsoneStartdate_0==3 | otherconcostartdt_0==3 recode conmedafterchemo (.=0) label value conmedafterchemo yn label var conmedafterchemo "On conmeds after chemo" gen notonconmeds=1 if onconmeds!=1 & conmedafterchemo!=1 recode notonconmeds (.=0) label value notonconmeds yn label var notonconmeds "Not On conmeds" cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout rxcompleted studyarm using RX_And_AEs.xls, cell(freq col) tabout Rfnotcompchemo_11 studyarm using RX_And_AEs.xls, cell(freq col) append tabout Chemo_interrupted studyarm using RX_And_AEs.xls, cell(freq col) append tabout rfinterruption_11 studyarm using RX_And_AEs.xls, cell(freq col) append tabout AE studyarm using RX_And_AEs.xls, cell(freq col) append tabout Neutropenia_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout Neutropenia22_grade studyarm using RX_And_AEs.xls, cell(freq col) append tabout anaemia_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout Anaemia22_grade studyarm using RX_And_AEs.xls, cell(freq col) append tabout thrombocytopenia_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout thrombocyto22_gd studyarm using RX_And_AEs.xls, cell(freq col) append tabout Sepsis_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout Death_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout HEncephalopathy_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout LFUP_1 studyarm using RX_And_AEs.xls, cell(freq col) append tabout Other_AEs studyarm using RX_And_AEs.xls, cell(freq col) append tabout DiseaseResponse_11 studyarm using RX_And_AEs.xls, cell(freq col) append tabout Mortalityoutcome_11 studyarm using RX_And_AEs.xls, cell(freq col) append *rename Specifystartdateforotherconcomit otherconcostartdt *rename Specifystopdateforotherconcomita otherconcostopdt *rename modificationforotherconcomitantm otherconcomodif *rename Reasonfornoncompletionofchemo_11 Rfornoncompletchemo_11 *label var Rfornoncompletchemo_11 "Reason for noncompletion of chemo" *recode Anaemia22_grade Neutropenia22_grade thrombocytopenia22_grade (.=0) *rename Rfornoncompletchemo_11 Rfnotcompchemo_11 *label var Rfnotcompchemo_11 "Reason for noncompletion of chemo" *rename reasonforinterruption_11 rfinterruption_11 *label var rfinterruption_11 "Reason for interruption of chemo" *rename thrombocytopenia22_grade thrombocyto22_gd *label var thrombocyto22_gd "Thrombocytopenia grade" *tab1 rxcompleted Rfnotcompchemo_11 Chemo_interrupted rfinterruption_11 AE Neutropenia_1 Neutropenia22_grade anaemia_1 Anaemia22_grade thrombocytopenia_1 thrombocyto22_gd Sepsis_1 Death_1 HEncephalopathy_1 LFUP_1 Other_AEs DiseaseResponse_11 Mortalityoutcome_11 partchart OtherFirstlineStart afterchemo1stline ARVs_2ndline, file(Additional_1.xlsx) by(studyarm) conprec(1) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart rxcompleted Rfnotcompchemo_11 Chemo_interrupted rfinterruption_11 AE Neutropenia_1 Neutropenia22_grade anaemia_1 Anaemia22_grade thrombocytopenia_1 thrombocyto22_gd Sepsis_1 Death_1 HEncephalopathy_1 LFUP_1 Other_AEs DiseaseResponse_11 Mortalityoutcome_11, file(RX_And_AEs_1.xlsx) by(studyarm) conprec(1) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" /* recode Lymphomastage_1 (1/2=0) (3/4=1) (5=2) label define Lymphomastage_1 0 "Early stage" 1 "Late stage" 2 "Not assessed" label value Lymphomastage_1 Lymphomastage_1 tabulate Diagnosis_1, generate(Diagnosis_1) tabulate DiseaseResponse_11, generate(DiseaseResponse_11) label var Diagnosis_11 "Diffuse large B-cell lymphoma (DLBCL)" label var Diagnosis_12 "Diffuse Large cell lymphoma" label var Diagnosis_13 "Plasmablastic lymphoma" label var Diagnosis_14 "NHL Other" label var Diagnosis_15 "Burkitts" label var DiseaseResponse_111 "No restaging done" label var DiseaseResponse_112 "Complete response" label var DiseaseResponse_113 "Partial response" label var DiseaseResponse_114 "Progressive disease" label values Diagnosis_11 Diagnosis_12 Diagnosis_13 Diagnosis_14 Diagnosis_15 DiseaseResponse_111 DiseaseResponse_112 DiseaseResponse_113 DiseaseResponse_114 yn */ log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\bivcoxregression16Dec2019.log", replace asdoc stcox i.studyarm, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc) asdoc stcox Age, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.gender, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Diagnosis_11, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Diagnosis_12, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Diagnosis_13, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Diagnosis_14, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Diagnosis_15, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.ECOG, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.BSymptoms, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.comorbidity, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Lymphomastage_1, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.rxcompleted, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Chemo_interrupted, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.AE, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Neutropenia_1, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Neutropenia22_grade, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.anaemia_1, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Anaemia22_grade, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.thrombocytopenia_1, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.thrombocyto22_gd, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.Other_AEs, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.DiseaseResponse_111, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.DiseaseResponse_112, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.DiseaseResponse_113, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append asdoc stcox i.DiseaseResponse_114, hr vce(robust) save(Biv_Cox_EPOCHVSCHOP.doc)append log close log using "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis\bivcoxregression16Dec2019_1.log", replace xi: stcox i.studyarm, hr vce(robust) xi: stcox Age, hr vce(robust) xi: stcox i.gender, hr vce(robust) xi: stcox i.Diagnosis_11, hr vce(robust) xi: stcox i.Diagnosis_12, hr vce(robust) xi: stcox i.Diagnosis_13, hr vce(robust) xi: stcox i.Diagnosis_14, hr vce(robust) xi: stcox i.Diagnosis_15, hr vce(robust) xi: stcox i.ECOG, hr vce(robust) xi: stcox i.BSymptoms, hr vce(robust) xi: stcox i.comorbidity, hr vce(robust) xi: stcox i.Lymphomastage_1, hr vce(robust) xi: stcox i.rxcompleted, hr vce(robust) xi: stcox i.Chemo_interrupted, hr vce(robust) xi: stcox i.AE, hr vce(robust) xi: stcox i.Neutropenia_1, hr vce(robust) xi: stcox i.Neutropenia22_grade, hr vce(robust) xi: stcox i.anaemia_1, hr vce(robust) xi: stcox i.Anaemia22_grade, hr vce(robust) xi: stcox i.thrombocytopenia_1, hr vce(robust) xi: stcox i.thrombocyto22_gd, hr vce(robust) xi: stcox i.Other_AEs, hr vce(robust) xi: stcox i.DiseaseResponse_111, hr vce(robust) xi: stcox i.DiseaseResponse_112, hr vce(robust) xi: stcox i.DiseaseResponse_113, hr vce(robust) xi: stcox i.DiseaseResponse_114, hr vce(robust) log close power twoproportions 0.8, n1(12) n2(108) alpha(0.05) ratio(0.428) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" tabout numberofcycles_1 studyarm using RX_Other.xls, cell(freq col) tabout studyarm using RX_And_AEs.xls, cell(freq col) append tabout studyarm using RX_And_AEs.xls, cell(freq col) append tabout studyarm using RX_And_AEs.xls, cell(freq col) append tabout studyarm using RX_And_AEs.xls, cell(freq col) append tabout studyarm using RX_And_AEs.xls, cell(freq col) append tabout studyarm using RX_And_AEs.xls, cell(freq col) append xi: stcox i.numberofcycles_1, hr vce(robust) xi: stcox i., hr vce(robust) xi: stcox i., hr vce(robust) xi: stcox i., hr vce(robust) xi: stcox i., hr vce(robust) cd "C:\Users\Yusuf Mulumba\Downloads\YM_Z\Dr OC Databases\EPOCH _YM 24OCT2019\EPOCH_Analysis" partchart TLE_Start ZLE_Start TLN_Start ZLN_Start ALD_Start ALE_Start ALN_Start OtherFirstlineStart afterchemo1stline ARVs_2ndline CotrimoStartdt_1 DapsoneStartdate_1 otherconcostartdt_1 conmedafterchemo notonconmeds, file(Additional_1.xlsx) by(studyarm) conprec(1) xi: stcox i.studyarm, hr vce(robust) sts test studyarm, logrank stcoxkm, by(studyarm) sts graph, by(studyarm) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival by Study Arm) censored(single) risktable tmin(0) tmax(12) sts graph, by(studyarm) ytitle(Survival Probability) xtitle(Time (Months)) title(Kaplan-Meier survival by Study Arm) censored(single) xlabel(0(6)12) risktable sts graph, ytitle(Survival Probability) xtitle(Time (Months)) title(Overall Kaplan-Meier survival) censored(single) xlabel(0(6)12) risktable xlabel(0(5)40) risktable sts test studyarm, logrank sts graph, by(studyarm) sts list sts list, by(studyarm) stpower logrank, n(120) hratio(0.427) p1(0.9) schoenfeld power logrank 0.5, n(12 108) hratio(0.428 1) saving(mypower) * Today's work 05Feb2020 sts list if Diagnosis==1, by(Diagnosis) sts list if Diagnosis==1, by(studyarm Diagnosis) stci, by(DLBCL) p(50) xi:stcox ib0.DLBCL, hr bysort studyarm:stcox ib0.DLBCL, hr bysort DLBCL:stcox ib0.studyarm, hr tab Diagnosis tab Diagnosis, nol do "C:\Users\YUSUFM~1\AppData\Local\Temp\STD0q000000.tmp" gen DLBCL=Diagnosis recode DLBCL (2/max=0) if Diagnosis!=. tab DLBCL label define DLBCL 0 "Other" 1 "DLBCL" label value DLBCL DLBCL tab DLBCL do "C:\Users\YUSUFM~1\AppData\Local\Temp\STD0q000000.tmp" do "C:\Users\YUSUFM~1\AppData\Local\Temp\STD0q000000.tmp" tab1 Mortalityoutcome_analysis Mortalityoutcome_analysis_1 tab1 Mortalityoutcome_analysis_1 DLBCL tab Mortalityoutcome_analysis_1 DLBCL table Mortalityoutcome_analysis_1 DLBCL studyarm xi:stcox DLBCL*studyarm, hr tab DiseaseResponse studyarm if DLBCL==1, col * cox Regression *stci, by(DLBCL) p(50) *xi:stcox BMI_2, hr xi:stcox Age, hr xi:stcox ib0.gender, hr xi:stcox ib0.studyarm, hr xi:stcox ib1.BMI_3, hr xi:stcox ib0.Lymphomastage_1, hr xi:stcox ib1.Diagnosis_1, hr xi:stcox ib0.BSymptoms, hr xi:stcox ib0.comorbidity, hr xi:stcox ib0.nocycles_1, hr xi:stcox ib1.ECOG_1, hr xi:stcox Age ib0.gender ib0.studyarm ib1.ECOG_1 ib1.BMI_3 ib0.Lymphomastage_1 ib1.Diagnosis_1 ib0.BSymptoms ib0.comorbidity ib0.nocycles_1 /* xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr xi:stcox ib0., hr */