Managing Your Data in the SAS Windowing Environment

Importing Data into a Table

Whether your data is stored in a standard file format or in your own special file format, you can use the Import Wizard to import data into a SAS table. The types of files that you can import depend on your operating environment.

Import a Standard File

To import a standard file, follow these steps:

Select File Import data from the toolbar.

The Import Wizard - Select import type window appears.
Select the type of file that you are importing by selecting a data source from the Select a data source menu. Note that Standard data source is selected by default.

In this example, Microsoft Excel 97/2000/2002/2003 Workbook is selected.
Click Next to continue.
In the Connect to MS Excel window, enter the pathname of the file that you want to export, and then click OK.
In the Import Wizard - Select table window, enter the name of the table that you want to import.
Click Next to continue.
In the Import Wizard - Select library and member window that appears, enter a location in which to store the imported file.

In this example, WORK is selected as the library, and FURNSASLESORTED is selected as the member name.
Click Next to continue.
If you want SAS to create a file of PROC IMPORT statements for later use, then enter a filename that will contain the SAS statements.
Click Finish to complete this task.

Import a Non-standard File

If your data is not in standard format, you can use the External File Interface (EFI) facility to import data. This tool enables you to define your file format and offers you a range of format options. To use EFI, select User-defined file format in the Import Wizard and follow the directions for describing your data file.

Top of Page