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

SAS/ACCESS 9.2 Interface to PC Files has these new features and enhancements:

• support for running the PC Files Server as a Windows service

• new PC Files Server authentication option

• new PC Files Server autostart for Microsoft 64-bit Windows systems

• support for Microsoft Excel 2007 and Microsoft 2007 Access files

• support for UNICODE= LIBNAME option

• support for FMTLIB option to support user-defined formats

• support for new file formats

• date and time value differences between SAS and Microsoft files

• documentation enhancements for SAS/ACCESS Interface to PC Files

Enhanced PC-specific support is available for the IMPORT and EXPORT procedures, as well as the Import and Export Wizards.

For information that is specific to UNIX and OpenMVS for the IMPORT and EXPORT procedures, see the Base SAS Procedures Guide.

SAS import and export utilities support these file formats:

• dBase DBF Files

• Lotus 1-2-3 WK n Files

• Microsoft Access Database Files

• Microsoft Excel Workbook Files

• JMP Files

• Paradox DB File Formats

• SPSS SAV Files

• Stata DTA Files

In different versions of SAS, the IMPORT procedure and the LIBNAME engine can read in date and time values from a Microsoft Access databases and Microsoft Excel workbooks using different formats.

For information about how to process date and time values, see Processing Date and Time Values between SAS and Microsoft Excel and Processing Date and Time Values between SAS and Microsoft Access.

SAS/ACCESS 9.2 Interface to PC Files: Reference was significantly reorganized and rewritten.

Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.