Wizard and PROC IMPORT

The interactive SAS Import Wizard provides an easy way to import the contents of Microsoft Excel and Access files into SAS. Here again, the Import Wizard is essentially a graphical user interface that builds the PROC IMPORT code for you. Begin in the interactive SAS windowing environment by selecting File from the toolbar and then Import Data... from the drop-down menu. A window like the following will appear, where you can select Microsoft Excel as a standard data source. 

Click Next, and a file browser window will open that allows for the drill-down and selection of the Microsoft Excel file of interest. Once the file is selected, a Select Table window will open. This window allows you to pick which worksheet in the Excel file you want to turn into a SAS data set. Click the Options button to see the new options available with SAS 9.1 and PROC IMPORT. 

Note that the default options were chosen in the preceding window. We will look at those further when we explore the subsequent PROC IMPORT code. Now, click OK in the Spreadsheet Options window and then click Next in the Select Table window. The Select Library and Member window opens, which allows for the selection of a SAS library and data set name as follows. 

Click Next and SAS will prompt you to see if you want to save the PROC IMPORT code generated by the Import Wizard. Click Finish to complete the file import. Here is the PROC IMPORT code generated by SAS from this run. 

Program 3.8 PROC IMPORT Code Generated by the Import Wizard to Read a Microsoft Excel File 

---

PROC IMPORT and the Import Wizard 44 SAS DATA Step 52 SAS Enterprise Guide 53 Importing Microsoft Office Files 56 LIBNAME Statement 58 Import Wizard and PROC IMPORT 59 SAS/ACCESS SQL Pass-Through Facility 64 SAS Enterprise Guide 65 Importing XML 68... 

---