Export and Download Data

Modified on Wed, 29 May 2024 at 09:15 AM

Who Can Export Data?

  • User Plans: All users, including those on unpaid plans, can access export their data.
  • Permissions: Users need to have the "export" permission enabled in their profiles to use this feature. Series creators can also access the feature.

How to Export Data

Step-by-Step Guide

  1. Navigate to the Export Interface: Through the EasyMedStat interface, go to the "Series" menu, select "Data Manager", and then choose "Export Data".
  2. Configure Export Settings: Choose between CSV or Excel formats depending on your needs and compatibility with other software. Customize your export by selecting from various data handling options like pseudonymization or specific data columns (see below for more information).
  3. Initiate Export: Once you have configured all the settings, click on the export button. A confirmation message will appear, and the data will be processed.
  4. Download Your File: After processing, the file will be available for download. You will also see an entry in the audit trail indicating that an export has been performed.

How to Export a File Compatible with R or Other Statistical Software?

The following options will ease the import of your data into an other statistical software:

  • Uncheck Identifying Data: Identifying data (Patient ID, Birth Date, Initials) are generally not required for statistical analysis. Uncheck this option to exclude them.
  • Display List and Yes-no Variables as Their Numeric Values: Check this option to export only numeric values when available. This ensures compatibility with statistical models requiring numeric input. You may want to learn how to 
  • Choose "Remove Special Characters": Select the option to remove special characters (spaces, accents). This format ensures all variable names are in lowercase, without spaces, special characters, or accents. For example, "Age at inclusion" becomes "age_at_inclusion".
  • Choose "Code Category Name and Add as a Prefix": Select this option or "Remove Special Characters" for category names. This keeps category names concise and avoids issues with special characters. For example, variable "Score ASA" in "Preoperative data" category becomes "preoperative_data.score_asa".
  • Select a Compatible Date Format: Choose a date format that aligns with the expected input format of your statistical software. "YYYY-MM-DD" is a common and recommended format for R.
  • Choose CSV Format: CSV format is generally the most compatible with R and other statistical software. Ensure the separator is set to semi (,) when importing.

Which Options Are Available?

Export a Subset of Patients

You can apply filters to export only specific parts of your patient dataset, such as particular patient groups or time periods. Only the data matching the active filters will be included in the export.

Export a Subset of Variables

Variable Selection: The export interface allows you to select specific variables or categories within your data series, enabling you to export just the necessary data and reduce the file size.

Export Customization Options

  • Pseudonymization: Enhance the privacy of your exported data by excluding any identifying data, such as patient initials or birth date. This is essential when sharing data with third parties who do not require patient identification.
  • Monitoring Features: Include detailed monitoring statuses like sign, verify, and lock statuses in your export to track data validation processes.
  • Variable Formats: Choose how to display variable names—either in full names or a simplified "shrunken" format. This is useful for ensuring compatibility with various statistical software packages.
  • Comments and Metadata: Optionally include additional columns for comments associated with each variable to provide further context in your data.
  • Date Formats: Specify the format for date variables to maintain consistency across your exported data.
  • Special Export Settings: Decide on exporting specific system-generated values like patient ID and monitoring details, and choose how list and yes/no variables are displayed (numeric vs. text).

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article