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

Get The Little SAS® Book for Enterprise Guide® 4.1 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.