SAS Programming Course on Generating Reports and Tables

Mastering Report & Table Generation in SAS

As a SAS programmer or data analyst, generating clear, professional reports and tables is essential for summarizing analytical results in a presentable and understandable manner. Whether you're preparing reports for senior management or creating easy-to-read tables for clients, this course is designed to help you efficiently complete these tasks using SAS.

Additionally, this course serves as a valuable resource for those preparing for the SAS Certified Clinical Trials Programmer Using SAS 9 certification exam.

Course Structure

This course consists of 6 hours of on-demand video lectures, covering essential SAS techniques for generating reports and tables:

1. Producing Detailed Reports with the PRINT Procedure

2. Creating Summary Tables Using PROC TABULATE

3. Generating Detailed & Summary Reports with PROC REPORT

4. Customizing SAS Outputs Using the Output Delivery System (ODS)

Course Highlights

• Certification Preparation
  This course is an excellent resource for preparing for the SAS Certified Clinical Trials Programmer Using SAS 9 exam, as clinical SAS programmers frequently create protocol-required tables and reports.

• Step-by-Step Code Explanations
  Each concept is explained line by line, ensuring clarity and ease of understanding.

• Downloadable Data & SAS Programs
  Gain access to practice datasets and SAS programs used in the course. (Note: These materials are copyrighted and strictly for practice purposes.)

• Interactive Quizzes
  Reinforce your learning with quizzes designed to test your knowledge.

SAS Software Requirements

This course was originally created using the SAS University Edition (downloadable SAS Studio version), which has since been replaced by SAS OnDemand for Academics, a free, web-based version of SAS Studio.

✅ Fully Compatible: This course works seamlessly with SAS OnDemand for Academics, as its interface, appearance, and functionality remain unchanged.

🔹 Setup Instructions: Detailed guidance on using SAS OnDemand for Academics is provided in Section 2 of this course.

Course Reviews and Ratings:

Your honest and thoughtful feedback is highly appreciated! Your ratings help improve course content and enhance your learning experience.

This course is regularly updated to reflect the latest SAS certification changes and incorporate student suggestions, ensuring it remains relevant and valuable. Fair and constructive reviews are essential to improving the course’s quality, and I truly appreciate your honest input. In this field, course ratings above 4.5 are widely regarded as indicators of high-quality content.

Thank you for your support!

Next, feel free to explore our full course content with detailed lecture breakdowns, watch lecture previews on YouTube, visit our course pages for more information, and browse our complete course catalog, featuring both FREE course and premium courses with flexible pricing plans. 

Course Contents

Section: Produce Detail Reports with the PRINT Procedure

• Proc Print: Overview

• Proc Print: create simple reports

• Proc Print: create enhanced reports

• Proc Print: continue on create enhanced reports

• Proc Print: Customize a Report

• Proc Print: easy change/update your reports with SAS Macro

• Quiz

Section: Create Summary tables using Proc Tabulate

• Proc Tabulate: Overview

• Proc Tabulate: One dimension table

• Proc Tabulate: Two dimension table

• Proc Tabulate: Three dimension table

• Proc Tabulate: Create Multiple tables in one Proc Tabulate step

• Proc Tabulate: Cross Elements within one Dimension

• Proc Tabulate: Identify/Include Missing Values/Categories for Class Variables

• Proc Tabulate: format output tables

• Proc Tabulate: report on multiple statistics

• Proc Tabulate: Reduce Code and Apply a Single Label to Multiple Elements

• Proc Tabulate: Get Summaries for All Class Variable

• Proc Tabulate: Define Labels to make table more understandable

• Proc Tabulate: calculate Total percentages using default statistics

• Proc Tabulate: calculate Column percentages using default statistics

• Proc Tabulate: calculate Row percentages using default statistics

• Proc Tabulate: calculate Page percentages using default statistics

• Proc Tabulate: calculate percentages using denominator definitions

• Quiz

Section: Create Detail and Summary Reports with Proc REPORT

• Proc Report: Overview

• Proc Report: Define Statement Usages: Display

• Proc Report: Define Statement Usages: Order & Group

• Proc Report: Define Statement Usages: Analysis

• Proc Report: Define Analysis: create multiple stats on same var using Alias

• Proc Report: Define Analysis: create multiple stats on same var using Column

• Proc Report: Define Statement Usages: Across

• Proc Report: Break and Rbreak Statements

• Proc Report: Compute Block: Compute Values and Generate Columns

• Proc Report: Compute Block: add text and change format

• Proc Report: Calculate Percentages

• Proc Report: handle missing values

• Proc Report: create output data set

• Quiz

Section: Generate and Customize SAS Outputs Using the Output Delivery System (ODS)

• ODS overview with examples creating PDF, RTF, PowerPoint outputs

• ODS: Creating HTML Output with Options

• ODS: Creating HTML Output with a Table of Contents

• ODS: Changing the Appearance of HTML Output

• ODS: Creating Excel Output with multiple worksheets

• ODS: Selecting and Excluding Program Outputs

• ODS: Creating a SAS Data Set using ODS OUTPUT statement

• ODS: Customizing Outputs with Styles in Proc Print

• ODS: Customizing Outputs with Styles in Proc Tabulate

• ODS: Customizing Outputs with Styles in Proc Report

• Quiz