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

Opening a Microsoft Excel file

There are two ways you can use Microsoft Excel files in SAS Enterprise Guide. You can open the Microsoft Excel file and use it as is, or you can convert the Microsoft Excel file to a SAS data set. Both methods have advantages. Opening a Microsoft Excel file and leaving it as is is simple and if the data in the Microsoft Excel file change, SAS Enterprise Guide will automatically read the new data every time you access the spreadsheet (such as when you run a task or open a Data Grid). Converting a Microsoft Excel file to a SAS data set takes one more step, but you have more control over how the data are read into SAS Enterprise Guide, and SAS data sets are faster to process than Microsoft Excel files opened as is. ...

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