Importing and Exporting Data with the Wizards

With the Import and Export Wizards, you can transfer data between external data sources and SAS data sets. Each wizard presents a series of windows with simple choices to guide you through the import or export process. Since there is no coding required, use of the wizards makes it easy to complete a complex or infrequently performed task.

The Import Wizard guides you through the steps to read data from an external data source and write it to a SAS data set
The Export Wizard guides you through the steps to read data from a SAS data set and write it to an external data source.

To start the Import Wizard, select File

Import Data.

To start the Export Wizard, select File

Export Data.

If you indicate that the source data type (for import or for export) is a user-defined format, after stepping through a series of windows, the External File Interface (EFI) opens to enable you to specify your data. Regardless of the type of source data, you can request that the wizard generate the procedure statements, which you can save to a file for subsequent use.

For each step, each wizard displays a window with available selections. To get help for any window or window item, select Help.

Note: Although you can use JAWS® to facilitate the use of the Import and Export wizard screens, the Import and Export wizards are not Section 508 compliant.