A pragmatic method for transforming clinical research data from the research electronic data capture "REDCap" to Clinical Data Interchange Standards Consortium (CDISC) Study Data Tabulation Model (SDTM): Development and evaluation of REDCap2SDTM
- PMID: 28487263
- DOI: 10.1016/j.jbi.2017.05.003
A pragmatic method for transforming clinical research data from the research electronic data capture "REDCap" to Clinical Data Interchange Standards Consortium (CDISC) Study Data Tabulation Model (SDTM): Development and evaluation of REDCap2SDTM
Abstract
The Clinical Data Interchange Standards Consortium (CDISC) Study Data Tabulation Model (SDTM) can be used for new drug application studies as well as secondarily for creating a clinical research data warehouse to leverage clinical research study data across studies conducted within the same disease area. However, currently not all clinical research uses Clinical Data Acquisition Standards Harmonization (CDASH) beginning in the set-up phase of the study. Once already initiated, clinical studies that have not utilized CDASH are difficult to map in the SDTM format. In addition, most electronic data capture (EDC) systems are not equipped to export data in SDTM format; therefore, in many cases, statistical software is used to generate SDTM datasets from accumulated clinical data. In order to facilitate efficient secondary use of accumulated clinical research data using SDTM, it is necessary to develop a new tool to enable mapping of information for SDTM, even during or after the clinical research. REDCap is an EDC system developed by Vanderbilt University and is used globally by over 2100 institutions across 108 countries. In this study, we developed a simulated clinical trial to evaluate a tool called REDCap2SDTM that maps information in the Field Annotation of REDCap to SDTM and executes data conversion, including when data must be pivoted to accommodate the SDTM format, dynamically, by parsing the mapping information using R. We confirmed that generating SDTM data and the define.xml file from REDCap using REDCap2SDTM was possible. Conventionally, generation of SDTM data and the define.xml file from EDC systems requires the creation of individual programs for each clinical study. However, our proposed method can be used to generate this data and file dynamically without programming because it only involves entering the mapping information into the Field Annotation, and additional data into specific files. Our proposed method is adaptable not only to new drug application studies but also to all types of research, including observational and public health studies. Our method is also adaptable to clinical data collected with CDASH at the beginning of a study in non-standard format. We believe that this tool will reduce the workload of new drug application studies and will support data sharing and reuse of clinical research data in academia.
Keywords: Clinical research data warehouse; Clinical research informatics; Clinical trial; Data standards; New drug application.
Copyright © 2017 Elsevier Inc. All rights reserved.
Similar articles
-
A Pragmatic Method to Integrate Data From Preexisting Cohort Studies Using the Clinical Data Interchange Standards Consortium (CDISC) Study Data Tabulation Model: Case Study.JMIR Med Inform. 2023 Dec 21;11:e46725. doi: 10.2196/46725. JMIR Med Inform. 2023. PMID: 38153801 Free PMC article.
-
[Introduction to Research Electronic Data Capture (REDCap) and REDCap2SDTM, a Conversion Tool to Facilitate Clinical Research Data Sharing].Brain Nerve. 2017 Jul;69(7):848-855. doi: 10.11477/mf.1416200830. Brain Nerve. 2017. PMID: 28740000 Japanese.
-
A Pragmatic Method to Integrate Data from Pre-existing Cohort Studies using the Clinical Data Interchange Standards Consortium (CDISC) Study Data Tabulation Model: Practical use of REDCap2SDTM.JMIR Med Inform. 2023 Sep 14. doi: 10.2196/46725. Online ahead of print. JMIR Med Inform. 2023. PMID: 37768110
-
Responses to the Standard for Exchange of Nonclinical Data (SEND) in non-US countries.J Toxicol Pathol. 2015 Apr;28(2):57-64. doi: 10.1293/tox.2015-0007. Epub 2015 Apr 1. J Toxicol Pathol. 2015. PMID: 26028814 Free PMC article. Review.
-
Current applications and future directions for the CDISC Operational Data Model standard: A methodological review.J Biomed Inform. 2016 Apr;60:352-62. doi: 10.1016/j.jbi.2016.02.016. Epub 2016 Mar 2. J Biomed Inform. 2016. PMID: 26944737 Free PMC article. Review.
Cited by
-
A Pragmatic Method to Integrate Data From Preexisting Cohort Studies Using the Clinical Data Interchange Standards Consortium (CDISC) Study Data Tabulation Model: Case Study.JMIR Med Inform. 2023 Dec 21;11:e46725. doi: 10.2196/46725. JMIR Med Inform. 2023. PMID: 38153801 Free PMC article.
-
Awareness, understanding, and interest in personalized medicine: A cross-sectional survey study of college students.PLoS One. 2023 Jan 25;18(1):e0280832. doi: 10.1371/journal.pone.0280832. eCollection 2023. PLoS One. 2023. PMID: 36696425 Free PMC article.
-
Integrating REDCap patient-reported outcomes with the HealtheIntent population health platform: proof of concept.JAMIA Open. 2023 Aug 29;6(3):ooad074. doi: 10.1093/jamiaopen/ooad074. eCollection 2023 Oct. JAMIA Open. 2023. PMID: 37649989 Free PMC article.
-
The transformation of a gold standard in-person substance use assessment to a web-based, REDCap integrated data capture tool.J Biomed Inform. 2019 Jun;94:103186. doi: 10.1016/j.jbi.2019.103186. Epub 2019 Apr 22. J Biomed Inform. 2019. PMID: 31022466 Free PMC article.
-
TBDBT: A TB DataBase Template for collection of harmonized TB clinical research data in REDCap, facilitating data standardisation for inter-study comparison and meta-analyses.PLoS One. 2021 Mar 26;16(3):e0249165. doi: 10.1371/journal.pone.0249165. eCollection 2021. PLoS One. 2021. PMID: 33770143 Free PMC article.
MeSH terms
LinkOut - more resources
Full Text Sources
Other Literature Sources