Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Steps to export data to SAS from REDCap:

  1. Click Data Exports, Reports and Stats under Applications on the left-hand side of the screen.

  2. Click Export Data for either “All data” or whichever report you would like to export

  3. Click on “SAS Statistical Software” and click “Export Data” in the bottom right of the pop-up window.

  4. After a brief wait, a window will pop up showing two icons on the right – one that will give a SAS program tailored to import the data and another that serves as the csv file to be imported.  Save both of these files.  Do NOT open the csv file or it could cause unwanted modifications to the data that will cause the import to fail.

  5. Open the created SAS program and edit the csv file macro variable at the top to contain the full filepath and filename of the csv file just saved from REDCap.

  6. Run the import file.  The file will produce a dataset called “redcap” containing the data from the csv file saved from REDCap.

Known issues with REDCap SAS dataset exporting:

...