Missing date column load data from Oracle to SAS

[gyambqt]

I have an Oracle table called Oracle_table.

In this Oracle table I have only one column and one row

Column name: Datetime_1

Value: 31/DEC/2801 11:59:59.000000000 PM

I load the data from Oracle into SAS using data steps

Data T;

set Schema.Oracle_table;   /* assume implicit pass through*/

run;

Proc print data=T;

run;

I got a . (dot) for the column Datetime_1 in SAS

Why?

[gyambqt]

The date from Oracle can be read into SAS properly for value like:
31/DEC/9999 11:59:59.000000000 PM

[LinusH]

What datatype has the Oracle column?

What does it look like if you are opening the table from SAS (not using a data step), or do a proc print directly towards it?

Try executing the query using these options it might give some more hints:

options sastrace=',,,d' sastraceloc=saslog nostsuffx msglevel=i;

[ballardw]

What format did SAS assign to the variable when that data set was created?

Show us the result of running Proc Contents data=t;