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

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.

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).

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.).

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

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

Instructions are incorporated 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.

YES3 modules are supported through software development grants and individual research grants.  

• For Yale/YNHH users, YES3 modules may require fees for local support and implementation. 
• For the global community, YES3 modules are made available at no cost for implementation through the Vanderbilt Consortium. 
  • Administrators should familiarize themselves with the software to provide local support

This work was funded by the NIH through: 

• Office of Data Science Strategy (ODSS) - (2021)  
• National Institute on Aging (NIA) 

EM documentation contains the funding source and grant number.  If you used YES3 software to support your research, we greatly appreciate an acknowledgement of the software, funding source, and grant number so we can continue this important work.  

Yale/YNHH Users: 

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

    Available:

• Yale REDCap I 
• Yale REDCap II 
• YNHH Standard 

     Not available:

•   YNHH 21 CFR Part 11

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.

Once released publicly, YES3 modules are available for download in the Vanderbilt External Module (EM) Repository.  You can search the Vanderbilt EM repository.  Search for the “YES3” identifier.