Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

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

April 26, 2017datasets mainframe minimum ODBC requirements SAS Unix

0

Posted

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

1 Answer

0

Posted

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