Audience

This course is designed for both DP and non-DP users who have some experience with SAS and want a more in depth understanding of PROC REPORT.

Duration

1 day

Abstract

SAS software can be used to solve a broad range of data processing problems including generating reports. The Introduction to PROC Report class is designed to give students the background they need to create reports using this powerful report writing tool. This course will deal specifically with PROC Report in a batch environment, not as an interactive programming tool.

Objectives

• Learn how to create and modify reports
• Change the order of data in reports using the ORDER= option and the ORDER usage option
• Improve the appearance of the default reports using LABELs and FORMATs
• Learn how to aggregate data using the GROUP usage option
• Compute new variables in the report using COMPUTE blocks
• Learn how to control information on the report using the FLOW and PANEL= options
• Create sub- and grand totals on the report using the BREAK and RBREAK statements
• Create customized sub- and grand totals on the reports using the COMPUTE blocks
• Create grouped or stacked columns using the ACROSS usage option
• Learn how to calculate various types of percentages on your reports usingCOMPUTE blocks

Outline

• Overview of the SAS System
• Introduction to PROC REPORT
• ORDERing data
• Aggregating data
• Creating new variables
• PROC REPORT options
• Sub- and grand totaling data
• Customized report breaks
• Group or stacked column headings
• Calculating percentages
• Additional PROC REPORT features