Help using Base SAS procedures

proc export using accesscs: datetime field overflow error

Accepted Solution Solved
Reply
Regular Contributor
Posts: 196
Accepted Solution

proc export using accesscs: datetime field overflow error

Hi,

Does anyone know how I can fix this error when running the proc export seen below?

ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver]Datetime field overflow

WARNING: File deletion failed for _IMEX_.CR_ACT.DATA.

NOTE: PROCEDURE EXPORT used (Total process time):

      real time           16.22 seconds

      cpu time            0.11 seconds   

ERROR: Export unsuccessful.  See SAS Log for details.

proc export data=claims

outtable="CR_ACT"

dbms = ACCESSCS

label

replace ;

database="C:\temp\EnvClear.mdb";

server="&DEVICEID";

port=&portid;

run;


Accepted Solutions
Solution
‎04-29-2015 08:02 PM
Regular Contributor
Posts: 196

Re: proc export using accesscs: datetime field overflow error

I found that _BIC_CST was equal to 01APR1715.

I fixed that record and proc export ran successfully.

View solution in original post


All Replies
Solution
‎04-29-2015 08:02 PM
Regular Contributor
Posts: 196

Re: proc export using accesscs: datetime field overflow error

I found that _BIC_CST was equal to 01APR1715.

I fixed that record and proc export ran successfully.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 259 views
  • 0 likes
  • 1 in conversation