SAS Enterprise Guide Methods and Examples - Exchanging Data Between SAS and Microsoft Excel - page 67

Chapter 5: SAS Enterprise Guide Methods and
Examples

5.1 Introduction................................................................................................... 67
5.2 Purpose ......................................................................................................... 68
5.3 Typical Methods to Access Excel from SAS Enterprise Guide ....................... 68
5.4 Overview of the Examples ............................................................................. 68
5.5 List of Examples............................................................................................ 68
5.6 Examples....................................................................................................... 69
Example 5.1 Using the Export Method with Enterprise Guide ........................................69
Example 5.2 Using the “Send To” Method ........................................................................71
Example 5.3 Using the “Send To” Method to Output a Graph or Report.......................71
Example 5.4 Using the “Export” Method to Output a Graph or Report .........................75
Example 5.5 Using “Open” or “Import” Toolbar Options to Read Excel Workbooks...77
Example 5.6 Using the “Import Data” Toolbar Option to Read a Range of Cells .........80
5.7 Conclusion .................................................................................................... 84

5.1 Introduction
This chapter is an introduction to moving data between SAS Enterprise Guide and Microsoft Excel. SAS
Enterprise Guide has a lot of features that process and analyze data. Here we are interested in a few
processes that present data to and read data from Excel, and that are available when using SAS Enterprise
Guide. Some of these methods are found on the File tab of the Enterprise Guide toolbar and are handled by
software “wizard” tools. Many of the examples in this chapter offer step-by-step instructions with pictorial
explanations of the steps needed to perform the tasks. This chapter assumes a working knowledge of SAS
Enterprise Guide 4.3, 5.1, or 6.1 and shows examples of the following methods of moving data between
SAS and Excel.

Send data to - (Output to Excel)

Export data to - (Output to Excel)

Export a graph - (Output to Excel or Word)

Open a spreadsheet - (Input from Excel)

Import a spreadsheet - (Input from Excel)

Import a range of cells - (Input from Excel)

SAS Enterprise Guide 5.1 was the first release to be available in both 32-bit and 64-bit versions. As with all
of the SAS and Excel products, the bit compatibility will need to be watched to make sure the products
work together. SAS Enterprise Guide establishes a Microsoft client/server method of writing data to Excel
files even when executing on one computer. The Microsoft product DDE is not available to SAS Enterprise
Guide. Some of the examples in this chapter rely on the SAS Add-In for Microsoft Office, which is part of
the SAS Enterprise BI Server and SAS Enterprise Miner.