• Print  |
  • Feedback  |

FOCUS AREAS

Hot Topics

Related Links

Return to ODS

Base SAS

ODS MARKUP Resources

Whenever SAS R&D issues new or updated tagsets between releases, they are available for download below, under Get the Tagsets.

ODS MARKUP Statement
This is the reference to the ODS MARKUP statement.

TEMPLATE Procedure: Creating Markup Language Tagsets | Examples (.zip)
This is an introduction and reference to the using tagset language to create your own custom tagset.

Emacs Mode for Editing Tagsets
If you use emacs you'll know what this is.

SAS Notes and Concepts for ODS
These are compiled by Technical Support and developers. See the section for XML and MARKUP.

Papers and Presentations
This is a collection of MARKUP papers and presentations. Example SAS code is included.

Get the Tagsets

If you find that the tagsets that ship with SAS don't meet your needs, try these. Or use these as examples to create your own.

  1. Read Note 32394: Installing and Storing Updated Tagsets.

  2. You can either download a ZIP file

    or download SAS 9 tagsets individually below. The tagsets below include custom tagsets that are not shipped with SAS, as well as updated tagsets with improved functionality. These tagsets are more up-to-date than the ones in the ZIP files above.

CSV, CSVALL, CSVBYLINE (updated September 2011)
This update to the SAS 9.1.3 tagset has enhanced features and performance over the released version. For examples, see the SUGI 31 paper The Beginner's Guide to ODS MARKUP: Don't Panic! (.pdf). The following ODS Statement will provide complete details of all the new features:
ODS CSV file="test.csv" options(doc="help")

ExcelXP 09/26/2011, version 1.127
See the quick reference to options and change log for the tagset. Output from the ExcelXP tagset works with Microsoft Excel as well as the Calc spreadsheet program from OpenOffice.org. The following ODS Statement will provide complete details of all the new features:
ODS tagsets.excelxp file="test.xml" options(doc="help")

Previous versions of the ExcelXP tagset are available:

See ExcelXP samples in these papers and presentations:


HTML with graph bars (.zip) (May 2006)
This tagset was originally included as a part of the "SAS Reports of Your Dreams" paper. This is an update that works with Proc Report. Tell the tagset which table columns should be graph bars and you'll get a more visual indicator of their values. New in this version is image-based slidebars. This automatically works with percentage values. It takes an optional maximum value to make it work with non-percentage values. It also works with negative number ranges. The SAS job includes the tagset, a style, and a simple example.

htmlpanel
This SAS 9.1 tagset automatically creates panels for BY-grouped graphs. It also has controls for semi-automatic and manually controlled paneling. This tagset makes it easy to put graphs and tables side-by-side on a page. Also included are controls for titles, footnotes, and BY lines. Combine this tagset with the htmlscroll tagset for a truly powerful combination.

htmlscroll
This SAS 9.1 tagset enables tables to be scrollable. The scrolling is actually done with JavaScript. This tagset adds the JavaScript and necessary infrastructure to the standard HTML4 tagset.

LaTeX
The SAS 9.1 LaTeX tagsets are quite versatile and enable several different types of rendered output. LaTeX is also useful for embedding in your own documents. This topic explains how to use them.

MSOffice2K_x Updated (April 2012 for SAS 9.3)
This tagset extends the MSOffice2K tagset to add options. This tagset is another way to output data for Microsoft Excel.

SQL
This is a short-but-sweet SAS 9.1 tagset that generates SQL statements for creation of tables in an SQL database. It's a brute-force way of getting a data set into your database (SAS/CONNECT or SAS/SHARE being the best way, if you have access to one of those products). At the very least, it is an interesting source of ideas.

Super Map!
This new mapping tagset does almost everything you would want from a mapping tagset. It is all the other mapping tagsets in one. Control the events to be displayed, the attributes shown, and display events only if their values match a regular expression. All that and more. The SAS job includes some simple examples. For more information about mapping, exploring, and debugging tagsets, see the SUGI paper Tagset Spelunking and Cartography: Debugging and Exploring Tagsets with Battery-Powered Headlamps. Issue the following statement to see complete details of all the features:
ODS tagsets.supermap file="test.xml" options(doc="help")

tableeditor Updated (April 2012 for SAS 9.3)
Tableeditor.tpl creates HTML output with the same kind of functionality that you would get from Visual Basic .Net (VB.NET). You can easily export the output to Excel or other filetypes.

XBRL
This is a SAS 9.1 tagset that generates XBRL XML. It's not your normal run-of-the-mill tagset. See how to use it here. And if you're really curious, dig in and look at the tagset source.

XHTML, SYLK, Excel
Check out these customer-contributed tagsets, which make SAS output usable by Excel and other spreadsheet software.

Your Turn

The developers, testers and documentation folk that bring you ODS are very excited about the potential these capabilities bring to the SAS System. You can send electronic mail to ods@sas.com with your comments.