topic Re: exporting data from SAS to redcap in New SAS User

exporting data from SAS to redcap

hjjijkkl — Mon, 14 Dec 2020 21:34:24 GMT

Hello;

I am trying to export data/report from sas to redcap and I am getting this error below. I tried to change my date to yymmdd10. but, Am still having a problem on understanding what the issues is.

proc print data=stemp Noobs;
format start yymmdd10.;
run;

"error":"\"2-2c\",\"start\",\"11\/01\/2010 \",\"Invalid date format. (NOTE: Dates must be imported here only in Y-M-D H:M[:S] format, regardless of the specific date format designated for this field.) \"\n\"2-2j\",\"start\",\"10\/01\/2010 \",\"Invalid date format. (NOTE: Dates must be imported here only in Y-M-D H:M[:S] format, regardless of the specific date format designated for this field.)

Re: exporting data from SAS to redcap

Tom — Mon, 14 Dec 2020 21:43:14 GMT

That does not look like an error from SAS. Not sure what REDCAP is but the error seems to be saying that you need to give it datetime strings in YMD HMS order, even if your values do not have any time component. People normally just use zeros for the time of day parts in that case.

You are just showing a PROC PRINT statement. That will just write the data to a text file (or if you are using ODS some other file type like EXCEL, RTF, etc). What format does Redcap want the data?

SAS stores dates as the number of days since 1960 and datetime values as the number of seconds since 1960. Your SAS code is assuming you have SAS date values so that the YYMMDD format can by used with it. If your actual SAS variable has datetime values then you will not want to use the YYMMDD format as they value will be way too large. There are 24*60*60 seconds in a day.

Re: exporting data from SAS to redcap

hjjijkkl — Mon, 14 Dec 2020 21:54:06 GMT

from the error it seems that redcap wants the data in Y-M-D H:M[:S] format.
My data is in mmddyy8. format. And I tried to change it to YYMMDD format to export it to redcap. My data only has date no time.

Re: exporting data from SAS to redcap

hjjijkkl — Mon, 14 Dec 2020 22:24:30 GMT

what is the Language Element for YMD HMS order

Re: exporting data from SAS to redcap

andreas_lds — Tue, 15 Dec 2020 07:51:59 GMT

I don't know if a format exits that appends fake-time information to a date. Most likely you will have to convert the date into a sas datetime before exporting it. You could use the function dhms.