SAS Enterprise Guide

Another approach to importing text files with SAS is to use the SAS Enterprise Guide interface, which ships free with Base SAS 9. The following example imports the LABNORM file using SAS Enterprise Guide 3.0. 

From within a project in SAS Enterprise Guide, select File and then Import Data... from the toolbar. Select where to open the data from in the pop-up file selection window and click Open. A data import options window like the following will appear  

By default, Import entire file is selected, so deselect it and specify that line 1 is to be used for column headings and that all rows at line 2 and beyond are to be imported. Next, select the Text Format option and make the following changes so that the pipe character is set as the variable delimiter. 

The next step is to specify Column Options, where the SAS variable name, label, type, length, informat, and format can be changed if the SAS Enterprise Guide defaults are not desired. Also, there is a variable drop field option as well. The following is a sample of that window filled out for the LABNORM file. 

Region to irporl Teftt Format Column Options Results 

---

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... 

SAS provides many ways of importing ASCII text files. These methods include using PROC IMPORT and the Import Wizard, the SAS DATA step, and SAS Enterprise Guide. 

If you click Save in the window, the process is saved to the current project in SAS Enterprise Guide. If you select the Preview window in the lower-left comer of the window, you can see the SAS DATA step code that SAS Enterprise Guide generates and the results of that code. Click Run and SAS Enterprise Guide will import the data. If the results are not exactly what you want, then the saved Import Data process shown in the following window can be opened, changed, and rerun. 

Some commonly used SAS tools for importing Microsoft Excel and Microsoft Access data into SAS include the LIBNAME statement, the Import Wizard/PROC IMPORT, the SQL Pass-Through Facility, and SAS Enterprise Guide. 

Note how SAS Enterprise Guide defaults to row 1 containing column headings and then begins importing actual data in column 2. If you select Column Options in the left pane, you will see this window ... 

At this point, column/variable attributes can be changed. For instance, in the preceding window you see that the Lab Test field defaults to 255 characters wide, which you can easily reduce if desired. If you then click Results in the left pane, you can change where the SAS data set is stored. At this point, click Run and you will see that the import into SAS has taken place in SAS Enterprise Guide. 

The process for importing Microsoft Access files into SAS Enterprise Guide is much like the process in the previous Excel example. 

Here is the resulting dm.csv CSV file created by SAS Enterprise Guide ... 

Because the Microsoft Office suite is so widely used, it is sometimes necessary for you to export SAS data sets into Microsoft Access or Microsoft Excel files. SAS provides the Export Wizard/PROC EXPORT and the SAS Enterprise Guide interface for exporting data directly to Microsoft Office files. 

SAS Enterprise Guide 3.0 offers a simple, convenient export tool for Microsoft Access and Excel files. To export the DM data set to Microsoft Excel in SAS Enterprise Guide, simply select the file in the Process Flow window, click File, and select Export dm from the menu as follows ... 

You may find that you need to export your SAS data as something other than regular ASCII text or Microsoft Office files. In this case, the export wizards in the SAS windowing environment in SAS 9 and SAS Enterprise Guide 3.0 can easily export the following file formats ... 

SAS Enterprise Guide was used to analyze data. The best linear regression model to predict API based on H-NMR spectra has the form ... 

---