DATA Step, Macro, Functions and more

Help to Connect SAS to Oracle Database

Reply
Contributor
Posts: 25

Help to Connect SAS to Oracle Database

I currently download data from the company database into excel, which 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.

 

Using SAS Enterprise Guide 5.1

 

 

Super User
Posts: 5,431

Re: Help to Connect SAS to Oracle Database

Posted in reply to Amber_Nicole94
You need a licence and install SAS/ACCESS to Oracle or ODBC.
If you have that already follow the instruction in the corresponding documentation.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 80 views
  • 0 likes
  • 2 in conversation