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 no matter what native databases or platforms you use. 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 your enterprise, SAS/ACCESS software supports your mission-critical business decisions by giving you access to complete, up-to-date, and accurate enterprise data.
Access to Data in Relational Databases, Data Warehouse Appliances, and Distributed Systems
- SAS/ACCESS Interface to Amazon Redshift
- SAS/ACCESS Interface to Aster
- SAS/ACCESS Interface to DB2
- SAS/ACCESS Interface to Greenplum
- SAS/ACCESS Interface to Hadoop
- SAS/ACCESS Interface to HAWQ
- SAS/ACCESS Interface to Impala
- 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 PostgreSQL
- SAS/ACCESS Interface to SAP ASE (formerly Sybase)
- SAS/ACCESS Interface to SAP HANA
- SAS/ACCESS Interface to SAP IQ (formerly Sybase IQ)
- SAS/ACCESS Interface to Teradata
- SAS/ACCESS Interface to Vertica
Access to Nonrelational Databases and Other Data Sources
- SAS/ACCESS Interface to ADABAS
- SAS/ACCESS Interface to DATACOM/DB
- SAS/ACCESS Interface to CA IDMS ™
- SAS/ACCESS Interface to IMS-DL/I
- SAS/ACCESS Interface to PC Files, including complete support for the XLSX file format
- SAS/ACCESS Interface to the PI System
- SAS/ACCESS Interface to SYSTEM 2000
The most recent release is SAS/ACCESS 9.4, Maintenance Release 4.
SAS/ACCESS Interface to Amazon Redshift
SAS/ACCESS Interface to Amazon Redshift is the most recently added SAS/ACCESS engine.
It provides the following features:
- Simplified installation and configuration. SAS/ACCESS to Amazon Redshift comes with the required ODBC driver
- Better data insert performance
- Simplified connection with and without DSN configuration
- New interfaces to HAWQ, Impala, PostgreSQL, SAP HANA, and Vertica
- Hadoop interface changes, including a new HDMD procedure to work with metadata that is outside of Hive and HiveServer2. The new SQOOP procedure enables you to access Apache Sqoop to transfer data between a database and HDFS.
- The interface to Cloudera Impala is a database engine that enables you to access Impala through LIBNAME statements and the SQL pass-through facility.
- Teradata security enhancements, including single sign-on with Kerberos authentication and the Teradata wallet feature.
- Bulk loading support was added for Amazon Redshift.
- Enhancements for supported data types
- NCHAR and NVARCHAR data types are supported (New for Oracle)
- ST_GEOMETRY and VARBINARY data types are supported (New for Netezza)
- The Hive data types TIMESTAMP, DATE, and VARCHAR are supported for Hive 0.12 and CHAR for Hive 0.13 are supported. The BINARY and DECIMAL data types are supported. (New for Hadoop)
- The list of SAS functions that can be passed using the SQL pass-through facility has been updated for several database interfaces, including Amazon Redshift, Microsoft SQL Server, PostgreSQL, and Vertica.
- Additional resources for SAS interfaces to Hadoop:
- SAS/ACCESS 9.4 for Relational Databases: Reference includes Hadoop, Impala, and HAWQ interfaces and several new and enhanced features.
- SAS 9.4 Support for Hadoop resource site, including SAS 9.4 Hadoop Configuration Guide for Base SAS and SAS/ACCESS.
- Base SAS 9.4 Procedures Guide includes PROC HADOOP and PROC HDMD.
- SAS 9.4 Statements: Reference includes the FILENAME statement for the Hadoop access method.
- SAS Service Offerings for Hadoop
For a detailed list of enhancements, see "What's New in SAS/ACCESS 9.4 for Relational Databases" in SAS/ACCESS 9.4 for Relational Databases: Reference.
Support for Access to the PI System
Beginning with the second maintenance release for SAS 9.4, SAS/ACCESS supports access to the Data Archive in the PI System. The PI System is a repository for time series data. The data is collected from sensors that are attached to various types of monitoring and analysis equipment.
The February 2016 release of SAS/ACCESS Interface to the PI System included support for the Asset Framework and event frames.For more information, see SAS/ACCESS Interface to the PI System.
What's New in SAS/ACCESS 9.4 Interface to PC Files
Changes and enhancements starting in the second maintenance release of SAS/ACCESS 9.4:
- The SAS/ACCESS Interface to PC Files has added a new SAS LIBNAME engine called XLSX. It enables you to directly read and write data between Microsoft Excel XLSX files and SAS on Linux, UNIX, and Microsoft Windows operating environments. For more information, see SAS LIBNAME Statement for the XLSX Engine.
- The SAS LIBNAME options FILELOCK=, CONNECTION=, and CONNECTION_GROUP are no longer supported.
- Information about installing, configuring, administering, and using the SAS PC Files Server has been moved to a separate document. See SAS PC Files Server: Installation and Configuration Guide. The document also includes examples.
- The SAS/ACCESS 9.4 release has a number of enhancements to support Microsoft Excel XLSX files. For example, you can add a new Microsoft Excel XLSX worksheet to an existing workbook, and you can update an existing worksheet in a workbook.
- You can export Excel XLSX files directly to UNIX. In this release, you can specify DBMS=XLSX to read and write to Excel workbooks under UNIX and Microsoft Windows directly without needing to access the PC Files Server.
- Certain statements used with the IMPORT and EXPORT procedures have been updated: RANGE=, SHEET=, GETNAMES=, GUESSINGROWS=. How RANGE= and SHEET= handle special characters in names has changed in Microsoft Excel XLSX files.
- Starting in SAS/ACCESS 9.4, when you import a Stata file, SAS can read multiple Stata missing values and map them to multiple SAS special missing values, .a-.z or as a single dot (.), for up to 27 missing values.
- Because you can use the Base SAS IMPORT and EXPORT procedures on JMP files without a SAS/ACCESS license, the SAS/ACCESS 9.4 changes for JMP files apply to SAS 9.4 as well.
- SAS/ACCESS 9.4 imports data from JMP files saved with version 7 or later formats, and it exports data to JMP files with Version 7 or later formats. Support for these newer file formats enables you to access JMP files from, for example, the JMP Graph Builder iPad app. JMP file formats in versions 3 through 6 are no longer supported.
- The META data type for JMP files has been replaced by support for extended attributes. When importing a JMP file with extended attributes, the attributes are automatically attached to the new SAS data set. META is ignored in programs and a log message is generated.
- JMP variable names can be up to 255 characters in length. Importing and exporting JMP files with more than 32,767 variables is now supported.
Visit our general product information page on www.sas.com for more information.
Free Online Documentation
- Most recent release for SAS/ACCESS
- SAS/ACCESS 9.4 for Relational Databases: Reference, Ninth Edition PDF | HTML
- SAS/ACCESS 9.4 Interface to PC Files: Reference, Fourth Edition PDF | HTML
- SAS/ACCESS Interface to the PI System: Reference, Third Edition PDF | HTML
- SAS/ACCESS 9.4 Interface to R/3: User's Guide, Fourth Edition PDF | HTML
- SAS/ACCESS 9.4 Interface to ADABAS: Reference PDF | HTML
- Accessibility Features of the Windowing Environment for SAS 9.4 on Microsoft Windows HTML
- SAS 9.4 Hadoop Configuration Guide for Base SAS and SAS/ACCESS available at SAS 9.4 Support for Hadoop.
- SAS/ACCESS Interface to Hadoop is documented in SAS/ACCESS 9.4 for Relational Databases: Reference.
- The FILENAME statement (for the Hadoop access method) is in SAS 9.4 Statements: Reference.
- The HADOOP and SQOOP procedures are in the Base SAS 9.4 Procedures Guide.
- SAS 9.4 PC Files Server: Installation and Configuration Guide PDF | HTML
For support and to share your experiences and questions, see the SAS Community: communities.sas.com/data-management
The following documentation also applies to the SAS 9.4 release:
- All online documentation for supported releases of SAS/ACCESS [HTML]
- SAS/ACCESS titles in online bookstore [Buy]
- The Essential PROC SQL Handbook for SAS Users [Buy]
- It's Raining Data! Harnessing the Cloud with Amazon Redshift and SAS/ACCESS
- An Insider's Guide to SAS/ACCESS Interface to Impala
- Visual Analytics and SAS/ACCESS Interface to Hadoop: Improving Efficiency and Increasing Analyst Satisfaction
- From SAS® Data Management to Big Data Appliances: How SAS/ACCESS Makes Life Easier
SAS Publishing Representatives are available in the U.S. from 8-5 ET to answer your documentation questions. Contact us at 1-800-727-0025, option 4 or e-mail.
- Data Management learning path
- Solutions for Hadoop learning path
- Free on-demand training:
Curriculum consultants are available in the U.S. from 9-5 EST. Contact us at 1-800-727-0025, option 4 or e-mail.
International customers, please contact your country office.
Online Support ResourcesThis 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.
- 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
- 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
Data Management CommunityShare your experiences, questions and ideas with others who use SAS Data Integration Studio, SAS/ACCESS, and other data management products.