SAS Enterprise Miner Tutorial

							SAS Enterprise Miner Tutorial

Importing Data into a SAS Dataset

Start the SAS program.

From the File menu, choose Import Data. The default option in the first screen that you
see in the Import Data wizard sets Excel as the source type, which is what you want.
Click on ‘Next’.

In the next dialog box, choose ‘Browse’, and find the Excel workbook file that you want
to import. Select that file.

In the next dialog screen, you are asked to choose a table. If the spreadsheet file has a
single worksheet, this is selected by default. If not, scroll through the drop-down list and
select the relevant sheet.

The next dialog screen asks you to select which library you want to add the dataset to. In



                                                                                               Library
                                                                                               drop-down
                                                                                               list


                                                                                               Filename
                                                                                               you type in




the example above, I chose the WORK library, and named the dataset ‘Cardata’.
The next dialog screen asks you whether you want to save the import procedure as a
program. Select ‘Finish’.

The dataset is now available for use by you in EM.