YES3 Exporter II extends REDCap’s native reporting and data export capabilities, providing advanced functionality tailored for statisticians and data managers managing datamarts, particularly SAS datamarts (with R support in development).

Key Features

1. Horizontal Data Layouts

Generates “horizontal” exports that create one column per event–field combination, producing datasheets that support longitudinal analysis and import into statistical environments.

2. User-Friendly Interface

Instructions are incorporated directly into the User Interface (UI) and include:

• Dynamic tooltips on every interactive element (buttons, text boxes, etc.).
• Movable and resizable pop-up help windows with detailed explanations for specific functions.
• Linked technical documentation with searchable, topic-specific content.
• Integration of online usage and reference materials 

3. Organizational Flexibility

Exports can be organized by form, event, or both, supporting a structured, hierarchical view of project data that aligns with REDCap’s metadata structure.

4. Flexible Export and Conditioning Options

Full control over how data are rendered and protected:

• Choose comma-delimited (CSV) or tab-delimited (TSV) formats.
• Exclude PHI, free text, and/or date fields to align with REDCap’s de-identification options.
• Apply REDCap-compatible date shifting and record hashing (validated through REDCap v15.5).
• Convert data to pure ASCII and optionally drop unprintable UTF-8 characters (newlines and tabs are converted to spaces).

5. Export-Specific Data Dictionaries

Each export produces an Excel-friendly CSV data dictionary that includes detailed data distribution summaries for every exported column. 

Depending on field type, summaries include:

• Univariate statistics: n, mean, min, max, sample SD, sum, and sum of squares.
• Date/time summaries: formatted mean, min, and max values.
• Frequencies (JSON structure): categorical value distributions.
• Maximum observed string lengths for text fields to support optimal dataset storage configuration (SAS, R, SPSS, etc.).

6. Versioning and Auditing

Rigorous audit trails on export activity, ensuring traceability and reproducibility:

• Complete export audit logs with optional daily email summaries.
• Version rollback- restore any export specification to a previous version.

7. Automated SAS Code Generation

Optionally generates execution-ready SAS code for dataset creation and format library setup. Code is tailored to the export specification, with:

• Character variable lengths tuned to observed maximums (to minimize storage).
• Input programs designed to abort on error (no overwrite of existing datasets).
• Format libraries shared across variables and generated only as needed.

How do I get it?

Yale/YNHH Users: 

Contact us to learn more about accessing and using the YES3 External Modules.

Availability:

The YES3 Exporter II External Module is available in:

• Yale REDCap I 
• Yale REDCap II 
• YNHH Standard 

It is not available on the YNHH 21 CFR Part 11 REDCap.

External Users:

Please do not send us a request to set up a REDCap account to use YES3.  Our system is only available to Yale/YNHH affiliates.

YES3 modules are released to the Vanderbilt External Module (EM) Repository.  You can search the Vanderbilt EM repository.  Modules from the study support suite start with the “YES3” identifier.

Original YES3 Exporter

Exporter II is the successor to the original YES3 Exporter (released Aug 2022) and may operate alongside it. While both modules can remain active, the original Exporter is being retired from active development and support. Future updates and enhancements will apply exclusively to Exporter II, and users are encouraged to migrate as workflows allow.