https://communities.sas.com/t5/SAS-Programming/Help-to-Connect-SAS-to-Oracle-Database/m-p/363137#M85910 <P>I currently download data from the company database into excel, which&nbsp;I then upload into SAS. However to bypass the excel step I am looking to connect SAS straight to our Oracle Database. I have requested and granted oracle access with a username and passowrd. I know the schema and environment. Hoping someone has insight on how to write the code to pull in the desired data.</P><P>&nbsp;</P><P>Using SAS Enterprise Guide 5.1</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 31 May 2017 16:15:46 GMT Amber_Nicole94 2017-05-31T16:15:46Z https://communities.sas.com/t5/SAS-Programming/Help-to-Connect-SAS-to-Oracle-Database/m-p/363137#M85910 <P>I currently download data from the company database into excel, which&nbsp;I then upload into SAS. However to bypass the excel step I am looking to connect SAS straight to our Oracle Database. I have requested and granted oracle access with a username and passowrd. I know the schema and environment. Hoping someone has insight on how to write the code to pull in the desired data.</P><P>&nbsp;</P><P>Using SAS Enterprise Guide 5.1</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 31 May 2017 16:15:46 GMT https://communities.sas.com/t5/SAS-Programming/Help-to-Connect-SAS-to-Oracle-Database/m-p/363137#M85910 Amber_Nicole94 2017-05-31T16:15:46Z https://communities.sas.com/t5/SAS-Programming/Help-to-Connect-SAS-to-Oracle-Database/m-p/363142#M85913 You need a licence and install SAS/ACCESS to Oracle or ODBC. <BR />If you have that already follow the instruction in the corresponding documentation. Wed, 31 May 2017 16:21:06 GMT https://communities.sas.com/t5/SAS-Programming/Help-to-Connect-SAS-to-Oracle-Database/m-p/363142#M85913 LinusH 2017-05-31T16:21:06Z