SAS Institute. The Power to Know

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 on this page.

ODS MARKUP Statement
Read this reference to the ODS MARKUP statement in the SAS online documentation.

Just the tagsets
If you want to skip the documentation and go straight to the tagset templates, here are the most up-to-date tagsets for each version of SAS listed. These files are the original source, complete with comments, white space, and nice formatting.
TEMPLATE Procedure: Creating Markup Language Tagsets
This is an introduction and reference to the tagset language in the SAS online documentation. You can also download a zip file of examples.

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.

Updated SAS 9.1 Tagsets to Download Individually

CSV, CSVALL, CSVBYLINE (April 2006)
This May 2005 update to the SAS 9.1.3 tagset has enhanced features and performance over the released version. New to this tagset is a fix for some problems caused by a specific form of Proc Tabulate. Another fix has to do with treating currency as numbers or character strings. 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 New update! April 2008 (version 1.86, 04/15/08)
See the quick reference to options and change log for the tagset.

This new update to the SAS 9.1.3 tagset has enhanced features and performance over the released version. This new version has too many new features to list! Some highlights include better column widths and spacing control, control over many print options, generation of a table of contents or an index of worksheets, and worksheet intervals that break on bygroups. Output from the ExcelXP tagset also works with 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.

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 New update! (March 2008)
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.