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

NOTE: The examples shown in this chapter use SAS Enterprise Guide 6.1. Prior versions of SAS
Enterprise Guide may have slight different interfaces. While the “Import”, “Export”, and “Send To”
options also appear in several places within the SAS Enterprise Guide menus, each of the three options
performs similarly regardless of how you start the option.

5.2 Purpose
This chapter describes methods of sharing data between SAS and Microsoft Excel. I have explained most
of the methods previously; SAS Enterprise Guide just packages them into a wizard to standardize the
processing. The overall bit configuration of the hardware and software may influence the figures and
wizard options presented. This topic does not deal with features of SAS Enterprise Guide other than those
that permit the movement of data between Excel and SAS Enterprise Guide. SAS Enterprise Guide can use
some advanced data access methods like OLEDB (Object Linking and Embedding, Database) and ODBC
(Open Database Connectivity). These will not be discussed in this chapter.

5.3 Typical Methods to Access Excel from SAS Enterprise Guide
Common methods of accessing Excel data from within SAS Enterprise Guide include importing and
exporting data from text files or Excel files. Most of the examples in this chapter deal directly with those
methods. In addition to Microsoft Excel workbooks, the SAS Enterprise Guide wizards can process other
types of data files like Microsoft Access database files, *.csv, *.tab, *.txt, *.htm, and *.html text files.

5.4 Overview of the Examples
The examples in this chapter were generated with SAS Enterprise Guide 6.1 on a system where the SAS
Add-In for Microsoft Office has been installed for Microsoft Word, Excel, Power Point, and Outlook.
Some of the features described here require this software. However, some older versions of SAS Enterprise
Guide are able to transfer data and graphs to Microsoft Excel and Word without the SAS Add-In for
Microsoft Office. While you were able to transfer data and graphs in much earlier versions of SAS
Enterprise Guide, this ability was not well publicized. These features can be found by searching the tool or
option menus of SAS Enterprise Guide for the Word ( ) and Excel ( ) icons and activating them. There
are no examples in this chapter using these icons, but they are mentioned here to increase your awareness
of the features present in older versions of SAS Enterprise Guide.

5.5 List of Examples

Figure 5.5.1: List of Examples for Enterprise Guide.

Example Number General Description

5.1 Using the Export Method with Enterprise Guide. This example shows

you how to open a SAS dataset within SAS Enterprise guide and then
Export the data to an Excel workbook. This example uses the “Save”
option.

5.2 Using the “Send To” Method. This example shows how to export the

data to an Excel workbook using the “Send To” option.

5.3 Using the “Send To” Method to Output a Graph or Report. This

example shows how to export a graph or report to an Excel workbook
using the “Send To” option.

5.4 Using the “Export” Method to Output a Graph or Report. This

example shows how to export a graph or report to an Excel workbook
using the “Export” method.