topic Re: Missing date column load data from Oracle to SAS in SAS Programming

Missing date column load data from Oracle to SAS

gyambqt — Mon, 02 Oct 2023 08:46:40 GMT

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 — Mon, 02 Oct 2023 09:06:18 GMT

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

LinusH — Mon, 02 Oct 2023 10:03:19 GMT

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 — Mon, 02 Oct 2023 15:16:27 GMT

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

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