Base SAS

ODS Markup Papers and Presentations

This is a collection of papers and presentations given over the last few years by Eric Gebhart and others.

Using SAS Output Delivery System (ODS) Markup to Generate Custom PivotTable and PivotChart Reports

SAS Global Forum, 2010. This paper illustrates how to use ODS markup to create PivotTable and PivotChart reports.
The paper (.pdf)

ODS ExcelXP: Tag Attr Is It! Using and Understanding the TAGATTR= Style Attribute with the ExcelXP Tagset

SAS Global Forum, 2010. This paper shows how to use the TAGATTR= style attribute to control the ExcelXP tagset in order to change the type, format, formula rotation, hiding, merging, and wrapping of cells, rows, and columns. This paper also goes behind the scenes to show how the tagset handles these settings.
The paper (.pdf) | Example code (.zip)

ODS HTML Evolution, HTML that scrolls, panels, floats, Reads, and Integrates

SAS Global Forum, 2010. This paper and its examples show an HTML tagset that combines the features of several individual tagsets.
The paper (.pdf) | Example code (.zip)

Inline Formatting with ODS Markup

SAS Global Forum, 2009. Explore the power of inline formatting with ODS markup and ODS measured. With new and improved syntax, ODS inline formatting is better and more powerful.
The paper (.pdf) | Example code (.zip)

ODS Packages: Putting Some Zip in Your ODS Output

SAS Global Forum, 2009. You can attach a package template to a tagset with some tagset attributes. Then when you use that tagset, it automatically creates several output files which are automatically put into a ZIP file.
The paper (.pdf) | Example code (.zip)

ODS Markup, Tagsets, and Styles! Taming ODS Styles and Tagsets

SAS Global Forum, 2007. Learn about ODS, tagsets, and ODS styles from a new point of view. Styles and tagsets do not need to be difficult. It most cases they can be surprisingly simple. Techniques for using styles and style overrides in the reporting procedures can help with code readability and reuse. Real-world examples explore these techniques with the tagsets.Excelxp destination.
The paper (.pdf) | The slides (.pdf) | Example code (.zip)

ODS and Office Integration

SAS Global Forum, 2007. With so many ODS destinations available, it is increasingly important to know how the different file-formats integrate with external applications. Find out how easily you can create output in a multitude of file types: XML, SpreadsheetML, RTF, PDF, LaTeX, comma-separated values (CSV), Compact HyperText Markup Language (cHTML), HTML 4.0, and Extensible HyperText Markup Language (XHTML).
The paper (.pdf) | The slides (.pdf) | Example code (.zip)

PROC REPORT, the Right Tool for the Job

Hawaii SAS user group, 2006. This is PROC REPORT in a very condensed nutshell. Learn everything from basic syntax through compute blocks, breaks, and style overrides. It finishes with drill-down reports and a custom slider tagset.
The slides (.pdf) | Example code (.zip)

The Beginner's Guide to ODS MARKUP: Don't Panic!

SUGI 31, 2006. Learn how easy it is to create your output in a multitude of file types, from comma-separated values (CSV) to Compact HyperText Markup Language (cHTML), HTML 4.0, Extensible HyperText Markup Language (XHTML), LaTeX, and an endless variety of Extensible Markup Language (XML) flavors. ODS MARKUP can even create Microsoft Excel output.
The paper (.pdf) | The slides (.pdf) | Example code (.zip)

Teaching Your RTF Tagset to Do Clever Tricks

By Wayne Hester, Coder's Corner, SUGI 31, 2006. See the new RTF tagset that's in development for SAS 9.2.
The paper (.pdf) | SAS 9.2 example code (.zip)

ODS Tagsets & Excel, an Excellent Combination

SAS Presents, SUGI 30, 2005. See some nice example code for Tagsets.ExcelXP together with photos of Eric's favorite bike.
PowerPoint slides (.ppt) | Open Office SXI file (.sxi) | Example code (.zip)

ODS MARKUP: The SAS Reports You've Always Dreamed Of

SUGI 30, 2005. Out of your dreams and into SAS reports you long to fly/ MARKUP will come as evening comes to woo a waiting sky.
The paper (.pdf) | PowerPoint slides (.ppt) | Open Office SXI file (.sxi) | Example code (.zip)

Tagset Spelunking and Cartography: Debugging and Exploring Tagsets with Battery-Powered Headlamps

SUGI 30, 2005. This paper shines a considerable light into tagsets.
The paper (.pdf) | PowerPoint slides (.ppt) | Open Office SXI file (.sxi) | Example code (.zip)

ODS Markup and Tagsets, a Tutorial

This is a tutorial Eric has given for the last few years.
Short version (.ppt) | Long version (.ppt) | 2011 advanced version (.pdf) | 2011 advanced version movie (.mov)

Laying It Out with HTML Tagsets

SAS Presents, SUGI 29, 2004. View these slides to see how Eric spends his free time.
PowerPoint slides (.ppt) | Open Office SXI file (.sxi)

MARKUP: The Power of Choice and Change

SUGI 27, 2002. Everyone wants your data their way. With the ODS MARKUP destination, you can customize every detail of your output.
The paper (.pdf) | PowerPoint slides (.ppt) | Open Office SXI file (.sxi)

Your Turn

Send e-mail to ods@sas.com with your comments.

E-mail This Page

FOCUS AREAS