1 / 40

THRio

THRio. Antonio G F Pacheco. THRio. Outline Database setup Creating a master table with main outcomes Mortality recovery with linkage Issues and differences between units. THRio. Database. THRio. We needed to evaluate the intervention

camden-leblanc
Download Presentation

THRio

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. THRio Antonio G F Pacheco

  2. THRio • Outline • Database setup • Creating a master table with main outcomes • Mortality recovery with linkage • Issues and differences between units

  3. THRio Database

  4. THRio • We needed to evaluate the intervention • Intervention itself is training professionals and facilitate guidelines implementation • Request TST for eligible patients • Give IPT for eligible patients • First approach • Percentages • Given eligible patients for TST • Given eligible patients for IPT • There are problems with this approach

  5. THRio • Issues • There is a lead time between training and following guidelines • That’s variable for each clinic • Frequency with which patients return to clinic • Logistic problems within the clinic • TST is not placed every day • To start IPT, TB has to be ruled out • It could take a long time to get a chest X-ray!!!

  6. THRio • We thought we would have to take time into account! • Instead of percentages, rates • The process a patient goes through is pretty complex • There are dynamics issues involved • We tried to understand the dynamics first

  7. THRio • Understanding the dynamics of patients • Patients may go through several ‘states’ • Events of interest are all dated • It is possible to calculate transition rates • It would be useful for process analysis • Taking time into account • Let’s see it schematically…

  8. Dynamics

  9. THRio • Main table generated by the system • Based on the schematic part only • Takes info from several tables • Lots of programming involved • 9 SQL views • Delphi (Pascal) programming • > 1000 lines of code • Computationally-intensive • About 40 min in a AMD 2 x 1.6 GHz with 2Gb RAM

  10. THRio • Other outcomes included • TB outcomes • IPT outcomes • 20 different codes (with dates) • Long format database • Let’s see an example with some fake data…

  11. THRio • Actually now it is easy to extend it • Implemented in Python • Mainly date functions • Could easily be extended in other languages (e.g. SAS) • Extra info from patients • HAART • CD4 • VL • Extra info from study • Intervention status

  12. THRio • Let’s see one script…

  13. THRio • Now we can calculate rates • Can present data as a survival analysis • Compare pre- and post-intervention • Calendar x non-calendar analysis • Dynamics of the study • Dynamics of the intervention • Can be presented by clinic as well

  14. THRio

  15. THRio

  16. THRio

  17. THRio Death Rates

  18. THRio • Death rates over time in our cohort • How many deaths are we missing? • With linkage we are able to improve the numbers • But how much? • Is our death rate reasonable? • Are there differences over time? • Are there differences across units?

  19. THRio • Patients known to be dead at data abstraction • Between Sep ’03 and Sep ’05 • Abstracted as ‘inactive’ • In the beginning not even after Sep ’05 • We started recovering them • Since Sep ‘03 • No data abstracted if patients did not have a visit after Sep ‘03

  20. THRio • Problem • These patients are not included in the analyses • Potential biases on results • Linkage with main database would fail • If we don’t even have names or DOBs • Main biases • Outcomes unrelated with deaths • Outcomes associated with deaths • Death as an outcome

  21. THRio • Overall death rates: • From Sep ’03-Aug ’05 • 1.95/100 pys • From Sep ’05-Mar ’07 • 3.49/100 pys • The problem is: there is no reason to believe the rates are increasing • If we are missing during the study, it is much worse before it began! • Let’s see the rates per year…

  22. THRio

  23. THRio • To better understand what’s going on • Rates per 4-month periods from Jan ’03-Mar ’07 • Number of deaths • Person-years contribution • There are at least 3 things to be explained…

  24. THRio

  25. THRio

  26. THRio

  27. THRio • What about differences among units? • Let’s try to see the issues of person-time and deaths per units • Starting with the person-years…

  28. THRio

  29. THRio • The mean contribution is lower for half of the units • This is an operational issue of the way data is collected in this study • For the 10th and 11th periods, it doesn’t seem that bad • For deaths, if we exclude the 1st, 2nd and last periods, we can compare the rates per unit

  30. THRio • Let’s see the death rates • Excluding the 1st, 2nd periods • Using 9th, 10th and 11th periods as the standard death rate • Rates and 95% CIs per unit • A little underestimated • Let’s compare the death rates in the other periods per unit • How it is evolving over time • 6th and 7th periods problem

  31. THRio

  32. THRio

  33. THRio • In fact some units caught up earlier • Majority did not • Even the ones that are within the CIs are consistently lower than the reference rate • 7 units have similar rates • Problem • Some units remove charts from archives soon after the patient is known to be dead • Let’s look at those periods…

  34. THRio

  35. THRio • Let’s try to see all of them over time…

  36. THRio

  37. THRio • So far, it looks a bad idea to use the time period before the study began to study mortality • What could be done to improve that? • Run linkage with inactive patients • We wouldn’t have all the info • But could at least learn about vital status • Would help for Sep ’03 to Dec ‘05

  38. THRio • What about the mortality after the study began? • My guess is that we will have about 3.6/100 pys • Let’s see where it comes from

  39. THRio

  40. THRio • Further steps • Compare that rate with rates in the literature • Stratify them by HAART use and CD4 counts • See if rates per stratum are reasonable • Also compare with other studies

More Related