Creating Output Files with ODS for Use by Excel - Exchanging Data Between SAS and Microsoft Excel - page 126

8.11 Overview of MSOFFICE2K Examples
The list of examples shown below generate HTML-formatted output text files. The recommended tagset for
generating HTML files is the MSOFFICE2K tagset. This tagset template is a predecessor to the ExcelXP
tagset. It also has a little more flexibility when it comes to what can be displayed. Some graphs are
permitted in the MSOFFICE2K outputs. But the focus here is moving data.

Table 8.5: MSOFFICE2K Examples.

Example
Number

General Description

8.12.1 Generating an HTML Output File with No Options. This example is a

simple output of the SASHELP Shoes dataset with the same output file
being displayed in both Microsoft Excel and Internet Explorer.

8.12.2 Generating HTML Output File Using the Summary_Vars Option. This

example shows how summary totals can be added to the output along with
default page formatting.

8.12 MSOFFICE2K Examples to Write HTML Files

Example 8.12.1 Generating an HTML Output File with No Options
The following code produces an HTML-formatted file that is acceptable to Microsoft Excel, Microsoft
Word, and many Internet browsers. While Microsoft Power Point cannot directly open one of these HTML
files, after the output is opened by Microsoft Excel or Microsoft Word, the output can be copied and pasted
into Microsoft PowerPoint.

Figure 8.22: ODS Code to Use the MSOFFICE2K Tagset.

ODS TAGSETS.MSOFFICE2K BODY ='c:\temp\msoffice2k\shoes3.htm';
PROC PRINT DATA =sashelp.shoes;
RUN;
ODS TAGSETS.MSOFFICE2K CLOSE;

The following figure shows the result of opening the file shoes3.htm using Microsoft Excel. Note that no
special commands or options were used to produce this output.