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

Figure 8.20: Excel Output File Produced by the Code in Figure 8.18.
8.9 Syntax of ODS MSOFFICE2K Output Processes to Write HTML Files
The tagset template “MSOFFICE2K” is a Base SAS tagset template specifically designed to produce
HTML output files that are intended to be loaded into Microsoft Office products. The parent tagset
template for MSOFFICE2K is a version of the HTML tagset template. These tagset templates share the
same options. The options for the MSOFFICE2K tagset template are described below, and in general they
fall into several categories based upon what part of the output the option modifies.
MSOFFICE2K Tagset Template Options Grouped by Features
I like to group the options by the parts of the output they affect, by the features if you will:
● Modify or display SAS outputs for titles, footnotes, bylines, summary, and table headers.
● Display of SAS log messages and tagset template Help messages.
● Page formatting and style sheet selection.
• Summary table formatting.
ODS Syntax for MSOFFICE2K Tagset Template Use
The examples shown below will include ODS commands to execute the features for each example, but may
not include all of the ODS options available for each command. Three examples are shown in this section
that deal with the MSOFFICE2K tagset template. To get started let's use different ODS command
sequences in Figure 8.21 that show three ways to execute the MSOFFICE2K processing. All three of these
methods are part of Base SAS, and they all produce the same output.
Figure 8.21: ODS MSOFFICE2K Calls Generate an Output HTML File.
ODS MARKUP BODY='c:\temp\msoffice2k\shoes1.htm' TAGSET=MSOFFICE2K;
PROC PRINT DATA=sashelp.shoes;
RUN;
ODS MARKUP CLOSE;
***********************************************************;
ODS MSOFFICE2K BODY ='c:\temp\msoffice2k\shoes2.htm';
PROC PRINT DATA =sashelp.shoes;
RUN;
ODS MSOFFICE2K CLOSE;