What's New Table of Contents |
What's New in SAS/ACCESS 9.0 and 9.1 for PC Files
Overview
The differences between the PC and UNIX features for SAS/ACCESS for PC files have been significantly decreased. The documentation has also been enhanced with new sections added for these two operating environments.
Note:
- This section describes the features of SAS/ACCESS for PC files
that are new or enhanced since SAS 8.2.
Windows Details
- The LIBNAME statement for PC files, new for SAS 9.0, provides direct, transparent access to Microsoft Access (97, 2000, and 2002) and Microsoft Excel (5, 95, 97, 2000, and 2002).
- PROC IMPORT and PROC EXPORT, using the SAS/ACCESS engine for PC files, provide direct access to JMP data files.
- PROC SQL, using capabilities of the new PC files engine, enables you to communicate with Microsoft Access and Microsoft Excel.
- Enhancements to the Import/Export wizard and procedures enable you to interact with JMP data files and to access multiple Microsoft Excel worksheets.
UNIX Details
- The SAS/ACCESS interface to PC Files on UNIX communicates with the PC files server. The server enables you to process requests for PC data.
- A new engine, called pcfiles, is available in SAS 9.1. This engine enables you to access data stored on network accessible PCs. This engine, working with new UNIX features, also enables you to directly access Microsoft Access (97, 2000, and 2002), Microsoft Excel (5, 95, 97, 2000, and 2002), and data from ODBC data sources on the PC (for example, the Microsoft SQL Server).
- Enhancements to PROC IMPORT and PROC EXPORT enable you to access local JMP data files and remote JMP data files that are stored on the PC via the client/server model, in addition to Microsoft Access, Microsoft Excel, and ODBC data sources.
- The Pass-Through Facility for PC files uses the pcfiles engine to communicate directly with Microsoft Access, Microsoft Excel, and ODBC data sources.