• Online, Self-Paced
Course Description

Creating reports, visualization, and charts from your data adds immediate impact, and can allow your audience to glean information quickly and effectively. This course covers reporting in SAS, and how to create impactful graphics. It is one of a series that prepares you for the SAS certification exam, SAS Certified Base Programmer for SAS 9.

Learning Objectives

Reports

  • start the course
  • create a basic report in SAS
  • create an enhanced report using SAS system options, and by adding titles and footnotes
  • add column headings to a report using LABEL statements
  • create formatted output by using the FORMAT statement
  • use the FORMAT procedure to create user-defined formats, and apply them to variables in reports
  • use the WHERE and BY statements to subset and group a report
  • use ODS statements to direct output to various ODS destinations
  • specify a style definition using a STYLE= option in the ODS destination statement in SAS

Summary Reports

  • use the FREQ procedure to create one-way and two-way frequency tables in SAS
  • use various options to enhance frequency tables in SAS
  • use the MEANS procedure to create summary statistics and multilevel summaries in SAS
  • use the SUMMARY procedure to create summaries in SAS
  • use various options to enhance summary tables in SAS
  • use the TABULATE procedure to create one-dimensional, two-dimensional, and three-dimensional tabular reports
  • use the OUT= option in the TABULATE procedure to produce output data sets

Graphics

  • describe the capabilities of the SAS/GRAPH statistical graphics procedures
  • create pie charts using the SAS/GRAPH statistical graphics procedures
  • create bar charts using the SAS/GRAPH statistical graphics procedures
  • create histogram charts SAS/GRAPH statistical graphics procedures
  • create scatter plots using SAS/GRAPH statistical graphics procedures

Practice: Reports and Charts

  • create and chart a summary report and a frequency table in SAS

Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration