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

The SAS web site http://support.sas.com/rnd/base/topics/odsmarkup/ provides access to many of the
ExcelXP versions listed in Table 8.6.

Table 8.6: List of ExcelXP Tagset Releases.

Version Comment

V1.28 Shipped with SAS V9.1.3M
V1.37 June 2006 version available on web site
V1.62 May 2007 version available on web site
V1.72 June 2007 version available on web site
V1.86 April 2008 version available on web site
V1.94 Shipped with SAS V9.2 *
V1.116 August 2010 version available on web site
V1.122 Shipped with SAS V9.3 *
V1.130 August 2013 version available on web site
* Check your maintenance release to verify the ExcelXP tagset version shipped with your software.

The options for the ExcelXP tagset template are described below, and fall into several categories based
upon what part of the output the option modifies.

ExcelXP Tagset Template Feature Groups:
● Column features including width, repetition, and visibility of the column on the Excel spreadsheet.
● Data features ASCII dots, subtotals, Excel column filtering, numeric formatting, and formulas.
● Excel display features that include frozen row and column headers, alignment of missing values,
page orientation, text wrapping in cells, and the Excel “ZOOM” level.
● Displaying Help text in the SAS Log window.
● Printing features controlling color printing, centering output, punctuation, print quality, scale, print
order, page breaks, gridlines, and sizing the data to the pages.
● Row features including height and repetition.
● Title and footnote features that allow control of titles, footnotes including content, merging, and
frequency.
• Workbook and worksheet features allowing the generation of blank sheets, table of contents
sheets, index sheets, sheet names, sheet labels, and style features.

The SAS code below shows two ways to invoke the ExcelXP tagset. The ExcelXP tagset template is not
available as an ODS destination.

Figure 8.27: SAS Code Using the Markup Option to Invoke the ODS Tagset ExcelXP.
ODS MARKUP BODY='c:\temp\ExcelXP\shoes1.xml' TAGSET=ExcelXP;
PROC PRINT DATA=sashelp.shoes;
RUN;
ODS MARKUP CLOSE;