SAS/ACCESS Software for PC File Formats: Reference

Import/Export Facility

The Import/Export facility is a tool, called a wizard, that guides you through the importing or exporting process. From a SAS session's PROGRAM EDITOR window, select the File menu and then select the Import Data or Export Data item. Detailed information about using the wizard is available from the [Help] button.

The Import Wizard enables you to read data from an external data source and write it to a SAS data set. External data sources can include DBMS tables, PC files, spreadsheets, and delimited external files, which are files containing columns of data values that are separated by a delimiter such as a blank or a comma. Import Window shows some of the PC file formats that you can import from the Windows environment.

Import Window

[IMAGE]

The Export Wizard reads data from a SAS data set and writes it to an external file source. Export Window shows an example of the Export Window under Windows NT:

Export Window

[IMAGE]

From the primary window of the Import/Export facility, you can also access the External File Interface (EFI). EFI is a point-and-click interface that enables you to read and write data in a file type that is not known to the Import/Export facility. For example, you could use EFI to transfer data from a SAS data set to a file format that is proprietary for your company. Detailed information about using EFI is available from the [Help] button. Accessing the External File Interface shows you how to access EFI from the Import Wizard:

Accessing the External File Interface

[IMAGE]

Chapter Contents
Previous
Next
Top of Page