O'Reilly logo

The Little SAS® Book for Enterprise Guide® 4.1 by Lora D. Delwiche, Susan J. Slaughter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required