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