topic Using API Playground in REDCap to import data into SAS in SAS Programming

Using API Playground in REDCap to import data into SAS

mitrakos — Fri, 11 Mar 2022 18:55:08 GMT

Hi Everyone,

I'm currently using SAS Studio 9.4 and am part of a REDCap project with an API Playground. I'd like to use the cURL code provided by REDCap to execute the API in SAS and am wondering how I can do this so that I may analyze the data within the program. How can I go about doing this?

Thank you!

Re: Using API Playground in REDCap to import data into SAS

ChrisHemedinger — Fri, 11 Mar 2022 19:07:39 GMT

Most cURL code is easily transcribed to PROC HTTP in SAS. Others on the SAS community have used REDCap successfully - here's an example from another thread.

Re: Using API Playground in REDCap to import data into SAS

Delgoffe_MCRI — Tue, 08 Nov 2022 18:31:24 GMT

I have recently published a macro to export REDCap data into SAS along with formats and a data dictionary. Please see my paper, presentation, and code by filling out this survey: https://redcap.link/REDCapIsMySASFriend.

Distribution using this method allows me to distribute only the most recent version, so you can check back to this survey in the future as well.

Also available in LexJansen under SESUG 2022: "REDCap: Your SAS Friend for EHR Manual Abstraction"