How to expore Invalid Date Values

Jim_Ogilvie — Thu, 11 Mar 2021 12:20:26 GMT

Hello,

I am running some ETL routines against an Oracle database via SAS ACCESS ODBC, using PROC SQL.

There is a datetime field in the source table that contains some invalid values (8 of then according to the log) and I would like to view these in order to provide feedback to the users and get them fixed.

Code:

proc sql;  
   create table test2 as
   select myDateField as dates 
   from myTableView
   order by dates;
quit;

I see the following log note:

The data value for column DATES (DATES) was truncated or was out of range 8 times when

retrieving that data from the DBMS.

I have tried using the "Put" function, but this also gives an error.

Thansk in advance

Jim

Re: How to expore Invalid Date Values

ballardw — Thu, 11 Mar 2021 12:37:04 GMT

You will likely have to use a different way to look at that variable as I am pretty sure the resulting SAS data set would have those values missing.

I would select information that identifies the record other than the date, then use a pass through query to create a report from the Oracle data base that should allow you to "see" the resulting date field.

topic Re: How to expore Invalid Date Values in SAS Programming

How to expore Invalid Date Values

Re: How to expore Invalid Date Values