SAS Enterprise Miner Tutorial
Shared by: techmaster
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.