Importing and Exporting External Data

Overview of Importing and Exporting Data

In this chapter you learn how to create an external text file from a SAS table. You also learn how to take data that exists outside of SAS and bring it into the SAS to be processed.

An external file contains data that resides in a file outside the SAS system. In this task, an external file is also called a flat file.

There are two ways to export to and import from external files:

Use the Import and Export Wizards provided by SAS
Use the import and export capabilities provided by SAS/ASSIST software.

The Import and Export Wizards are generally easier to use, but are not available in mainframe operating environments. If you are using a desktop operating environment, then it is recommended that you use them. From any SAS window (including SAS/ASSIST task windows and the WorkPlace menu), selectFile Import DataorFile Export DataBoth wizards have extensive online help available.

If you are using a mainframe operating environment, or are interested in SAS/ASSIST software's import and export capabilities, continue with this chapter.

Top of Page