SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DI Studio: Error while reading data from oracle library

Reply
Occasional Contributor
Posts: 13

DI Studio: Error while reading data from oracle library

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.

Frequent Contributor
Posts: 93

Re: DI Studio: Error while reading data from oracle library

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.

Ask a Question
Discussion stats
  • 1 reply
  • 143 views
  • 0 likes
  • 2 in conversation