generated from opensafely/research-template
/
data_preparation_and_descriptives_feasibility_update.do
578 lines (502 loc) · 26.5 KB
/
data_preparation_and_descriptives_feasibility_update.do
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
********************************************************************************
*
* Do-file: data_preparation_and_descriptives.do
*
* Project: sotrovimab-and-Paxlovid
*
* Programmed by: Bang Zheng
*
* Data used: output/input.csv
*
* Data created: output/main.dta (main analysis dataset)
*
* Other output: logs/data_preparation.log
*
********************************************************************************
*
* Purpose: This do-file creates the variables required for the
* main analysis and saves into Stata dataset, and describes
* variables by drug groups.
*
********************************************************************************
* Open a log file
cap log close
log using ./logs/data_preparation_feasibility_update, replace t
clear
* import dataset
import delimited ./output/input_feasibility_update.csv, delimiter(comma) varnames(1) case(preserve)
*describe
keep if covid_test_positive_date!=""
* Convert strings to dates *
foreach var of varlist covid_test_positive_date covid_test_positive_date2 covid_hosp_not_pri_admission covid_hosp_not_pri_admission2 covid_hosp_admission covid_hosp_admission2 ///
sotrovimab_GP paxlovid_GP molnupiravir_GP remdesivir_GP ///
date_treated_GP sotrovimab_covid_therapeutics_o paxlovid_covid_therapeutics_o molnupiravir_covid_therapeutics_ remdesivir_covid_therapeutics_o casirivimab_covid_therapeutics_o ///
date_treated_out death_with_covid_date death_date all_hosp_admission all_hosp_admission2 date_treated date_treated_hosp {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
sum `var',f de
}
}
gen infect_month=year(covid_test_positive_date)*100+month(covid_test_positive_date)
tab infect_month
gen infect_month2=year(covid_test_positive_date2)*100+month(covid_test_positive_date2)
tab infect_month2
tab region_nhs,m
tab region_nhs infect_month, row
tab region_nhs infect_month2, row
tab stp,m
tab stp infect_month, row
tab stp infect_month2, row
gen sotro_month_o=year(sotrovimab_covid_therapeutics_o)*100+month(sotrovimab_covid_therapeutics_o)
gen pax_month_o= year(paxlovid_covid_therapeutics_o)*100+month(paxlovid_covid_therapeutics_o)
gen mol_month_o= year(molnupiravir_covid_therapeutics_)*100+month(molnupiravir_covid_therapeutics_)
gen rem_month_o= year(remdesivir_covid_therapeutics_o)*100+month(remdesivir_covid_therapeutics_o)
gen treated_month_o= year(date_treated_out)*100+month(date_treated_out)
tab sotro_month_o
tab pax_month_o
tab mol_month_o
tab rem_month_o
tab treated_month_o
tab region_nhs sotro_month_o, row
tab region_nhs pax_month_o, row
tab region_nhs mol_month_o, row
tab region_nhs rem_month_o, row
tab region_nhs treated_month_o, row
tab stp treated_month_o,row
gen sotro_month_GP= year(sotrovimab_GP)*100+month(sotrovimab_GP)
gen pax_month_GP= year(paxlovid_GP)*100+month(paxlovid_GP)
gen mol_month_GP= year(molnupiravir_GP)*100+month(molnupiravir_GP)
gen rem_month_GP= year(remdesivir_GP)*100+month(remdesivir_GP)
gen treated_month_GP= year(date_treated_GP)*100+month(date_treated_GP)
tab sotro_month_GP
tab pax_month_GP
tab mol_month_GP
tab rem_month_GP
tab treated_month_GP
tab region_nhs sotro_month_GP, row
tab region_nhs pax_month_GP, row
tab region_nhs mol_month_GP, row
tab region_nhs rem_month_GP, row
tab region_nhs treated_month_GP, row
tab stp treated_month_GP,row
gen sotro_month=min(sotro_month_o,sotro_month_GP)
gen pax_month=min(pax_month_o,pax_month_GP)
gen mol_month=min(mol_month_o,mol_month_GP)
gen rem_month=min(rem_month_o,rem_month_GP)
gen treated_month=min(treated_month_o,treated_month_GP)
tab sotro_month
tab pax_month
tab mol_month
tab rem_month
tab treated_month
tab region_nhs sotro_month, row
tab region_nhs pax_month, row
tab region_nhs mol_month, row
tab region_nhs rem_month, row
tab region_nhs treated_month, row
tab stp treated_month,row
gen covid_hosp_not_pri_month= year(covid_hosp_not_pri_admission)*100+month(covid_hosp_not_pri_admission)
tab covid_hosp_not_pri_month
tab region_nhs covid_hosp_not_pri_month,row
tab stp covid_hosp_not_pri_month,row
gen covid_hosp_month= year(covid_hosp_admission)*100+month(covid_hosp_admission)
tab covid_hosp_month
tab region_nhs covid_hosp_month,row
tab stp covid_hosp_month,row
gen all_hosp_admission_month= year(all_hosp_admission)*100+month(all_hosp_admission)
tab all_hosp_admission_month
tab region_nhs all_hosp_admission_month,row
tab stp all_hosp_admission_month,row
gen all_hosp_admission_month2= year(all_hosp_admission2)*100+month(all_hosp_admission2)
tab all_hosp_admission_month2
tab region_nhs all_hosp_admission_month2,row
tab stp all_hosp_admission_month2,row
gen death_with_covid_month= year(death_with_covid_date)*100+month(death_with_covid_date)
tab death_with_covid_month
tab region_nhs death_with_covid_month,row
tab stp death_with_covid_month,row
gen death_month= year(death_date)*100+month(death_date)
tab death_month
tab region_nhs death_month,row
tab stp death_month,row
clear
* import dataset
import delimited ./output/input_feasibility_update.csv, delimiter(comma) varnames(1) case(preserve)
*describe
keep if date_treated_GP!="" | date_treated_out!=""
* Convert strings to dates *
foreach var of varlist covid_test_positive_date covid_test_positive_date2 sotrovimab_GP paxlovid_GP molnupiravir_GP remdesivir_GP ///
date_treated_GP sotrovimab_covid_therapeutics_o paxlovid_covid_therapeutics_o molnupiravir_covid_therapeutics_ remdesivir_covid_therapeutics_o casirivimab_covid_therapeutics_o ///
date_treated_out {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
sum `var',f de
}
}
gen infect_month= year(covid_test_positive_date)*100+month(covid_test_positive_date)
tab infect_month
gen infect_month2= year(covid_test_positive_date2)*100+month(covid_test_positive_date2)
tab infect_month2
tab region_nhs,m
tab region_nhs infect_month, row
tab region_nhs infect_month2, row
tab stp,m
tab stp infect_month, row
tab stp infect_month2, row
gen sotro_month_o= year(sotrovimab_covid_therapeutics_o)*100+month(sotrovimab_covid_therapeutics_o)
gen pax_month_o= year(paxlovid_covid_therapeutics_o)*100+month(paxlovid_covid_therapeutics_o)
gen mol_month_o= year(molnupiravir_covid_therapeutics_)*100+month(molnupiravir_covid_therapeutics_)
gen rem_month_o= year(remdesivir_covid_therapeutics_o)*100+month(remdesivir_covid_therapeutics_o)
gen treated_month_o= year(date_treated_out)*100+month(date_treated_out)
tab sotro_month_o
tab pax_month_o
tab mol_month_o
tab rem_month_o
tab treated_month_o
tab region_nhs sotro_month_o, row
tab region_nhs pax_month_o, row
tab region_nhs mol_month_o, row
tab region_nhs rem_month_o, row
tab region_nhs treated_month_o, row
tab stp treated_month_o,row
gen sotro_month_GP= year(sotrovimab_GP)*100+month(sotrovimab_GP)
gen pax_month_GP= year(paxlovid_GP)*100+month(paxlovid_GP)
gen mol_month_GP= year(molnupiravir_GP)*100+month(molnupiravir_GP)
gen rem_month_GP= year(remdesivir_GP)*100+month(remdesivir_GP)
gen treated_month_GP= year(date_treated_GP)*100+month(date_treated_GP)
tab sotro_month_GP
tab pax_month_GP
tab mol_month_GP
tab rem_month_GP
tab treated_month_GP
tab region_nhs sotro_month_GP, row
tab region_nhs pax_month_GP, row
tab region_nhs mol_month_GP, row
tab region_nhs rem_month_GP, row
tab region_nhs treated_month_GP, row
tab stp treated_month_GP,row
gen sotro_month=min(sotro_month_o,sotro_month_GP)
gen pax_month=min(pax_month_o,pax_month_GP)
gen mol_month=min(mol_month_o,mol_month_GP)
gen rem_month=min(rem_month_o,rem_month_GP)
gen treated_month=min(treated_month_o,treated_month_GP)
tab sotro_month
tab pax_month
tab mol_month
tab rem_month
tab treated_month
tab region_nhs sotro_month, row
tab region_nhs pax_month, row
tab region_nhs mol_month, row
tab region_nhs rem_month, row
tab region_nhs treated_month, row
tab stp treated_month,row
by treated_month, sort: count if infect_month==treated_month|infect_month==(treated_month-1)
clear
* import dataset
import delimited ./output/input_feasibility_update.csv, delimiter(comma) varnames(1) case(preserve)
*describe
keep if date_treated!="" | date_treated_hosp!=""
* Convert strings to dates *
foreach var of varlist date_treated date_treated_hosp {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
sum `var',f de
}
}
gen treated_month= year(date_treated)*100+month(date_treated)
tab treated_month
tab region_nhs treated_month, row
tab stp treated_month,row
gen treated_month_hosp= year(date_treated_hosp)*100+month(date_treated_hosp)
tab treated_month_hosp
tab region_nhs treated_month_hosp, row
tab stp treated_month_hosp,row
clear
* import dataset
import delimited ./output/input_feasibility_update.csv, delimiter(comma) varnames(1) case(preserve)
*describe
keep if all_hosp_admission!=""
* Convert strings to dates *
foreach var of varlist covid_test_positive_date covid_test_positive_date2 covid_hosp_not_pri_admission covid_hosp_not_pri_admission2 covid_hosp_admission covid_hosp_admission2 ///
all_hosp_admission all_hosp_admission2 {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
sum `var',f de
}
}
gen covid_hosp_not_pri_month= year(covid_hosp_not_pri_admission)*100+month(covid_hosp_not_pri_admission)
tab covid_hosp_not_pri_month
tab region_nhs covid_hosp_not_pri_month,row
tab stp covid_hosp_not_pri_month,row
gen covid_hosp_month= year(covid_hosp_admission)*100+month(covid_hosp_admission)
tab covid_hosp_month
tab region_nhs covid_hosp_month,row
tab stp covid_hosp_month,row
gen all_hosp_admission_month= year(all_hosp_admission)*100+month(all_hosp_admission)
tab all_hosp_admission_month
tab region_nhs all_hosp_admission_month,row
tab stp all_hosp_admission_month,row
gen all_hosp_admission_month2= year(all_hosp_admission2)*100+month(all_hosp_admission2)
tab all_hosp_admission_month2
tab region_nhs all_hosp_admission_month2,row
tab stp all_hosp_admission_month2,row
gen infect_month= year(covid_test_positive_date)*100+month(covid_test_positive_date)
by covid_hosp_not_pri_month, sort: count if infect_month==covid_hosp_not_pri_month|infect_month==(covid_hosp_not_pri_month-1)
clear
* import dataset
import delimited ./output/input_feasibility_update.csv, delimiter(comma) varnames(1) case(preserve)
*describe
keep if death_date!=""
* Convert strings to dates *
foreach var of varlist death_with_covid_date death_date {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
sum `var',f de
}
}
gen death_with_covid_month= year(death_with_covid_date)*100+month(death_with_covid_date)
tab death_with_covid_month
tab region_nhs death_with_covid_month,row
tab stp death_with_covid_month,row
gen death_month= year(death_date)*100+month(death_date)
tab death_month
tab region_nhs death_month,row
tab stp death_month,row
clear
*high-risk cohort*
* import dataset
import delimited ./output/input_feasibility_update.csv, delimiter(comma) varnames(1) case(preserve)
drop if cancer_opensafely_snomed_new==""&immunosuppresant_drugs_nhsd==""&oral_steroid_drugs_nhsd==""&immunosupression_nhsd_new==""&solid_organ_transplant_nhsd_new==""&downs_syndrome_nhsd==""&haematological_disease_nhsd==""&ckd_stage_5_nhsd==""&liver_disease_nhsd==""&hiv_aids_nhsd==""&multiple_sclerosis_nhsd==""&motor_neurone_disease_nhsd==""&myasthenia_gravis_nhsd==""&huntingtons_disease_nhsd==""
foreach var of varlist covid_test_positive_date covid_test_positive_date2 covid_hosp_not_pri_admission covid_hosp_not_pri_admission2 covid_hosp_admission covid_hosp_admission2 ///
sotrovimab_GP paxlovid_GP molnupiravir_GP remdesivir_GP ///
date_treated_GP sotrovimab_covid_therapeutics_o paxlovid_covid_therapeutics_o molnupiravir_covid_therapeutics_ remdesivir_covid_therapeutics_o casirivimab_covid_therapeutics_o ///
date_treated_out death_with_covid_date death_date all_hosp_admission all_hosp_admission2 date_treated date_treated_hosp ///
cancer_opensafely_snomed_new immunosuppresant_drugs_nhsd ///
oral_steroid_drugs_nhsd immunosupression_nhsd_new solid_organ_transplant_nhsd_new haematological_malignancies_snom haematological_malignancies_icd1 ///
downs_syndrome_nhsd haematological_disease_nhsd ckd_stage_5_nhsd liver_disease_nhsd hiv_aids_nhsd ///
multiple_sclerosis_nhsd motor_neurone_disease_nhsd myasthenia_gravis_nhsd huntingtons_disease_nhsd liver_disease_nhsd_icd10 {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
}
}
*10 high risk groups: downs_syndrome, solid_cancer, haematological_disease, renal_disease, liver_disease, imid,
*immunosupression, hiv_aids, solid_organ_transplant, rare_neurological_conditions, high_risk_group_combined
replace oral_steroid_drugs_nhsd=. if oral_steroid_drug_nhsd_3m_count < 2 & oral_steroid_drug_nhsd_12m_count < 4
gen imid_nhsd=min(oral_steroid_drugs_nhsd, immunosuppresant_drugs_nhsd)
gen rare_neuro_nhsd = min(multiple_sclerosis_nhsd, motor_neurone_disease_nhsd, myasthenia_gravis_nhsd, huntingtons_disease_nhsd)
*high risk group only based on codelists*
gen downs_syndrome=(downs_syndrome_nhsd!=.)
gen solid_cancer_new=(cancer_opensafely_snomed_new!=.)
tab solid_cancer_new
gen haema_disease=( haematological_disease_nhsd !=.)
tab haema_disease
gen renal_disease=( ckd_stage_5_nhsd !=.)
gen liver_disease=( liver_disease_nhsd !=.)
gen imid=( imid_nhsd !=.)
tab imid
gen immunosupression_new=( immunosupression_nhsd_new!=.)
tab immunosupression_new
gen hiv_aids=( hiv_aids_nhsd !=.)
tab hiv_aids
gen solid_organ_new=( solid_organ_transplant_nhsd_new!=.)
tab solid_organ_new
gen rare_neuro=( rare_neuro_nhsd !=.)
gen high_risk_group_new=(( downs_syndrome + solid_cancer_new + haema_disease + renal_disease + liver_disease + imid + immunosupression_new + hiv_aids + solid_organ_new + rare_neuro )>0)
tab high_risk_group_new,m
keep if high_risk_group_new==1
count
gen infect_month= year(covid_test_positive_date)*100+month(covid_test_positive_date)
tab infect_month
gen infect_month2= year(covid_test_positive_date2)*100+month(covid_test_positive_date2)
tab infect_month2
tab region_nhs,m
tab region_nhs infect_month, row
tab region_nhs infect_month2, row
tab stp,m
tab stp infect_month, row
tab stp infect_month2, row
gen sotro_month_o= year(sotrovimab_covid_therapeutics_o)*100+month(sotrovimab_covid_therapeutics_o)
gen pax_month_o= year(paxlovid_covid_therapeutics_o)*100+month(paxlovid_covid_therapeutics_o)
gen mol_month_o= year(molnupiravir_covid_therapeutics_)*100+month(molnupiravir_covid_therapeutics_)
gen rem_month_o= year(remdesivir_covid_therapeutics_o)*100+month(remdesivir_covid_therapeutics_o)
gen treated_month_o= year(date_treated_out)*100+month(date_treated_out)
tab sotro_month_o
tab pax_month_o
tab mol_month_o
tab rem_month_o
tab treated_month_o
tab region_nhs sotro_month_o, row
tab region_nhs pax_month_o, row
tab region_nhs mol_month_o, row
tab region_nhs rem_month_o, row
tab region_nhs treated_month_o, row
tab stp treated_month_o,row
gen sotro_month_GP= year(sotrovimab_GP)*100+month(sotrovimab_GP)
gen pax_month_GP= year(paxlovid_GP)*100+month(paxlovid_GP)
gen mol_month_GP= year(molnupiravir_GP)*100+month(molnupiravir_GP)
gen rem_month_GP= year(remdesivir_GP)*100+month(remdesivir_GP)
gen treated_month_GP= year(date_treated_GP)*100+month(date_treated_GP)
tab sotro_month_GP
tab pax_month_GP
tab mol_month_GP
tab rem_month_GP
tab treated_month_GP
tab region_nhs sotro_month_GP, row
tab region_nhs pax_month_GP, row
tab region_nhs mol_month_GP, row
tab region_nhs rem_month_GP, row
tab region_nhs treated_month_GP, row
tab stp treated_month_GP,row
gen sotro_month=min(sotro_month_o,sotro_month_GP)
gen pax_month=min(pax_month_o,pax_month_GP)
gen mol_month=min(mol_month_o,mol_month_GP)
gen rem_month=min(rem_month_o,rem_month_GP)
gen treated_month=min(treated_month_o,treated_month_GP)
tab sotro_month
tab pax_month
tab mol_month
tab rem_month
tab treated_month
tab region_nhs sotro_month, row
tab region_nhs pax_month, row
tab region_nhs mol_month, row
tab region_nhs rem_month, row
tab region_nhs treated_month, row
tab stp treated_month,row
gen covid_hosp_not_pri_month= year(covid_hosp_not_pri_admission)*100+month(covid_hosp_not_pri_admission)
tab covid_hosp_not_pri_month
tab region_nhs covid_hosp_not_pri_month,row
tab stp covid_hosp_not_pri_month,row
gen covid_hosp_month= year(covid_hosp_admission)*100+month(covid_hosp_admission)
tab covid_hosp_month
tab region_nhs covid_hosp_month,row
tab stp covid_hosp_month,row
gen all_hosp_admission_month= year(all_hosp_admission)*100+month(all_hosp_admission)
tab all_hosp_admission_month
tab region_nhs all_hosp_admission_month,row
tab stp all_hosp_admission_month,row
gen all_hosp_admission_month2= year(all_hosp_admission2)*100+month(all_hosp_admission2)
tab all_hosp_admission_month2
tab region_nhs all_hosp_admission_month2,row
tab stp all_hosp_admission_month2,row
gen death_with_covid_month= year(death_with_covid_date)*100+month(death_with_covid_date)
tab death_with_covid_month
tab region_nhs death_with_covid_month,row
tab stp death_with_covid_month,row
gen death_month= year(death_date)*100+month(death_date)
tab death_month
tab region_nhs death_month,row
tab stp death_month,row
gen treated_month_onset= year(date_treated)*100+month(date_treated)
tab treated_month_onset
tab region_nhs treated_month_onset, row
tab stp treated_month_onset,row
gen treated_month_hosp= year(date_treated_hosp)*100+month(date_treated_hosp)
tab treated_month_hosp
tab region_nhs treated_month_hosp, row
tab stp treated_month_hosp,row
log close
exit, clear
*codebook
keep if date_treated!=""|date_treated_hosp!=""|all_hosp_admission!=""
* Convert strings to dates *
foreach var of varlist sotrovimab_covid_therapeutics molnupiravir_covid_therapeutics paxlovid_covid_therapeutics remdesivir_covid_therapeutics ///
casirivimab_covid_therapeutics tocilizumab_covid_therapeutics sarilumab_covid_therapeutics baricitinib_covid_hosp date_treated ///
sotrovimab_covid_hosp paxlovid_covid_hosp molnupiravir_covid_hosp remdesivir_covid_hosp casirivimab_covid_hosp tocilizumab_covid_hosp sarilumab_covid_hosp ///
date_treated_hosp start_date death_with_covid_date death_with_covid_underly_date death_date covid_hosp_not_pri_admission covid_hosp_not_pri_discharge ///
covid_hosp_not_pri_admission2 covid_hosp_not_pri_discharge2 covid_hosp_admission covid_hosp_discharge covid_hosp_admission2 covid_hosp_discharge2 ///
all_hosp_admission all_hosp_discharge all_hosp_admission2 all_hosp_discharge2 all_hosp_admission_onset covid_hosp_admission_onset covid_hosp_not_pri_onset ///
all_hosp_admission_hosp covid_hosp_admission_hosp covid_hosp_not_pri_hosp covid_test_positive_date covid_test_positive_date2 covid_test_positive_onset ///
covid_test_positive_hosp covid_test_positive_all_hosp covid_test_positive_all_hosp2 covid_test_positive_covid_hosp covid_test_positive_covid_hosp2 ///
covid_test_positive_not_pri covid_test_positive_not_pri2 {
capture confirm string variable `var'
if _rc==0 {
rename `var' a
gen `var' = date(a, "YMD")
drop a
format %td `var'
sum `var',f
}
}
tab covid_therapeutics
tab registered_treated
tab covid_therapeutics_hosp
tab registered_treated_hosp
tab covid_therapeutics if date_treated>=mdy(12,16,2021)
tab covid_therapeutics_hosp if date_treated_hosp>=mdy(12,16,2021)
tab high_risk_cohort_covid_therapeut
tab high_risk_cohort_covid_therapeut if covid_therapeutics!=""
tab high_risk_cohort_covid_therapeut if covid_therapeutics_hosp!=""
*check hosp records*
gen treated_onset=(date_treated!=.)
gen treated_hosp=(date_treated_hosp!=.)
count if treated_onset==1&((date_treated>=covid_hosp_not_pri_admission&date_treated<=covid_hosp_not_pri_discharge)|(date_treated>=covid_hosp_not_pri_admission2&date_treated<=covid_hosp_not_pri_discharge2))
count if treated_onset==1&((date_treated>=covid_hosp_admission&date_treated<=covid_hosp_discharge)|(date_treated>=covid_hosp_admission2&date_treated<=covid_hosp_discharge2))
count if treated_onset==1&((date_treated>=all_hosp_admission&date_treated<=all_hosp_discharge)|(date_treated>=all_hosp_admission2&date_treated<=all_hosp_discharge2))
count if treated_onset==1&(((date_treated+1)>=covid_hosp_not_pri_admission&(date_treated-1)<=covid_hosp_not_pri_discharge)|((date_treated+1)>=covid_hosp_not_pri_admission2&(date_treated-1)<=covid_hosp_not_pri_discharge2))
count if treated_onset==1&(((date_treated+3)>=covid_hosp_not_pri_admission&(date_treated-3)<=covid_hosp_not_pri_discharge)|((date_treated+3)>=covid_hosp_not_pri_admission2&(date_treated-3)<=covid_hosp_not_pri_discharge2))
count if treated_onset==1&(((date_treated+1)>=covid_hosp_admission&(date_treated-1)<=covid_hosp_discharge)|((date_treated+1)>=covid_hosp_admission2&(date_treated-1)<=covid_hosp_discharge2))
count if treated_onset==1&(((date_treated+3)>=covid_hosp_admission&(date_treated-3)<=covid_hosp_discharge)|((date_treated+3)>=covid_hosp_admission2&(date_treated-3)<=covid_hosp_discharge2))
count if treated_onset==1&all_hosp_admission_onset!=.
count if treated_onset==1&covid_hosp_admission_onset!=.
count if treated_onset==1&covid_hosp_not_pri_onset!=.
count if treated_hosp==1&((date_treated_hosp>=covid_hosp_not_pri_admission&date_treated_hosp<=covid_hosp_not_pri_discharge)|(date_treated_hosp>=covid_hosp_not_pri_admission2&date_treated_hosp<=covid_hosp_not_pri_discharge2))
count if treated_hosp==1&((date_treated_hosp>=covid_hosp_admission&date_treated_hosp<=covid_hosp_discharge)|(date_treated_hosp>=covid_hosp_admission2&date_treated_hosp<=covid_hosp_discharge2))
count if treated_hosp==1&((date_treated_hosp>=all_hosp_admission&date_treated_hosp<=all_hosp_discharge)|(date_treated_hosp>=all_hosp_admission2&date_treated_hosp<=all_hosp_discharge2))
count if treated_hosp==1&(((date_treated_hosp+1)>=covid_hosp_not_pri_admission&(date_treated_hosp-1)<=covid_hosp_not_pri_discharge)|((date_treated_hosp+1)>=covid_hosp_not_pri_admission2&(date_treated_hosp-1)<=covid_hosp_not_pri_discharge2))
count if treated_hosp==1&(((date_treated_hosp+3)>=covid_hosp_not_pri_admission&(date_treated_hosp-3)<=covid_hosp_not_pri_discharge)|((date_treated_hosp+3)>=covid_hosp_not_pri_admission2&(date_treated_hosp-3)<=covid_hosp_not_pri_discharge2))
count if treated_hosp==1&(((date_treated_hosp+1)>=covid_hosp_admission&(date_treated_hosp-1)<=covid_hosp_discharge)|((date_treated_hosp+1)>=covid_hosp_admission2&(date_treated_hosp-1)<=covid_hosp_discharge2))
count if treated_hosp==1&(((date_treated_hosp+3)>=covid_hosp_admission&(date_treated_hosp-3)<=covid_hosp_discharge)|((date_treated_hosp+3)>=covid_hosp_admission2&(date_treated_hosp-3)<=covid_hosp_discharge2))
count if treated_hosp==1&all_hosp_admission_hosp!=.
count if treated_hosp==1&covid_hosp_admission_hosp!=.
count if treated_hosp==1&covid_hosp_not_pri_hosp!=.
*check covid test*
count if treated_onset==1&covid_test_positive_onset!=.
count if treated_hosp==1&covid_test_positive_hosp!=.
*distinguish onset and hosp*
tab treated_onset if start_date!=.&((start_date>=covid_hosp_not_pri_admission&start_date<=covid_hosp_not_pri_discharge)|(start_date>=covid_hosp_not_pri_admission2&start_date<=covid_hosp_not_pri_discharge2))
tab treated_onset if start_date!=.&((start_date>=covid_hosp_admission&start_date<=covid_hosp_discharge)|(start_date>=covid_hosp_admission2&start_date<=covid_hosp_discharge2))
tab treated_hosp if start_date!=.&((start_date>=covid_hosp_not_pri_admission&start_date<=covid_hosp_not_pri_discharge)|(start_date>=covid_hosp_not_pri_admission2&start_date<=covid_hosp_not_pri_discharge2))
tab treated_hosp if start_date!=.&((start_date>=covid_hosp_admission&start_date<=covid_hosp_discharge)|(start_date>=covid_hosp_admission2&start_date<=covid_hosp_discharge2))
tab treated_onset if start_date!=.&((start_date>=covid_hosp_not_pri_admission&start_date<=covid_hosp_not_pri_discharge&covid_test_positive_not_pri>covid_hosp_not_pri_admission)|(start_date>=covid_hosp_not_pri_admission2&start_date<=covid_hosp_not_pri_discharge2&covid_test_positive_not_pri2>covid_hosp_not_pri_admission2))
tab treated_onset if start_date!=.&((start_date>=covid_hosp_admission&start_date<=covid_hosp_discharge&covid_test_positive_covid_hosp>covid_hosp_admission)|(start_date>=covid_hosp_admission2&start_date<=covid_hosp_discharge2&covid_test_positive_covid_hosp2>covid_hosp_admission2))
tab treated_onset if start_date!=.&((start_date>=all_hosp_admission&start_date<=all_hosp_discharge&covid_test_positive_all_hosp>all_hosp_admission)|(start_date>=all_hosp_admission2&start_date<=all_hosp_discharge2&covid_test_positive_all_hosp2>all_hosp_admission2))
tab treated_onset if start_date!=.&((start_date>=covid_hosp_not_pri_admission&start_date<=covid_hosp_not_pri_discharge&covid_test_positive_not_pri>covid_hosp_not_pri_admission&covid_test_positive_not_pri!=.)|(start_date>=covid_hosp_not_pri_admission2&start_date<=covid_hosp_not_pri_discharge2&covid_test_positive_not_pri2>covid_hosp_not_pri_admission2&covid_test_positive_not_pri2!=.))
tab treated_onset if start_date!=.&((start_date>=covid_hosp_admission&start_date<=covid_hosp_discharge&covid_test_positive_covid_hosp>covid_hosp_admission&covid_test_positive_covid_hosp!=.)|(start_date>=covid_hosp_admission2&start_date<=covid_hosp_discharge2&covid_test_positive_covid_hosp2>covid_hosp_admission2&covid_test_positive_covid_hosp2!=.))
tab treated_onset if start_date!=.&((start_date>=all_hosp_admission&start_date<=all_hosp_discharge&covid_test_positive_all_hosp>all_hosp_admission&covid_test_positive_all_hosp!=.)|(start_date>=all_hosp_admission2&start_date<=all_hosp_discharge2&covid_test_positive_all_hosp2>all_hosp_admission2&covid_test_positive_all_hosp2!=.))
tab treated_hosp if start_date!=.&((start_date>=covid_hosp_not_pri_admission&start_date<=covid_hosp_not_pri_discharge&covid_test_positive_not_pri<=covid_hosp_not_pri_admission)|(start_date>=covid_hosp_not_pri_admission2&start_date<=covid_hosp_not_pri_discharge2&covid_test_positive_not_pri2<=covid_hosp_not_pri_admission2))
tab treated_hosp if start_date!=.&((start_date>=covid_hosp_admission&start_date<=covid_hosp_discharge&covid_test_positive_covid_hosp<=covid_hosp_admission)|(start_date>=covid_hosp_admission2&start_date<=covid_hosp_discharge2&covid_test_positive_covid_hosp2<=covid_hosp_admission2))
tab treated_hosp if start_date!=.&((start_date>=all_hosp_admission&start_date<=all_hosp_discharge&covid_test_positive_all_hosp<=all_hosp_admission)|(start_date>=all_hosp_admission2&start_date<=all_hosp_discharge2&covid_test_positive_all_hosp2<=all_hosp_admission2))
count if tocilizumab_covid_hosp!=.&death_with_covid_date!=.
count if sarilumab_covid_hosp!=.&death_with_covid_date!=.
count if tocilizumab_covid_hosp!=.&death_date!=.
count if sarilumab_covid_hosp!=.&death_date!=.
*check hosp/death event date range*
*codebook covid_hosp_outcome_date2 hospitalisation_outcome_date2 death_date
*exclusion criteria*
log close