04-24-2017 03:34 AM
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.
04-24-2017 08:52 AM
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.