SAS Institute. The Power to Know

FOCUS AREAS
Return to ODS MARKUP

Base SAS

Customer-Contributed Tagsets

SAS users contributed these tagsets, which make SAS output usable by third-party spreadsheet software

XHTML and SYLK

The following user-defined tagsets were contributed by
Jack Hamilton
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California

NOTE: The tagsets were originally defined to use with PROC REPORT and a specific input SAS data set. SAS development modified the code by adding HEADER and ROWCOL events so that the tagsets can be used with other SAS applications. However, PROC REPORT does not generate HEADER events, which is why they weren't included originally.

TAGSETS.XHTML
creates plain XHTML output, which is useful for input into Excel or other programs. SAS does not currently ship a style or tagset to create XHTML.
(For information on XHTML, see XHTML(TM) 1.0: The Extensible HyperText Markup Language.)
TAGSETS.MTXHTML
creates XHTML for display; the definition includes additional header code.
(For information on XHTML, see XHTML(TM) 1.0: The Extensible HyperText Markup Language.)
TAGSETS.SYLK
creates SYLK (Spreadsheet Symbolic Link) output, which is a format recognized by Microsoft Excel and other spreadsheet programs. TAGSETS.SYLK lets you write a plain-text file that when imported into a spreadsheet program results in formatted cells. You can set bold, italic, and column widths, established named ranges, insert formulas, and do various other interesting things . . . this code does not illustrate all the possibilities.
(For information about SYLK, see Wotsit's Format.)

Excel

This user-defined tagset was contributed by
Frank Poppe
PW Consulting
The Netherlands

This tagset writes ODS output directly into a running Excel application (through Excel DDE macro syntax).

TAGSETS.TagSetExcelDDE
provides the tagset code plus comments and examples.
TagSetDDEmacros
contains some macros that are necessary only for the definition. You don't need them in order to use the tagset.

Your Turn

The ODS and SAS XML LIBNAME engine developers, testers, and documenters are very excited about the potential of these new capabilities. You can send electronic mail to ods@sas.com with your comments.
Last Updated: Sept 02, 2003