SAS/ACCESS Software for PC File Formats: Reference

Import/Export Facility

UNIX and PC users can access Excel (or XLS) data--including Excel 97 files--through the Import/Export facility or by using the IMPORT and EXPORT procedures. An overview is included in Import/Export Facility and Procedures.

To use the point-and-click interface from a SAS PROGRAM EDITOR window, select the File menu and then select the Import Data or Export Data item. Information about how to import or export Excel data is available from the [Help] button. The following is a sample Import window:

Import Window

[IMAGE]

To write code to import or export Excel data, refer to the detailed descriptions of the IMPORT and EXPORT procedures in the SAS Procedures Guide. This documentation also includes several examples.

Chapter Contents
Previous
Next
Top of Page