SAS Products

About SAS/ACCESS

SAS/ACCESS interfaces provide data access to more of your data sources so you can make better decisions faster. They are out-of-the-box solutions that provide enterprise data access and integration between SAS and third-party databases. SAS/ACCESS interfaces enable your SAS® solutions to read, write and update data regardless of its native database or platform. Because the data appears native to SAS, there is no need to learn Structured Query Language (SQL) or any other database-specific query languages. By integrating all available data across the enterprise, SAS/ACCESS software supports your mission-critical business decisions by giving you access to complete, up-to-date and accurate enterprise data.

See SAS/ACCESS Software for a complete list of the SAS/ACCESS family of interface products.

Access to Data Sources to Relational Databases, Data Warehouse Appliances, and Distributed Systems

• SAS/ACCESS Interface to Aster
• SAS/ACCESS Interface to DB2
• SAS/ACCESS Interface to Greenplum
• SAS/ACCESS interface to Hadoop
• SAS/ACCESS Interface to HP Neoview
• SAS/ACCESS Interface to Informix
• SAS/ACCESS Interface to Microsoft SQL Server
• SAS/ACCESS Interface to MySQL
• SAS/ACCESS Interface to Netezza
• SAS/ACCESS Interface to ODBC (including ParAccel, Vertica, Microsoft Parallel Data Warehouse and more)
• SAS/ACCESS Interface to OLE DB
• SAS/ACCESS Interface to Oracle (including Sun Oracle Database Machine [Exadata])
• SAS/ACCESS Interface to Sybase
• SAS/ACCESS Interface to Sybase IQ
• SAS/ACCESS Interface to Teradata

Access to Nonrelational Databases and Other Data Sources

• SAS/ACCESS Interface to ADABAS
• SAS/ACCESS Interface to CA-DATACOM/DB
• SAS/ACCESS DATA Step Interface to CA-IDMS
• SAS/ACCESS Interface to IMS
• SAS/ACCESS Interface to PC Files
• SAS/ACCESS Interface to SYSTEM 2000

See SAS/ACCESS Validation Matrix for more information.

The most current release is SAS/ACCESS 9.3.

---

News

New features and Enhancements for SAS/ACCESS 9.3 Interface to Relational Databases

In the August 2012 release, SAS/ACCESS 9.3 Interface to Relational Databases has these new features and enhancements:

• Many new LIBNAME and data set options for various interfaces, including Oracle and Teradata.
• A new default port number for the Aster interface.
• Inclusion of Aster and Greenplum in the default value for SQLGENERATION= LIBNAME and system options.
• Information in the SAS Interface to Hadoop: Reference has moved to these documents:
  • SAS/ACCESS 9.3 for Relational Databases: Reference includes SAS/ACCESS Interface to Hadoop, including several new and enhanced features for this release.
  • Base SAS 9.3 Procedures Guide, Second Edition includes PROC HADOOP.
  • SAS 9.3 Statements: Reference includes the file access method (FILENAME Statement).

---

What's New in SAS/ACCESS 9.3 Interface to PC Files

General enhancements found in this release include the following.

• SAS/ACCESS 9.3 Interface to PC Files supports the LIBNAME ACCESS and LIBNAME EXCEL engines for 32-bit and 64-bit Microsoft Windows operating environments, as well as the LIBNAME PCFILES engine for 32-bit and 64-bit Windows and for Linux and UNIX operating environments.
• Beginning with SAS/ACCESS 9.3 Interface to PC Files, the PC Files Server can be operated as a Windows service or as a Windows application in 32-bit and now 64-bit Windows operating environments. The server can now take advantage of the associated 64-bit features and to operate more efficiently.
• In SAS/ACCESS 9.2 Interface to PC Files:
  • The Import and Export procedures and wizard were updated to include support for JMP files as part of Base SAS. Thus a SAS/ACCESS Interface to PC Files license is no longer required to access JMP files with these procedures and wizard.
  • Support for the FMTLIB= option is available for JMP, SPSS, and Stata files.
  • The default port number used for TCP/IP server connections has changed from 8621 to 9621. LIBNAME and the Import and Export procedure commands default to PORT=9621 if the PORT option is omitted.

---

Visit our general product information page on www.sas.com for more information.

 Online Documentation         Purchase from Bookstore          Technical Papers

Free Online Documentation

Training

---

Need help?

Curriculum consultants are available in the U.S. from 9-5 EST. Contact us at 1-800-333-7660 or e-mail.

International customers, please contact your country office.

Online Support Resources

This page contains online support resources that are specific to this product. Visit the Support page to access various self-help and assisted-help resources or submit a problem through the SAS Technical Support form.

---

 Downloads         Highlighted Samples         Notes        

Downloads

Hot Fixes by Release

• Interface to DB2 9.3_M1
• Interface to Greenplum 9.3
• Interface to Netezza 9.3
• Interface to Oracle 9.31_M1
• Interface to Oracle 9.3_M1
• Interface to PC Files 9.3_M1
• Interface to Teradata 9.31_M2
• Interface to Teradata 9.31_M1
• Interface to Teradata 9.31
• 9.2 Interfaces

---

Highlighted Samples

Usage Notes

• A listing of ACCESS .dlls that will help you verify the installation of SAS/ACCESS products
• System requirements for SAS/ACCESS 9.3 Interface to Greenplum in UNIX environments
• System Requirements for SAS/ACCESS 9.3 Interface to Greenplum in Windows environments

Problem Notes

• A UTY4015 access-module error occurs when you use the Teradata MultiLoad utility with SAS/ACCESS Interface to Teradata
• LOGDB is not a supported option when using the Teradata Parallel Transporter (TPT) with SAS/ACCESS Interface to Teradata
• You cannot add a spreadsheet to an existing Microsoft Excel workbook when using SAS/ACCESS Interface to PC Files 9.3 with the XLSX engine

Notes

Samples SAS/ACCESS Interface to DB2 SAS/ACCESS Interface to Microsoft SQL Server SAS/ACCESS Interface to ODBC SAS/ACCESS Interface to OLE DB SAS/ACCESS Interface to Oracle SAS/ACCESS Interface to PC Files

Usage Notes SAS/ACCESS Interface to Adabas SAS/ACCESS Interface to Aster SAS/ACCESS Interface to CA-Datacom/DB SAS/ACCESS Interface to CA-IDMS SAS/ACCESS Interface to CA-OpenIngres SAS/ACCESS Interface to DB2 SAS/ACCESS Interface to DB2 Server for VM SAS/ACCESS Interface to Greenplum SAS/ACCESS Interface to Hadoop SAS/ACCESS Interface to HP Neoview SAS/ACCESS Interface to IMS-DL/I SAS/ACCESS Interface to Informix SAS/ACCESS Interface to Microsoft SQL Server SAS/ACCESS Interface to MySQL SAS/ACCESS Interface to Netezza SAS/ACCESS Interface to ODBC SAS/ACCESS Interface to OLE DB SAS/ACCESS Interface to Oracle SAS/ACCESS Interface to Oracle Rdb SAS/ACCESS Interface to PC Files SAS/ACCESS Interface to PeopleSoft SAS/ACCESS Interface to R/3 SAS/ACCESS Interface to SAP SAS/ACCESS Interface to Sybase SAS/ACCESS Interface to Sybase IQ SAS/ACCESS Interface to System 2000 SAS/ACCESS Interface to Teradata

Problem Notes SAS/ACCESS Interface to Adabas SAS/ACCESS Interface to Aster SAS/ACCESS Interface to CA-Datacom/DB SAS/ACCESS Interface to CA-IDMS SAS/ACCESS Interface to CA-OpenIngres SAS/ACCESS Interface to DB2 SAS/ACCESS Interface to DB2 Server for VM SAS/ACCESS Interface to Greenplum SAS/ACCESS Interface to Hadoop SAS/ACCESS Interface to HP Neoview SAS/ACCESS Interface to IMS-DL/I SAS/ACCESS Interface to Informix SAS/ACCESS Interface to Microsoft SQL Server SAS/ACCESS Interface to MySQL SAS/ACCESS Interface to Netezza SAS/ACCESS Interface to ODBC SAS/ACCESS Interface to OLE DB SAS/ACCESS Interface to Oracle SAS/ACCESS Interface to Oracle Rdb SAS/ACCESS Interface to PC Files SAS/ACCESS Interface to PeopleSoft SAS/ACCESS Interface to R/3 SAS/ACCESS Interface to SAP SAS/ACCESS Interface to Sybase SAS/ACCESS Interface to Sybase IQ SAS/ACCESS Interface to System 2000 SAS/ACCESS Interface to Teradata

 

SAS Enterprise Data Management and Integration Forum Share your experiences, questions and ideas with other SAS Data Integration Studio, SAS/ACCESS, and DataFlux users. Enter the forum.