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 Sources to 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 HANA
- SAS/ACCESS Interface to Sybase
- SAS/ACCESS Interface to 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 3.
New! SAS/ACCESS Interface to Amazon Redshift
SAS/ACCESS Interface to Amazon Redshift is a new SAS/ACCESS engine based on SAS 9.4M3.
It provides the following enhancements on top of what SAS/ACCESS Interface to ODBC would give for accessing data in Amazon Redshift:
- Simplified installation and configuration. SAS/ACCESS to Amazon Redshift comes with the required ODBC driver
- Enhanced implicit pass-through (implicit conversion of SAS queries into Amazon Redshift SQL). Implicit pass-through is turned on by default (DBIDIRECTEXEC option) to minimize the amount of data transferred to SAS
- More SAS functions will push down to the database.
- Explicit pass-through support (you can create and execute Amazon Redshift code from SAS)
- 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.
- Updates to the SQLGENERATION= options
- Microsoft Windows for x86 and Microsoft Windows for x64 are supported (New for Microsoft SQL Server)
- 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)
- Object names up to 32 characters are supported (New for Teradata)
- Teradata wallet feature is now supported for system security.
- The list of SAS functions that can be passed using the SQL pass-through facility has been updated for several database interfaces.
- Many new and enhanced options for various interfaces, including the following:
- Several LIBNAME options and data set options are available for bulk loading (New for Impala)
- The CONFIG= and CONFIGDIR= LIBNAME options define the name and location of bulk-load configuration files. (New for Hadoop)
- The DRIVER_VENDOR= LIBNAME option enables you to indicated the name of the vendor for your Hadoop distribution. (New for Impala)
- The IMPALA_PRINCIPAL= LIBNAME option enables you to specify the Kerberos principal (New for Impala)
- The PARMSTRING= and PARMDEFAULT= options enable you to set default values for a list of parameters. (New for SAP HANA)
- The POST_STMT_OPTS=, POST_TABLE_OPTS=, PRE_STMT_OPTS=, and PRE_TABLE_OPTS= options enable you to add text to the automatically generated CREATE TABLE statement. (New for several database engines)
- The TR_ENABLE_INTERRUPT= LIBNAME option enables you to cancel a query. (New for Teradata)
- The WARN_BIGINT= LIBNAME option warns if a table contains a BIGINT. (New for DB2 under z/OS)
- 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
Support for Access to the PI System
Beginning with the second maintenance release for SAS 9.4, SAS/ACCESS supports access to 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. 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, Eighth Edition PDF | HTML
- SAS/ACCESS 9.4 Interface to PC Files: Reference, Third Edition PDF | HTML
- SAS/ACCESS Interface to the PI System: Reference, Second Edition PDF | HTML
- SAS/ACCESS 9.4 Interface to R/3: User's Guide, Third 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, Fifth Edition.
- 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]
SAS Publishing Representatives are available in the U.S. from 8-5 ET to answer your documentation questions. Contact us at 1-800-727-3228 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-333-7660 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.