Hi @helpme88
In order to make connection from SAS to any database you will have to use a libname statement. For the connection to work, you will have to configure a related SAS/Access engine to that database. In your case you have SAS/Access to ODBC installed at your site so you will have to check if the related configuration is also made or not in order to connect to Oracle. If not, you will have to make those changes. Also, just to let you know SAS also has a native SAS/Access interface to Oracle engine.
For setup related to ODBC, you will need to have the ODBC driver manager and the Oracle driver for ODBC installed in your platform. I would suggest you to go through this documentation link to understand more on how it: Introduction to SAS/ACCESS Interface to ODBC
Here is a good SAS Communities article on How-to-configure-SAS-ACCESS-Interface-to-ODBC-on-UNIX-Platforms
Once you have the setup correctly configured you can use a libname statement to make connection to DB and work with data. Link to documentation here for libname statement here .
... View more