About This Book

Purpose

Personally, I learn best through experience and working through real programming examples. I wrote this book to provide PROC REPORT users with step-by-step instructions for turning data sets into final reports. The examples provide solutions to common programming challenges that are encountered during the production of various types of reports.

Is This Book for You?

This book is for PROC REPORT users who want to learn more about PROC REPORT and ODS features by working through examples. Each chapter demonstrates how to produce a different type of report. The book is applicable to SAS users from all disciplines.

Prerequisites

SAS programmers that are familiar with BASE SAS, basic SAS procedure syntax and logic, and have some familiarity with PROC REPORT are likely to benefit most from this book.

About the Examples

Software Used to Develop the Book's Content

This book was written using the following operating system and products:

Example Code and Data

Visit the author’s page at http://support.sas.com/publishing/authors/fine.html to access the data and programs used in this book.

The following table describes the Program Name(s) and Data Set Name(s) that correspond to each chapter.

For SAS 9.1.3 Users

This book was written based on SAS 9.3. The author’s page at http://support.sas.com/publishing/authors/fine.html provides some SAS 9.1.3 code workarounds for the chapter examples that use SAS 9.2 features. For the SAS 9.1.3 user who wants to learn more about what’s new in SAS 9.2, the following list summarizes key SAS 9.2 enhancements that are relevant to this book:

SAS 9.2 Key Enhancements Relevant to Book

• PROC TEMPLATE is simplified

• A new PROC REPORT feature, SPANROWS, is introduced

• A new output delivery system, ODS.TAGSETS.RTF is introduced (provides Continued note and Watermark options)

• New BORDER Control elements and additional style control with the TEXTDECORATION style element

• PDFTOC (ability to collapse a PDF table of contents)

• The Unicode inline style function allows direct insertion of Unicode characters

• Allowable character length is increased

The author suggests the following references for a summary of what is new in SAS 9.2.

Booth, Allison McMahill. 2011. “Beyond the Basics: Advanced REPORT Procedure Tips and Tricks Updated for SAS® 9.2.” Proceedings of the 2011 SAS Global Forum - Paper 246-2011, Cary, NC: SAS Institute Inc. Available at http://support.sas.com/resources/papers/proceedings11/246-2011.pdf

Huntley, Scott. 2006. “Let the ODS PRINTER Statement Take Your Output into the Twenty-First Century.” Proceedings of the 31st Annual SAS Users Group International Conference - Paper 227-31. Cary, NC: SAS Institute Inc. Available at http://www2.sas.com/proceedings/sugi31/227-31.pdf.

SAS Institute Inc. 2009. KNOWLEDGE BASE / SAMPLES & SAS NOTES. “Usage Note 15883: Length limitations when submitting SAS code.” Cary, NC: SAS Institute Inc., Available at http://support.sas.com/kb/15/883.html.

SAS Institute Inc. 2013. KNOWLEDGE BASE FOCUS AREAS. “Base SAS Enhancements to ODS RTF for SAS 9.2.” Cary, NC: SAS Institute Inc., Available at http://support.sas.com/rnd/base/new92/92rtf.html.

SAS Institute Inc. 2013. KNOWLEDGE BASE / SAMPLES & SAS NOTES. “Sample 49590: Insert special symbols as a table value in ODS MARKUP destinations.” Cary, NC: SAS Institute Inc., Available at http://support.sas.com/kb/49/590.html.

Smith, Kevin D. 2006. “The TEMPLATE Procedure Styles: Evolution and Revolution.” Proceedings of the 31st Annual SAS Users Group International Conference - Paper 053-31. Cary, NC: SAS Institute Inc. Available at http://www2.sas.com/proceedings/sugi31/053-31.pdf.

For an alphabetical listing of all books for which example code and data is available, see http://support.sas.com/bookcode. Select a title to display the book’s example code.

If you are unable to access the code through the website, send an e-mail to [email protected].

Output and Graphics

Each chapter discusses how the output and graphics were created for each specific example.

While much of the output and graphics were created in color, the printed SAS book version displays images in black and white. Color images are available from the author’s web page at http://support.sas.com/publishing/authors/fine.html. The e-book version is available in color.

Additional Resources

SAS offers you a rich variety of resources to help build your SAS skills to explore and apply the full power of SAS software. Whether you are in a professional or academic setting, we have learning products that can help you maximize your investment in SAS.

Or

Keep in Touch

We look forward to hearing from you. We invite questions, comments, and concerns. If you want to contact us about a specific book, please include the book title in your correspondence.

To Contact the Author Through SAS Press

By e-mail: [email protected]

Via the Web: http://support.sas.com/author_feedback

SAS Books

For a complete list of books available through SAS, visit http://support.sas.com/bookstore.

Phone: 1-800-727-3228

Fax: 1-919-677-8166

E-mail: [email protected]

SAS Book Report

Receive up-to-date information about all new SAS publications via e-mail by subscribing to the SAS Book Report monthly eNewsletter. Visit http://support.sas.com/sbr.