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

Overview

SAS/ACCESS 9.3 Interface to PC Files enables you to exchange (import and export) PC files between the original source format and SAS data sets. Files are moved between the native PC format and SAS data sets via Import and Export procedures and wizards or through the use of LIBNAME statements.

General Enhancements

General enhancements found in this release include the following.

In SAS/ACCESS 9.2 Interface to PC Files, the Import and Export procedures and wizards were updated to include support for JMP files. This support is now included, by default, in Base SAS. This means that you no longer need a SAS/ACCESS Interface to PC Files license to access JMP files through the use of Import and Export procedures and wizards.
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.

LIBNAME Engines

Starting in SAS 9.3, SAS/ACCESS 9.3 Interface to PC Files supports these LIBNAME engines:

LIBNAME ACCESS engine for 32- and 64-bit Microsoft Windows operating systems
LIBNAME EXCEL engine for 32- and 64-bit Microsoft Windows operating systems
LIBNAME PCFILES engine for 32- and 64-bit Microsoft Windows operating system and for Linux and UNIX operating systems
LIBNAME JMP engine for Linux, UNIX, and Microsoft Windows operating systems

Import and Export Procedures and Wizards

In this release, the Import procedure supports source type XLSX to read the Microsoft Excel 2007 and 2010 default file format (.xlsx) on Linux, UNIX, and Microsoft Windows operating systems.
Import and Export procedures and wizards support the following source types in both 32- and 64-bit Microsoft Windows operating system.
- Microsoft Access database files (*.accdb, *.mdb)
- Microsoft Excel files (workbook: *.xlsx, *.xlsm, *.xlsb; spreadsheet: *.xls)
- Microsoft Access database on PC Files Server
- Microsoft Excel workbook on PC Files Server

PC Files Server

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 on the 64-bit Windows operating system. This allows the server to take advantage of the associated 64-bit features and to operate more efficiently. The PC Files Server continues to operate on and support the Windows 32-bit operating system.