Data preparation techniques for a perinatal psychiatric study based on linked data

Publisher:
BioMed Central
Publication Type:
Journal Article
Citation:
BMC Medical Research Methodology, 2012, 12 pp. 1 - 9
Issue Date:
2012-06-08
Full metadata record
Files in This Item:
Filename Description Size
Thumbnail2013003089OK.pdf933.26 kB
Adobe PDF
Background In recent years there has been an increase in the use of population-based linked data. However, there is little literature that describes the method of linked data preparation. This paper describes the method for merging data, calculating the statistical variable (SV), recoding psychiatric diagnoses and summarizing hospital admissions for a perinatal psychiatric study. Methods The data preparation techniques described in this paper are based on linked birth data from the New South Wales (NSW) Midwives Data Collection (MDC), the Register of Congenital Conditions (RCC), the Admitted Patient Data Collection (APDC) and the Pharmaceutical Drugs of Addiction System (PHDAS). Results The master dataset is the meaningfully linked data which include all or major study data collections. The master dataset can be used to improve the data quality, calculate the SV and can be tailored for different analyses. To identify hospital admissions in the periods before pregnancy, during pregnancy and after birth, a statistical variable of time interval (SVTI) needs to be calculated. The methods and SPSS syntax for building a master dataset, calculating the SVTI, recoding the principal diagnoses of mental illness and summarizing hospital admissions are described. Conclusion Linked data preparation, including building the master dataset and calculating the SV, can improve data quality and enhance data function.
Please use this identifier to cite or link to this item: