Procedures for health data linkage: applications in Health Surveillance

• Autor(a) principal: Garcia, Klauss Kleydmann Sabino
• Data de Publicação: 2022
• Outros Autores: Miranda, Cristiano Barreto de, Sousa, Flávia Nogueira e Ferreira de
• Tipo de documento: preprint
• Idioma: por
• Título da fonte: SciELO Preprints
• Texto Completo: https://preprints.scielo.org/index.php/scielo/preprint/view/4682
• topic: Análise de dados; Epidemiologia; Saúde Coletiva; Vigilância em Saúde Pública; Data Analysis; Epidemiology; Public Health; Public Health Surveillance; Análisis de Datos; Epidemiología; Salud Pública; Vigilancia en Salud Pública

Objective: To present a standardized methodology for linking different public health databases. Methods: Methodological review article specifically describes data processing processes for deterministic linkage between structured databases. It was instructed how to: treat the data, select binding keys, and link the banks using two simulated databases in the R software. Results: The commands used for the deterministic binding of the inner_join type were presented. The linking process resulted in a database with 40,108 pairs using only the ‘name’ key. The addition of the second key, ‘Mother's name’, resulted in 112 pairs. By adding the third key, ‘Date of birth’, only two pairs were identified. Conclusion: The linking of databases and their analyses are valid and valuable tools for health services to support health surveillance actions.