Help using Base SAS procedures

Need some info with Proc sql in extracting date time field

Reply
Contributor
Posts: 40

Need some info with Proc sql in extracting date time field

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!

Regular Contributor
Posts: 233

Need some info with Proc sql in extracting date time field

New Contributor
Posts: 2

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

This link does not work:

http://support.sas.com/kb/12/944.html

 

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

Super User
Posts: 3,102

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

I think this is your problem:

 

http://support.sas.com/techsup/notes/v8/2/429.html

 

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

Ask a Question
Discussion stats
  • 3 replies
  • 715 views
  • 0 likes
  • 4 in conversation