DI Studio: Error while reading data from oracle library

[Bipasha]

Hello.

I am recently working with SAS DI studio. In it, I am loading data from oracle library to SAS library as SAS dataset. While I am reading data of oracle lib by registering table in DI I am facing a logical error with the Date formatted data.

In Oracle library, if I have a date as 1-jan-00 (which actually means 1-jan-2000) DI reads it as 1-jan-1800. I did not use any extract yet. Just registered the table and open it using DI.

Please suggest me a way to solve this issue.

[thomp7050]

Low tech: Export to a text delimited file, and attempt to import the data into SAS manually.  If it will not convert your dates automatically then re-create the dates in SAS' format.  Use the information from the import script created by SAS (displayed in the log) to modify your automated procedures.