BookmarkSubscribeRSS Feed
gyambqt
Obsidian | Level 7

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?

 

3 REPLIES 3
gyambqt
Obsidian | Level 7
The date from Oracle can be read into SAS properly for value like:
31/DEC/9999 11:59:59.000000000 PM
LinusH
Tourmaline | Level 20

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;
Data never sleeps
ballardw
Super User

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

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

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 685 views
  • 0 likes
  • 3 in conversation