topic Re: Need some info with Proc sql in extracting date time field in SAS Procedures

Need some info with Proc sql in extracting date time field

sasbasls — Mon, 02 Apr 2012 14:32:57 GMT

HI,

I was getting this note in the log :

The data value for column dat_time_field1 was truncated or was out of range 15 times when retrieving that

data from the DBMS.

This looks to me that date time was not appropriately pulled into SAS dataset. Here back end d/b is Oracle.

Please let me know if any conversion for field needed to pull exact value from d/b.

thanks!

Hima — Mon, 02 Apr 2012 16:04:07 GMT

jjwarr2 — Wed, 04 Jan 2017 01:16:09 GMT

This link does not work:

Can you please point me to the answer, either to where that KB article is now, or else where the answer is somewhere else?

SASKiwi — Wed, 04 Jan 2017 03:14:06 GMT

I think this is your problem:

You should try running queries in an Oracle tool to verify if there are any dates outside the SAS date range.