The Little SAS® Book for Enterprise Guide® 4.1

2.11. Using Microsoft Excel Spreadsheets As Is

When you read a Microsoft Excel spreadsheet in SAS Enterprise Guide, you have to choose whether to open the spreadsheet as is or as a SAS data set. If you open the spreadsheets as is, then:

• You can run tasks using the data.

• You cannot edit the data.

• If that spreadsheet changes, SAS Enterprise Guide will automatically read the updated version the next time it accesses the data (such as when you run a task or open a Data Grid).

Input Data

This example shows a Microsoft Excel spreadsheet named Bookings.xls which contains six columns: the office that booked the tour, followed by the customer’s identification number, the identification number of the tour, the number of travelers, the money deposited, ...