| Brooke Ellen Delgoffe |
In a previously published paper, you were introduced to REDCap © as a tool for SAS programmers (Delgoffe & Roush, 2022). Once you've established which of many use cases REDCap © can help you with (and have a functional database), you'll likely want to extract data from it. In this paper, we'll focus more on what data can be exported from REDCap using the API. At conclusion of this paper you should be able to utilize its knowledge to create successful, dynamic, SAS code. Leveraging the "cleaner than Excel" data to learn, innovate, and optimize is just around the corner!
A few macros will be presented to assist with exporting data from REDCap including: simple exports, reports, limited variable exports, metadata, and logging. Select REDCap concepts, such as the data structure, and best use cases will also be covered to assist the SAS programmer in creating efficient export code.
Brief Outline:
• Introduction
• The REDCap API and API Playground
• Understanding Data Structure Before the Export
• Reports for Simple Data Exports
• Limited Variable Exports
• Metadata Exports
• Logging Exports
• Preparing for and Executing an Upload |