Operational Challenges in the Use of Structured Secondary Data for Health Research

Abstract

Background: In Brazil, secondary data for epidemiology are largely available. However, they are insufficiently prepared for use in research, even when it comes to structured data since they were often designed for other purposes. To date, few publications focus on the process of preparing secondary data. The present findings can help in orienting future research projects that are based on secondary data.Objective: Describe the steps in the process of ensuring the adequacy of a secondary data set for a specific use and to identify the challenges of this process.Methods: The present study is qualitative and reports methodological issues about secondary data use. The study material was comprised of 6,059,454 live births and 73,735 infant death records from 2004 to 2013 of children whose mothers resided in the State of São Paulo - Brazil. The challenges and description of the procedures to ensure data adequacy were undertaken in 6 steps: (1) problem understanding, (2) resource planning, (3) data understanding, (4) data preparation, (5) data validation and (6) data distribution. For each step, procedures, and challenges encountered, and the actions to cope with them and partial results were described. To identify the most labor-intensive tasks in this process, the steps were assessed by adding the number of procedures, challenges, and coping actions. The highest values were assumed to indicate the most critical steps.Results: In total, 22 procedures and 23 actions were needed to deal with the 27 challenges encountered along the process of ensuring the adequacy of the study material for the intended use. The final product was an organized database for a historical cohort study suitable for the intended use. Data understanding and data preparation were identified as the most critical steps, accounting for about 70% of the challenges observed for data using.Conclusion: Significant challenges were encountered in the process of ensuring the adequacy of secondary health data for research use, mainly in the data understanding and data preparation steps. The use of the described steps to approach structured secondary data and the knowledge of the potential challenges along the process may contribute to planning health research.

Congenital diaphragmatic hernia in a middle-income country: Persistent high lethality during a 12-year period

“…Furthermore, comparing our CDH lethality with the 65% reported by another populationbased study carried out in the state of São Paulo using DATASUS [11], possibly the greatest consistency of our database, with more than 99% of linkage between neonatal death records and live birth records, resulted in better retrieval of information and the higher lethality found in our study [18,29].…”

“…Based on live birth and death information, SEADE Foundation makes the deterministic linkage from death to live birth records in order to identify birth information from all infants who died within 365 days after birth [17]. The data set was organized according to the study design towards a final database integrating common birth variables among the neonatal death records and live birth records, ensuring 99% of success in linkage between both datasets [18].…”

Clusters of preterm live births and respiratory distress syndrome-associated neonatal deaths: spatial distribution and cooccurrence patterns

“…SEADE Foundation made the deterministic linkage of death and live birth records to identify the birth information for all infants who died within 365 days after birth [ 22 ]. To adapt the data set to the study design, a final database was created by integrating the birth variables common among the neonatal death records, retrieved from the linked database, with the live birth records [ 23 ].…”

Evaluating Brazil’s national administrative claims data for real-world pharmacoepidemiologic studies: Trends in rheumatoid arthritis using DATASUS (2010–2020)

“…Often regarded as the foundation for pharmacoepidemiologic research, claims data are used for post-marketing drug surveillance, cost-effectiveness evaluations, and when evaluating preventive therapeutic strategies. [7,17,40] Our analyses of DATASUS provided insights on the treatment patterns relevant to individuals living with RA in Brazil that may contribute to a more accurate prediction of future healthcare planning, helping to adapt the Brazilian healthcare system to these changes.…”