www.sas.com > SAS UK > In the Know Homepage Search | Contact Us    
SAS UK Newsletter Banner SAS - The power to know(tm)  

How can I use ODBC to access SAS Datasets and SAS Views on a Unix or Mainframe Operating System?

On a Windows based system, we provide an ODBC driver to access SAS datasets and SAS views from ODBC compliant applications. However there is not a SAS ODBC driver available for Unix or the Mainframe operating systems. To access SAS datasets or SAS views on these platforms using ODBC, you will need to configure a SAS/Share Server on the Unix or Mainframe operating systems and reference the Share server within a SAS ODBC driver on the Windows platform.

What are the minimum requirements to access Unix and Mainframe SAS datasets or SAS views using ODBC?

To access SAS datasets or SAS views on the Unix or Mainframe platforms using SAS/Share and ODBC, from a PC, you will need the following modules and system properties:-

On the remote Unix or Mainframe platform:

a) Base SAS Software
b) SAS/SHARE including SAS/SHARE*NET Software
c) Active SAS/SHARE server listening on a specific TCP port as registered in the /etc/services file.
d) TCP/IP network connection to PC

On the local PC client platform:

a) SAS ODBC driver
For instructions on how to set up the SAS 8 or SAS 9 ODBC driver download the technical document TS-626 : http://ftp.sas.com/techsup/download/technote/ts626.html
b) TCP/IP network connection to the Unix platform.
c) Register the SAS/Share server name & TCP/IP port number on the client machine within \system32\drivers\etc\services file.
(Service name and port number should match the Unix servers entry.)
d) ODBC compliant software to access the datasets.

Access SAS data on Unix and Mainframe platforms with ODBC

SAS ODBC Driver

For further information, please visit: www.sas.com/apps/demosdownloads/setupcat.jsp?cat=ODBC+Drivers

The above notes apply to Mainframe SAS 6.09E and above, Unix SAS 6.12 and above.

Back