Contents

About This Book

About The Author

Acknowledgements

Chapter 1: Introduction

Chapter 2: General Tips

Controlling Your ODS Output

The ODS Sandwich

Always Use ODS CLOSE

Closing All ODS Destinations at Once

Interleaving ODS Destinations

Running Multiple Instances of One Destination

Displaying Output Object Information

Selecting and Excluding Output Objects

Suspending an ODS Destination

Querying Open ODS Destination Information

Creating Output Data Sets

Using ODS Inline Functions and Formatting

Inserting Special Characters

Generating Output Using Internet Services

Emailing Output

Sending Output to an FTP Server

The ODS Path Macro Variable

Setting the Default Path for Output Files

Exporting ODS Output as “Character” Separated Values

Chapter 3: Table and Text Tips

Procedure-specific Table Features

Creating One-Shot Tables

Controlling Blank Lines in PROC PRINT

Creating Spanned Rows in PROC REPORT

Preventing Cell Merging in PROC TABULATE

Creating Tables with DATA _NULL_

Styling All Template-Based Tables at Once

Ad Hoc Tables with the Report Writing Interface

Generating Bulleted Lists and Blocks of Text

Creating Bulleted Lists

Creating Nested Lists

Creating Blocks of Text

Chapter 4: Style Tips

Getting Started with the Basics

Generating Samples of All Styles

Creating a Simple Style

Creating a Simple CSS Style

Determining the Correct Style Element to Use

Dealing with Borders and Padding

Using CELLPADDING Versus PADDING

What Are BORDERSPACING and BORDERCOLLAPSE?

Controlling Borders Individually

Alternating Table Row Colors

Using RGBA Colors

Advanced Traffic Lighting Functions

Using CSS

Referencing CSS Styles

Importing CSS from CSS

Style Selection Based on Media Types in CSS

CSS Color Models

Displaying ODS’s Document Object Model

Setting a Global Font for the Printer Destinations in CSS

Using IDs in CSS

BY Group Styling in CSS

Chapter 5: HTML Tips

HTML3 vs HTML4 vs HTML5

ODS HTML 3

ODS HTML 4

ODS HTML 5

Cascading Style Sheet Tips

Generating an External CSS File

Specifying Your Own CSS File

Specifying Multiple CSS Files

Setting the Document Title

Creating Document Fragments

Inserting Arbitrary Markup in the Document Preamble

Using External Resources

Utilizing Web Fonts

Linking to Your Own Custom JavaScript

Change the Image Format Used by Graphs

Background Effects

Using a Background Image on a Table

Using Gradients Backgrounds

Preserving White Space

ODS HTML5 Techniques

Turning Off Inline SVGs

Inlining Bitmapped Images

Inline All Style Attributes

Chapter 6: Printer Tips

Multicolumn Output without Layout

Page Breaks and Orientation

Changing Page Orientation

Controlling Page Breaks

Styles in ODS PDF

Using CSS-based Styles

Installing Custom Fonts

Adding Background Images and Watermark Effects

Creating Bitmaps of Tables

Adding Metadata to Your PDF Documents

Creating Secured PDF Documents

Specifying the Initial PDF Page View

Chapter 7: Excel Tips

Comparing ODS Excel Formats

TAGSETS.EXCELXP

TAGSETS.MSOFFICE2K

HTML

TAGSETS.CSV

Displaying Help

Using Excel Formats

Preserving Leading Zeros

Alternate Solution

TAGSETS.EXCELXP Tips

Using Excel Formulas in TAGSETS.EXCELXP

Controlling Worksheet Names Manually

Using BY Group Information in Worksheet Names

Using Graphical Output in Excel

Preventing Cell Merging in PROC TABULATE

More Excel Tagsets Online

Chapter 8: ODS Document Tips

Customizing Your Report Structure

Creating a Completely Custom Table of Contents

Recording Actions in the Documents Window

Using Links to Create Custom Tables of Contents

Using Links to Create Aggregate Reports

Using WHERE Clauses in Documents

Templates and Dynamic Variables

Display the Template Used by an Object in a Document

Displaying Dynamic Variables Used by an Output Object

Swapping Templates during Replay

Accessing the Data in Document Output Objects Directly

Inserting Plain Text Objects into a Document

Operating on a Document Using CALL EXECUTE

Index