Easy Data Movement between SAS and Microsoft Excel - Exchanging Data Between SAS and Microsoft Excel - page 11

The pop-up menu shown in Figure 1.4.1b lists items that are explained in the following sections. Each of
these menu items represents a method of transferring data between SAS and Excel. In some cases other
options also exist, but here we are looking for methods that work to get data into Excel. As a shortcut, once
the menu is displayed, type the underlined letter to invoke the option.
1.4.2 Picking the Export Wizard from the SAS Explorer Window “E x port”
Menu
Example 1.4.2
Selecting the “Export” option displays the following Export wizard menu. This is the first of several menus
that will guide you through the SAS Export process. SAS versions have similar tools, but each version of
SAS may have slightly different features available based upon the underlying hardware, operating system,
and SAS software version you are using. But all of the versions will guide you through the menus and offer
to save the code into a file for reuse later.
Figure 1.4.2b: First Menu of the SAS Export Wizard Tool for SAS 9.2 TS Level 1M0.
The screen image shown in Figure 1.4.2b is from SAS 9.2 and does not present the options for 64-bit
hardware or software. The Export wizard will generally walk you through the process selecting the SAS
LIBNAME and data file, and then ask you questions about the output format you wish to use and the file
name and location where you want to store the output file. While the Export wizard menus are relatively
self-explanatory, you do need to know the output format you want and the location to which you can write
the output file. More information about the SAS Export wizard can be found in the SAS documentation for
each version of SAS.
1.4.3 Using the “Copy Contents to Clip b oard” Option of the SAS Explorer
Window
Example 1.4.3
This option generates HTML code that contains the data from the SAS dataset and places that data on the
Windows clipboard. This HTML data can be pasted into any file or application that will accept a paste
command. When this is saved as an HTML file or a text (.txt) file, the resulting file can be opened with