BookmarkSubscribeRSS Feed

Using SAS/ACCESS Interface to ODBC on UNIX Platforms

Started ‎03-09-2016 by
Modified ‎03-14-2016 by
Views 7,976

SAS Technical Support and Publications will post a series of articles about using SAS/ACCESS Interface to ODBC on UNIX platforms. From these, you can learn about specific platforms and how they interact with various ODBC drivers and driver managers. 


About This Series

No matter what specific interfaces or platforms you want to work with, start with the overview article, followed by a platform-specific build article.  You can then continue with other articles based on what you want to accomplish. Here's a list of articles:



How to configure SAS/ACCESS Interface to ODBC on UNIX Platforms


Build the Latest unixODBC Driver Manager

How to build the latest unixODBC Driver Manager for Linux

How to build the latest unixODBC Driver Manager for AIX

How to build the latest unixODBC driver manager for Solaris


Drivers and Driver Managers

Where to find sources for ODBC drivers for Oracle on UNIX


Configure Various Interfaces

How to configure SAS/ACCESS Interface to ODBC on Linux with an ODBC driver from Oracle

How to configure SAS/ACCESS Interface to ODBC on Linux with a Sybase IQ ODBC driver from Sybase


Nice series, but can you get all of the hyperlinks working?




OK. I think the best thing about this article is gathering all of the setup information in one place.

Great point 

Hi there,


we find this advice:

  • A Linux startup script is used to set the needed Oracle and ODBC environment variables. Normally, the best place to set these in the SASENV_LOCAL file in the !SASROOT/bin directory because it ensures that they are set for whoever starts SAS, no matter how it is started.

perhaps the SASENV_LOCAL could not be considered as the best place: now we have the Lev1... directory tree with all the files to be used to tune the SAS platform, doing so we are sure that all the specific tuning and parameters is done in this directory tree and not on files spreaded across Lev1 and sashome.

for example Lev1/ could be a best place ?

Your point is well taken, PascalMaurice& you can certainly do that.  One assumption we made for these articles was to be sure that all SAS/ACCESS products working with ODBC on UNIX platforms can be used in the same SAS session.

Version history
Last update:
‎03-14-2016 04:10 PM
Updated by:


Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.


Register now!

Free course: Data Literacy Essentials

Data Literacy is for all, even absolute beginners. Jump on board with this free e-learning  and boost your career prospects.

Get Started

Article Labels
Article Tags