I have a passion for reporting – more specifically, a passion for reporting using SAS. For those of us who love developing reports, SAS 9.4 brings exciting news. Two powerful features, which have been available in some form for quite a while, are finally considered production: ODS LAYOUT and the Data Step Report Writing Interface. These open up a whole new world of flexible report design and development.
As the name implies, ODS LAYOUT allows you to “layout” the page for placement of multiple output objects. This means you can easily put tables, charts, graphs, and text all on the same page for a polished report look, with very little additional code. The output objects can be the results of any procedure or data step that produces output. With “gridded” LAYOUT you specify row and column information, and the output goes into those “cells.” In “absolute” LAYOUT you specify the actual size and location of regions on the page and the output that goes into those regions.
If you can’t get exactly what you want from PROC REPORT or TABULATE, the Report Writing Interface comes to the rescue. The Report Writing Interface is just a fancy way of saying you’re using the ODSOUT object in a data step. This object allows you to layout the page, create tables, embed images, add titles and footnotes and more – all from within a data step, using whatever data step logic you need. Also, all the style capabilities of ODS are available to you so that your data step created output can have fonts, sizes, colors, backgrounds and borders to make your report look just like you want.
This seminar will cover the basics of both of these new features. Examples will be based on “real-world” reports – the kind that makes people ask, “You did that report in SAS?” No longer do you have to tremble a bit when someone sends you a document or spreadsheet with their desired report mockup. Most likely, you’ll be able to meet their demands and maybe even improve on it.
- Resources Available
- ODS Layout
- What is it?
- Gridded Layout
- Absolute Layout
- Which Do I Use?
- Report Writing Interface
- Objects and Methods
- General Methods
- Table-related Methods
- Layout-related Methods
- “Real World” Examples
Intended Audience: Intermediate/Advanced levels
Delivery Method: Seminar
Course Material: Class notes and PowerPoint slides
SAS Products Discussed in the Course: Base SAS, SAS/Graph