Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SAS programing on Reports and Tables generating

Name: SAS programing on Reports and Tables generating
Rating: 4.7 (370 reviews)

Create reports and tables using Proc Report, SAS Proc Tabulate, SAS Proc Print and SAS ODS

Highest Rated

Created bySharon Cheng

Last updated 1/2025

English

What you'll learn

Produce Detail Reports with the PRINT Procedure: overview; create simple & enhanced reports; Customize a Report; easy change/update your reports with SAS Macro
Create Summary tables using Proc Tabulate
Create Detail and Summary Reports with Proc REPORT
Generate and Customize SAS Outputs Using the Output Delivery System (ODS)

Course content

6 sections • 52 lectures • 5h 47m total length

Course Overview5:28
Downloadable course materials1:26
Access downloadable course materials, including SAS programs, data files, and PowerPoint slides, as zip files in resources. Ignore prefixes of the file names and match them to lectures for practice.

Access free SAS software "SAS OnDemand for Academics" step by step instruction10:45
Learn how to access SAS OnDemand for Academics and start SAS Studio in the cloud, including profile creation and email verification.
Upload course data files and SAS programs into SAS ondemand for academics5:31
Learn to extract data and SAS codes from course zip files, upload them to SAS on demand, and organize files in a dedicated SAS base codes folder.
change file path/directory in SAS ondemand for academics6:37
examples: update and run SAS programs in SAS ondemand for academics6:57

Proc Print: Overview1:17
Proc Print: create simple reports8:29
Use proc print to generate reports from Excel import data, label or suppress observation column, emphasize a variable with id statement, and use proc sort and where statement to filter.
Proc Print: create enhanced reports10:07
Proc Print: continue on create enhanced reports8:43
Create enhanced SAS reports using proc print to compute multiple group subtotals by class and gender, after sorting data by those variables and applying the sum by statement.
Proc Print: Customize a Report8:24
Learn how to customize sas proc print reports by adding titles and footnotes, redefining column labels with split lines, and applying ods style options to headers and grand total row.
Proc Print: easy change/update your reports with SAS Macro3:34
Quiz

Proc Tabulate: Overview6:00
Proc Tabulate: One dimension table3:53
Proc Tabulate: Two dimension table3:27
Learn to generate a basic two dimensional summary table with proc tabulate in SAS, using gender as the row variable and score as the analysis variable, displaying the mean.
Proc Tabulate: Three dimension table4:48
Proc Tabulate: Create Multiple tables in one Proc Tabulate step5:37
Proc Tabulate: Cross Elements within one Dimension4:11
Proc Tabulate: Identify/Include Missing Values/Categories for Class Variables9:24
Identify missing values in class variables using proc tabulate with the missing option to create a missing category, and compare results with and without the option.
Proc Tabulate: format output tables3:43
Proc Tabulate: report on multiple statistics4:39
Proc Tabulate: Reduce Code and Apply a Single Label to Multiple Elements4:59
Proc Tabulate: Get Summaries for All Class Variables3:14
Master proc tabulate to summarize all class variables in a dimension with the universal class variable, using an average score as the analysis variable across rows and columns.
Proc Tabulate: Define Labels to make table more understandable3:34
Proc Tabulate: calculate Total percentages using default statistics11:40
Proc Tabulate: calculate Column percentages using default statistics7:51
Proc Tabulate: calculate Row percentages using default statistics6:50
Learn to compute row percentages in SAS proc tabulate using default statistics like n and rowpct (rw pct) with class variables and cross with gender, creating row and column summaries.
Proc Tabulate: calculate Page percentages using default statistics8:32
Learn to calculate page percentages in SAS proc tabulate using default statistics, across grade pages by class and gender, with n and page pct or page pct sum.
Proc Tabulate: calculate percentages using denominator definitions6:59
Quiz

Proc Report: Overview11:56
Explore proc report, an overview of a SAS tool blending print, means, and tabulate to produce detailed reports. Learn its syntax, column and define statements, compute blocks, and formatting.
Proc Report: Define Statement Usages: Display6:11
Proc Report: Define Statement Usages: Order & Group9:32
Explore proc report define statement usages order and group to sort by gender and group by class and gender, generating detail reports from the score data set.
Proc Report: Define Statement Usages: Analysis9:19
Proc Report: Define Analysis: create multiple stats on same var using Alias7:25
Proc Report: Define Analysis: create multiple stats on same var using Column3:48
Learn to use proc report to display six statistics for one variable by configuring column and define statements, grouping by class, with data imported from an Excel file into fr_zero.
Proc Report: Define Statement Usages: Across9:10
Proc Report: Break and Rbreak Statements6:50
Learn proc report in sas to create break statements and summary lines, control timing before or after groups or the report, and compute mean statistics for grouped data.
Proc Report: Compute Block: Compute Values and Generate Columns4:32
Proc Report: Compute Block: add text and change format6:43
Proc Report: Calculate Percentages6:01
Proc Report: handle missing values4:34
Explore proc report for handling missing values in SAS, comparing reports with and without the missing option, and learn to summarize scores by class and gender with custom styles.
Proc Report: create output data set5:17
Quiz

ODS overview with examples creating PDF, RTF, PowerPoint outputs11:21
Explore the ODS output delivery system to generate and reproduce SAS procedure and data step outputs in multiple formats, including pdf, rtf, html, epub, excel, and powerpoint.
ODS: Creating HTML Output with Options7:38
Use ods html to create html output with options, direct multiple procedures (proc print and proc means) to a single html file, specifying the full path and file name.
ODS: Creating HTML Output with a Table of Contents9:53
ODS: Changing the Appearance of HTML Output4:57
ODS: Creating Excel Output with multiple worksheets9:33
ODS: Selecting and Excluding Program Outputs7:27
ODS: Creating a SAS Data Set using ODS OUTPUT statement4:24
ODS: Customizing Outputs with Styles in Proc Print6:48
Customize SAS outputs by applying ODS styles and style templates in proc print, selecting style elements and attributes for headers, totals, and variables to adjust colors and fonts.
ODS: Customizing Outputs with Styles in Proc Tabulate9:10
ODS: Customizing Outputs with Styles in Proc Report8:27
Quiz

Requirements

know basic SAS programming skills, such as finishing my SAS programming for beginners or equivallent

Description

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 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 Structure

This course consists of four sections, covering essential SAS techniques for generating reports and tables:

Producing Detailed Reports with the PRINT Procedure
Creating Summary Tables Using PROC TABULATE
Generating Detailed & Summary Reports with PROC REPORT
Customizing SAS Outputs Using the Output Delivery System (ODS)

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!

References

SAS Certification Prep Guide: Base Programming for SAS 9
SAS 9.4 Output Delivery System: User's Guide, Fourth Edition
Base SAS 9.4 Procedures Guide, Sixth Edition
Step-by-Step Programming with Base SAS 9.4, Second Edition

Who this course is for:

Students and professionals who wants to generate high quality and presentable reports and be successful in their career
Students and professionals who wants to learn hignly demanded report generating skills using SAS

SAS programing on Reports and Tables generating

What you'll learn

Explore related topics

Course content

Course Overview and downloadable course materials2 lectures • 7min

Use the free web-based SAS studio "SAS OnDemand for Academics" with this course4 lectures • 30min

Produce Detail Reports with the PRINT Procedure6 lectures • 41min

Create Summary tables using Proc Tabulate17 lectures • 1hr 39min

Create Detail and Summary Reports with Proc REPORT13 lectures • 1hr 31min

Generate and Customize SAS Outputs Using the Output Delivery System (ODS)10 lectures • 1hr 20min

Requirements

Description

Who this course is for: