topic Re: Difficulties with REDCap data in SAS in SAS Data Management

Difficulties with REDCap data in SAS

EpiNovice — Fri, 12 Apr 2019 19:43:57 GMT

Has anyone who uses REDCap had an issue with inputting data using the code provided by REDCap? Specifically with dates not loading properly.

If I use the Path Mapper file provided, everything seems to load fine. My issue is that I don't have that for every data set, I just have the CSV file and if I try to load it with the SAS code provided it says I have "invalid data" for every single date variable.

Is there any way to fix this?

Re: Difficulties with REDCap data in SAS

Reeza — Fri, 12 Apr 2019 20:53:02 GMT

How are you loading the data, are you using SAS DI? You've posted in data management which is typically Data Integration Studio questions. Or are you using SAS EG or Base SAS

Re: Difficulties with REDCap data in SAS

ballardw — Fri, 12 Apr 2019 22:39:04 GMT

@EpiNovice wrote:

Has anyone who uses REDCap had an issue with inputting data using the code provided by REDCap? Specifically with dates not loading properly.

If I use the Path Mapper file provided, everything seems to load fine. My issue is that I don't have that for every data set, I just have the CSV file and if I try to load it with the SAS code provided it says I have "invalid data" for every single date variable.

Is there any way to fix this?

You might post the LOG of running the "SAS code provided". Copy from the log the submitted code, invalid data messages and any other messages or errors. Post the log results into a code box opened using the forum's {I} or "running man" icon to preserve formatting (the invalid message usually includes a ruler indicator that gets messed up with the main message windows).

The symptom of invalid dates is almost certain an INFORMAT issue but we would need to see the code and the data to determine what needs to be addressed.

Re: Difficulties with REDCap data in SAS

pmatheson0 — Fri, 22 Oct 2021 14:28:03 GMT

Yes,

The SAS code provided by REDcap has dates reads in as $500. In other words actually useless for calculations.

I had to change 3 things in the SAS code provided by REDcap to get it to read in a date properly.

1. Comment out the informat statement provided:

* informat ediary_morning_entry_timestamp $500. ;

2. Create a new informat

informat timestamp e8601dt19.;

3. Comment out the format statement provided.

*format timestamp $500. ;

Have fun!

Re: Difficulties with REDCap data in SAS

Delgoffe_MCRI — Tue, 08 Nov 2022 18:33:44 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 on LexJansen under SESUG 2022: "REDCap: Your SAS Friend for EHR Manual Abstraction"