topic DI Studio: Error while reading data from oracle library in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/DI-Studio-Error-while-reading-data-from-oracle-library/m-p/352740#M10509 <P>Hello.</P><P>I am recently working with SAS DI studio. In it, I am loading&nbsp;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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Please suggest me a way to solve this issue.</P> Mon, 24 Apr 2017 07:34:45 GMT Bipasha 2017-04-24T07:34:45Z DI Studio: Error while reading data from oracle library https://communities.sas.com/t5/SAS-Data-Management/DI-Studio-Error-while-reading-data-from-oracle-library/m-p/352740#M10509 <P>Hello.</P><P>I am recently working with SAS DI studio. In it, I am loading&nbsp;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.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>Please suggest me a way to solve this issue.</P> Mon, 24 Apr 2017 07:34:45 GMT https://communities.sas.com/t5/SAS-Data-Management/DI-Studio-Error-while-reading-data-from-oracle-library/m-p/352740#M10509 Bipasha 2017-04-24T07:34:45Z Re: DI Studio: Error while reading data from oracle library https://communities.sas.com/t5/SAS-Data-Management/DI-Studio-Error-while-reading-data-from-oracle-library/m-p/352824#M10513 <P>Low tech: Export to a text delimited file, and attempt to import the data into SAS manually. &nbsp;If it will not convert your dates automatically then re-create the dates in SAS' format. &nbsp;Use the information from the import script created by SAS (displayed in the log) to modify your automated procedures.</P> Mon, 24 Apr 2017 12:52:27 GMT https://communities.sas.com/t5/SAS-Data-Management/DI-Studio-Error-while-reading-data-from-oracle-library/m-p/352824#M10513 thomp7050 2017-04-24T12:52:27Z