SAS Products

In the March 2012 release, SAS 9.3 has a new SAS/ACCESS interface to Hadoop. The Apache™ Hadoop™ software library is a framework that enables the distributed processing of large data sets across clusters of computers. The Hadoop Distributed File System (HDFS) is a distributed, scalable, and portable file system for the Hadoop framework. HDFS is designed to hold large amounts of data and provide access to the data to many clients that are distributed across a network.

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

• Changes to operating environments for several SAS/ACCESS interfaces
• New nicknames for three SAS/ACCESS interfaces
• New Teradata temporal qualifiers and table-level definitions for table creation
• Information about SAS In-Database Products has moved to these new documents, which are available from the SAS In-Database Technology product documentation Web site.
  • SAS In-Database Products: Administrator’s Guide contains installation and configuration information.
  • SAS In-Database Products: User’s Guide contains information about using scoring functions and SAS formats inside relational DBMSs.

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.

• SAS Press Books
  • Saving Time and Money Using SAS
  • The Essential PROC SQL Handbook for SAS Users
• All SAS/ACCESS titles in online bookstore
• Most Used SAS Documentation for SAS/ACCESS
  • SAS/ACCESS 9.3 for Relational Databases: Reference
    PDF (7.5MB)  |   HTML   |   Purchase book
  • SAS/ACCESS 9.3 Interface to PC Files: Reference
    PDF (6.4MB)  |   HTML
  • SAS/ACCESS 9.3 DATA Step Interface to CA-IDMS: Reference
    PDF (817KB)  |   HTML
  • SAS/ACCESS 9.3 Interface to ADABAS: Reference
    PDF (1.3MB)  |   HTML
  • SAS/ACCESS 9.3 Interface to CA-Datacom/DB: Reference
    PDF (1.3MB)  |   HTML
  • SAS/ACCESS 9.3 Interface to IMS: Reference
    PDF (2.2MB)  |   HTML
  • SAS/ACCESS 9.3 Interface to SYSTEM 2000: Reference
    PDF (1.6MB)  |   HTML
  • SAS/ACCESS 4.4 Interface to R/3: User's Guide
    PDF (1.8MB)  |   HTML
  • SAS 9.3 Interface to Hadoop: Reference [PDF] (1.1MB) New! March 2012
• All Online Documentation for SAS/ACCESS
• 2011 SAS Global Forum Papers
  • Five Ways to Speed Up Your Data Loading Using SAS/ACCESS for Relational Databases
  • Teradata Parallel Transporter: Loading Your SAS Data Just Became Easier
  • Working with a DBMS using SAS Enterprise Guide

  ---

  Need help?

  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.

• 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