O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The SAS Programmer's PROC REPORT Handbook

Book Description

Generate reports with style! The SAS Programmer's PROC REPORT Handbook: ODS Companion explains how to use style elements within a style template to customize reports generated by PROC REPORT, leading to more appealing and effective business reports.

Many programmers are faced with generating reports that are easy to read and comprehend for a wide variety of audiences, which is where the ODS destinations and style changes come into play. This book teaches you how to use style elements in PROC REPORT, a versatile reporting procedure, to customize your output. Mastering style elements allows you to change visual aspects of reports, such as borders, column widths, fonts, backgrounds, and more. This companion to The SAS Programmer’s PROC REPORT Handbook: Basic to Advanced Reporting Techniques explores how the style elements within a style template affect the output generated by PROC REPORT. It provides examples of altering the style elements and the effect on the main ODS destinations, while also discussing common pitfalls that programmers can avoid while working with tables, Microsoft Excel, Microsoft Power Point, and PDF output.

Table of Contents

  1. About this Book
  2. About the Author
  3. Preface
  4. Chapter 1 Introduction: Overview of Chapters
  5. Chapter 2 PROC TEMPLATE Overview
    1. 2.1 Introduction
    2. 2.2 Default Style Templates
    3. 2.3 Location of Style Templates
    4. 2.4 Viewing Style Templates
    5. 2.5 General Syntax of PROC TEMPLATE
    6. 2.6 STYLE versus CLASS Statements
    7. 2.7 Inheritance
    8. 2.8 Style Attributes
    9. 2.9 Key Takeaways
  6. Chapter 3 Style Elements
    1. 3.1 Introduction
    2. 3.2 Style Elements Used by PROC REPORT
    3. 3.3 Setup for Chapter Examples
    4. 3.4 Plain Output Generated without Attribute Changes
    5. 3.5 Header Style Element Changes
    6. 3.6 LineContent Style Element Changes
    7. 3.7 DataEmphasis Style Element Changes
    8. 3.8 Data Style Element Changes
    9. 3.9 Table Style Element Changes
    10. 3.10 Other Style Elements
    11. 3.11 Key Takeaways
  7. Chapter 4 Style Overrides within PROC REPORT
    1. 4.1 Introduction
    2. 4.2 STYLE= Default Locations and Order of Precedence
    3. 4.3 STYLE= in PROC REPORT Statement
    4. 4.4 STYLE= in DEFINE Statement
      1. 4.4.1 Using CELLWIDTH= Style Attribute
      2. 4.4.2 Applying Trafficlighting
      3. 4.4.3 Using Multiple Locations in the Same DEFINE Statement
    5. 4.5 STYLE= in BREAK and RBREAK Statements
    6. 4.6 STYLE= in COMPUTE Statement
    7. 4.7 CALL DEFINE STATEMENT
    8. 4.8 Key Takeaways
  8. Chapter 5 PDF Destination
    1. 5.1 Introduction
    2. 5.2 Style Templates with ODS PDF
    3. 5.3 Border Manipulation
      1. 5.3.1 Manipulate Borders Already in the Table
      2. 5.3.2 Insert New Borders
      3. 5.3.3 Border Width Values
    4. 5.4 Paging
    5. 5.5 PROC REPORT SPANROWS Option
    6. 5.6 Accessibility
    7. 5.7 Key Takeaways
  9. Chapter 6 RTF and Tagsets.RTF Destinations
    1. 6.1 Introduction
    2. 6.2 Differences between the RTF and Tagsets.RTF Destinations
      1. 6.2.1 Titles and Footnotes
      2. 6.2.2 CONTINUED Text
      3. 6.2.3 Watermark Text
    3. 6.3 Effect of Style Element Changes in Tagsets.RTF
      1. 6.3.1 Header Style Element Changes
      2. 6.3.2 LineContent Style Element Changes
      3. 6.3.3 DataEmphasis Style Element Changes
      4. 6.3.4 Data Element Style Changes
      5. 6.3.5 Table Element Style Changes
      6. 6.3.6 Container Element Style Changes
    4. 6.4 Table Bottom Border
    5. 6.5 Tagsets.RTF Options That Affect PROC REPORT
      1. 6.5.1 TABLEROWS
      2. 6.5.2 VSPACE
    6. 6.6 PROC REPORT SPANROWS Option
    7. 6.7 Raw RTF Commands
    8. 6.8 Key Takeaways
  10. Chapter 7 Excel Destinations
    1. 7.1 Introduction
    2. 7.2 ODS Destination for Excel
      1. 7.2.1 Column Widths
      2. 7.2.2 Row Heights
      3. 7.2.3 Hidden Rows
      4. 7.2.4 FROZEN_ROWHEADERS Suboption
      5. 7.2.5 Border Manipulation
      6. 7.2.6 Customized Text Summary Row
      7. 7.2.7 Leading Zeros for Character Variables
      8. 7.2.8 Style Attributes for Images
      9. 7.2.9 PROC REPORT-Triggered Worksheets
    3. 7.3 Tagsets.ExcelXP
      1. 7.3.1 Default Style
      2. 7.3.2 Hidden Rows
      3. 7.3.3 Border Manipulation
      4. 7.3.4 Leading Zeros for Character Variables
    4. 7.4 HTML, MSOffice2K, and MSOffice2K_X
      1. 7.4.1 Default Style
      2. 7.4.2 Hidden Rows
      3. 7.4.3 Border Manipulation
      4. 7.4.4 Customized Text for Summary Row
      5. 7.4.5 Excel-specific Formats
      6. 7.4.6 Style Attributes for Images
    5. 7.5 Background Color in the Headers
    6. 7.6 Date Values
    7. 7.7 Key Takeaways
  11. Chapter 8 HTML and HTML5 Destinations
    1. 8.1 Introduction
    2. 8.2 Style Differences between the HTML and HTML5 Destinations
      1. 8.2.1 Header Style Element Changes
      2. 8.2.2 LineContent Style Element Changes
      3. 8.2.3 DataEmphasis Style Element Changes
      4. 8.2.4 Data Element Style Changes
      5. 8.2.5 Table Element Style Changes
      6. 8.2.6 Container Element Style Changes
    3. 8.3 Borders
    4. 8.4 Hyperlinks
    5. 8.5 Images
    6. 8.6 Accessibility
    7. 8.7 Key Takeaways
  12. Chapter 9 ODS Destination for PowerPoint
    1. 9.1 Introduction
    2. 9.2 PowerPointLight and PowerPointDark Style Templates
    3. 9.3 Style Template Changes
    4. 9.4 Effects of Tables with Large Amounts of Data
      1. 9.4.1 Many Columns of Data
      2. 9.4.2 Many Columns and Rows of Data
      3. 9.4.3 Many Header Rows
    5. 9.5 Inline Formating Functions
    6. 9.6 Style Attributes for Images
    7. 9.7 Key Takeaways
  13. ODS Resources
  14. Index