Importing and Exporting External Data

Exporting a File

This section shows you how to export a file using SAS/ASSIST software's export feature.

To export data to an external file, follow this selection path:Tasks Data management Export dataThe Export data to flat file window appears.

Export Data to Flat File Window
If the active table is SASUSER.HOUSES, then continue to the next step. Otherwise, select Table, and then select the SASUSER.HOUSES table. For more information on selecting tables, see Selecting a Table.
If other task selections exist (for example, a filename is listed for Export to file), then selectFile Newto clear these selections.

In the Export to file field, type the complete physical pathname of the external file named HOUSDATA , into which you will export the SAS table. This file is created for you during the export process. Use the following table as a guide to naming the file. Note that USERID represents your userid.

Examples of Operating Environment-Specific Physical Pathnames
Operating environment	Example
z/OS	USERID.HOUSDATA.EXPORT
OpenVMS	DEVICE:[EXPORT] HOUSDATA
UNIX	/u/userid/export/housdata
Windows	C:\export\housdata

You can export the data in fixed columns or with a separator that you specify. For this example, select Fixed columns.
SelectRun SubmitA window appears with a message that your file was successfully created, and with a prompt to browse the file.

File Successfully Created Message
Select Yes to browse the exported file in the FSLIST window, as shown in the following display.

Browsing the Exported File
SelectFile Closeto return to the Export Data to Flat File window.

Exiting This Task

When you are ready to return to the WorkPlace menu or move on to another task, follow the directions in Exiting a Task.

Top of Page