The Little SAS® Book for Enterprise Guide® 4.1

Opening a Microsoft Excel file

There are two ways you can use Microsoft Excel files in SAS Enterprise Guide. You can open the Microsoft Excel file and use it as is, or you can convert the Microsoft Excel file to a SAS data set. Both methods have advantages. Opening a Microsoft Excel file and leaving it as is is simple and if the data in the Microsoft Excel file change, SAS Enterprise Guide will automatically read the new data every time you access the spreadsheet (such as when you run a task or open a Data Grid). Converting a Microsoft Excel file to a SAS data set takes one more step, but you have more control over how the data are read into SAS Enterprise Guide, and SAS data sets are faster to process than Microsoft Excel files opened as is. ...