Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • EDC/CDMS
  • Castor EDC Manual
  • Export and import data

How to export data in EDC/CDMS

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • EDC/CDMS
    Castor EDC Manual Castor EDC Calculations Manual Frequently Asked Questions Articles for Data Managers Castor EDC Compliance Release Documents
  • eConsent
    Castor eConsent Manual Castor eConsent Compliance Release Documents
  • SMS
    Castor SMS Manual Castor SMS Compliance Release Documents
  • Castor Connect
    Castor Connect Compliance Release Documents
  • Helpdesk
    News Other Resources
  • Status page
+ More

Table of Contents

How to export data Next steps: What are the exported files?

Data can be exported in SPSS, Excel, and CSV formats, which in turn can be easily imported into Stata or R.

 

Data can also be exported in SAS and CDISC ODM formats. These features are currently available upon customer request without any additional fee. To enable it please contact Castor support at support@castoredc.com and provide the study id (found in the Settings tab) where you would like to have this functionality enabled.

 

Please note that multiple variable names beginning with the same 64 characters will not be able to be exported due to duplicate participants. 

 

Apart from the study data, the export file will contain list of all the variables created in the study and list of all the option groups with the option group names and values. You can read this article to learn more which files will be exported: Export data formats

 

When you choose Variable bulk list (paste), then you can enter a list of variable names separated by semicolon. After the last variable, there should not be a semicolon. For example:

pat_dob;ic_date;visit_date

How to export data

  1. Navigate to the 'Participants' tab and click the 'Actions' icon. 
  2. Choose 'Export all' to export all participant data. If you are exporting only data from selected or filtered participants, first select or filter the participants you wish to export and then click the 'Actions' icon, then choose 'Export all filtered' or 'Export selected' from the list:

Please note: Selecting 'Export all' will only export the participants from the site(s) for which you have Export rights.

In the Export options dialog window you can adjust export settings:

  1. Select the file format you want to export your data in. You can choose between CSV, Excel, SPSS and SAS (SAS XPT or SAS 7BDAT) or CDISC-ODM formats. You also have the option to download all uploaded files in the 'Upload file field' in your study by selecting 'Uploaded files (to zip-file)'.In case you select CSV or Excel as export type, pick the way options are displayed in the export. Numbers will export the option values, while Names will export the options labels.
  2. Select between exporting the certain parts of the study, variable list or specific variables (only CSV and Excel formats). 
  3. Choose whether you want to export all comments. These will be exported to a separate sheet in Excel, or in a separate CSV file. The export for comments contains the following information: current value of the field, which type of form the field is located on (study/repeating data) and the repeating data name if applicable. Choose whether you want to export all queries. These will be exported to a separate sheet in Excel, or in a separate CSV file. Choose whether you want to export data verifications. These will be exported to a separate sheet in Excel, or in a separate CSV file.

In CSV and Excel formats it is possible to decide which part of the study you want to export. By default, the export will contain all the data from your study, repeating datas and surveys. This is shown in the Entire study export structure immediately being selected in the tree-view. 

  1. In this interactive tree-view you can select smaller subsets (on the form-level). Using this tree-view you can export only a subset of your data, for example only study, repeating datas, surveys or forms of your study, any repeating data or any particular survey. 
  2. Click Export to export your data.

Next steps: What are the exported files? 

The export includes multiple data sets. In an Excel export, these datasets are in different Excel sheets. In CSV and SPSS exports, the data sets are in separate files. 

  • Study data in one file called 'STUDYNAME_export_DATE.csv' or 'STUDYNAME_date.dat'
  • Repeating Data data in separate files. Every repeating data has its own Excel sheet or file. For example, SAE repeating datas and blood pressure repeating datas will be in 2 sheets or files, which are called 'STUDYNAME_SAE_date' and 'STUDYNAME_blood_pressure_date', respectively. See here how you can merge study and repeating data data in SPSS.
  • Survey data in separate files. Like repeating datas, every survey has its own file.
  • Variable lists of study forms, repeating datas, and surveys - a list of all fields.
  • Comments, incl. the current field value
  • Queries

Your export will be saved as a zip-file, containing either:

  1. An Excel file with separate sheets for the study data, each repeating data, each survey, a list of variables and option groups. Examples of a study export and repeating data export are shown below:
  2. A set of separate CSV files, one for study data and one for each repeating data and survey, a list of variables and option groups, example below:
  3. A set of paired .dat and .sps files to import into SPSS, including a PDF instructions file, example below:

Read more about how the data is exported in the article: Export data formats in EDC/CDMS

Importing data into SPSS

To import your data into SPSS please follow this link: How do I import Castor data in SPSS?

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Export and merge data in R in EDC/CDMS
  • Import repeating data in EDC/CDMS
  • CDISC export and import limitations in EDC/CDMS
  • Merge study and repeating data/survey data files in SPSS in EDC/CDMS
ISO 27001
FDA - 21 CFR part 11
ICH GCP compliant
HIPAA compliant
CDISC
ISO 9001
gdpr compliant

Products & Industries

  • Electronic Data Capture (EDC)
  • ePRO
  • eConsent
  • Decentralized Clinical Trials (DCT)
  • Clinical Data Management
  • Medical Device & Diagnostics
  • Biotech & Pharma
  • CROs
  • Academic Research

Resources

  • Thought Leadership
  • Blog
  • Castor Academy
  • Knowledge Base

 

Company

  • About Us
  • Careers
  • News
  • Contact Support
  • Contact Us

Legal & Compliance

  • Terms of Use
  • Privacy & Cookie Statement
  • Responsible Disclosure Policy
  • Good Clinical Practice (GCP)
  • ISO Compliance Certificates
  • GDPR & HIPAA Compliance
  • Security Statement

© 2022, Castor. All Rights Reserved.

Follow us on social media

Definition by Author

0
0
Expand