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.12. Opening Microsoft Excel Spreadsheets as SAS Data Sets

When you open a Microsoft Excel spreadsheet as a SAS data set, SAS Enterprise Guide copies the data in the spreadsheet into a SAS data set. As a result:

  • You can run tasks using the data (and the tasks will run more quickly because it’s faster to read a SAS data set than a Microsoft Excel spreadsheet).

  • You can edit the data, but any changes you make will not be applied to the original Microsoft Excel spreadsheet.

  • If the original spreadsheet changes, SAS Enterprise Guide will not automatically read the updated version. To get the updated version, you must import the spreadsheet again.

Input Data

This example shows a Microsoft Excel spreadsheet named Bookings.xls, which contains six columns: ...

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