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

***********************************************************;

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

8.10 MSOFFICE2K Tagset Template Options
The following examples feature the MSOFFICE2K tagset templates, showing simple files being created
and loaded into Excel using many of the options listed above. I have compiled a list of the options available
for the MSOFFICE2K tagset template. The ODS Tagset MSOFFICE2K produces HTML formatted files.

Table 8.4: MSOFFICE2K Options.

MSOFFICE2K Option Description

Options related to titles and footnotes

Associates data cells with header cells. (Used only in PROC
Report.)

HEADER_DATA_ASSOCIATIONS

HEADER_DOTS Add hidden dots to text in table headers.

PERCENTAGE_FONT_SIZE Adjust titles and footnotes to be a percentage of font size.

Options related to page formatting and style sheet selection

CSS_TABLE Select type of style attributes to use.

PAGE_BREAK Selects the type of page break to apply.

Options related to summary tables

Select quoted value to use as text on end of the table
summary.

SUMMARY

Select “YES” to use the table summary to create a table
caption.

SUMMARY_AS_CAPTION

Add the values of the BY variables to the table summary.

SUMMARY_BYVALS

Selecting “YES” will add the BY variable list to the table
summary.

SUMMARY_BYVARS

Quoted value to be added to the end of the table summary.

SUMMARY_PREFIX

Options related to tagset template documentation

Write user Help information about the tagset template options
to the system log.

DOC