Course Highlights:

• 6.5 hours 49 video-formatted lectures

• This course can help prepare you for the following certification exam: SAS Certified Clinical Trials Programmer Using SAS 9

• step by step/ code by code explanations

• downloadable data and SASprograms used in the course (the course materials are ONLYfor practice, they are protected by copyright)

• Quizzes

• Please be considerate and sincere when you provide ratings. This will encourage me providing more contents to the course and better service to you!

Course Description:

As a SAS programmer/data analyst at any level, you need to generate reports and tables to summarize your analytical results in a presentable and understandable way. Sometimes you are required to present a report to senior managements, other times you need to present a table in an easy-to-understand way to the clients. This course is designed to help you fulfill your daily report and table generating tasks using SAS. This course can also help prepare you for the following certification exam: SAS Certified Clinical Trials Programmer Using SAS 9.

Course includes 4 sections: 6.5 hours and 49 video-formatted lectures

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

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 Variables

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

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

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

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(R) 9.4, Second Edition

Note: The course was created with SAS softwarelicensefor the SAS University Edition (the downloadable SASstudio version).

The course is also suitable to use with SASOnDemand for Academics (the web-based SASstudio version).

The software interface/appearance and functionalities in the two SAS studio versions are the same.

Section 2 has all the details for using SASOnDemand for Academics with this courses.