Pacific Northwest SAS Users Group 2007
Monday, 17 September, 2007
⨳ 2 minute read ⨳ 378 words ⨳ conference ⨳ sas ⨳ sas macro ⨳My submission was accepted for presentation at the 2007 conference of Pacific Northwest SAS Users Group in Seattle, WA. This was “Part I” of this paper; Part II was presented at SAS Global Forum 2008.
Here’s a local copy of the paper.
Here’s the abstract:
Recently, I was tasked with developing a SAS program to phase out tedious, error-prone process of transcribing a few key numbers from hundreds of item summary tables to a dozen one-page summary tables. To reduce end-user confusion, the revised reports needed to resemble the current layout and format as much as possible. Since the key statistics change across subgroups and span several item summary tables, a single tabulate or report procedure wouldn’t be sufficient. It appeared that traditional ODS reporting was out.
Other reporting methods were explored, specifically
DATA _NULL_
reporting which allows the dynamic use of variables—via macro variables—and provides the layout control that would be needed. Due to the monospace appearance of these reports, however,DATA _NULL_
reporting seemed to be out as well.Fortunately, ODS DATA Step Object’s ability to blend the layout control of
DATA _NULL_
reporting with the formatting control of traditional ODS would help save the day. with ODS DATA Step Object, SAS programmers can turn raw data into production quality reports ready for distribution. The ODS DATA Step Object is a powerful Base SAS feature that is available (in preproduction) as of version 9.1.3 and is able to generate production quality PDF reports directly since it provides SAS programmers simultaneous control over report layout and formatting.This is the first in a series of papers that will document the evolution from a reporting process that is currently only 10% SAS to one that approaches 100% SAS.
The code discussed in this paper was developed with SAS 9.1.3-SP4 running under Windows XP Professional-SP2. The code was developed specifically for the PDF destination, you may experience some nuances when applying these techniques to other destinations.
I remember going into a bar next to the hotel and ordering a pint Russian Imperial Stout. Somehow I managed to choke down about half an inch of it. I was not prepared for that.