How to expore Invalid Date Values

[Jim_Ogilvie]

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

[ballardw]

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.