SAS Overview

Course: 27 Minutes

• Course Introduction
• SAS Overview
• SAS Environments
• Obtaining and Installing a SAS environment
• SAS Interfaces
• Introducing SAS Programs
• Submitting a Program

SAS Studio

Course: 52 Minutes

• SAS Studio Overview
• SAS Studio Interface Elements
• SAS Studio Navigation Pane
• SAS Studio Code Tab
• SAS Studio Log Tab
• SAS Studio Results Tab
• SAS Studio Autocomplete
• Working with Tasks
• Working with Libraries

Practice: SAS Basics

Course: 3 Minutes

• Exercise: Running an SAS Program

SAS Data Sets

Course: 25 Minutes

• Course Introduction
• Data Set Descriptors
• Printing a Data Set
• Data Library Overview
• Using Data Libraries
• Assigning a Libref to a Relational Database
• Connecting to a Relational Database Source

Reading Data Sets

Course: 29 Minutes

• SAS Data Sources
• Using the DATA Statement to Create a Data Step
• Using the SET Statement for Data Step Processing
• Using the WHERE Statement to Subset Observations
• Using the DROP and KEEP Statements
• Adding Labels Using the LABEL Statement
• Adding Formats Using the FORMAT Statement

Reading from Excel

Course: 23 Minutes

• Creating a Data Set from an Excel Sheet
• Reading from an Excel Sheet
• Using the PROC Step to Create an Excel Sheet
• Using the ODS to Create an Excel Sheet
• Using the IMPORT Wizard with Excel
• Using the EXPORT Wizard with Excel

Reading Text Files

Course: 34 Minutes

• Creating a Data Set from a Delimited File
• Using the LENGTH Statement
• Reading Nonstandard Data with Informats
• Processing Nonstandard Data in the DATA Step
• Using the List Input DSD Option
• Using the MISSOVER Option

Practice: Work with Data

Course: 9 Minutes

• Exercise: Reading Data

Data Errors

Course: 18 Minutes

• Course Introduction
• Data Errors in Raw Data
• Validating and Cleaning Data
• Examining Data Errors
• Handling Data Errors

Data Validation and Cleaning

Course: 24 Minutes

• Validating Data Using PRINT and WHERE
• Validating Data Using FREQ and TABLES
• Validating Data Using MEANS and VAR
• Validating Data Using UNIVARIATE and VAR
• Cleaning Data At the Source
• Cleaning Data Using Assignment Statements
• Cleaning Data Using Conditionals in the DATA Step

Data Manipulation

Course: 22 Minutes

• Creating Variables with DATA Step Assignments
• Creating Values Using Operators and SAS Functions
• Executing Statements Conditionally
• Using the ELSE Statement in a Conditional
• Using IF and WHERE to Subset Observations
• Using IF-THEN DELETE to Subset Observations

Combining Data Sets

Course: 34 Minutes

• Combining SAS Data Sets
• Using APPEND to Combine Data Sets
• Using the FORCE Option to an APPEND Procedure
• Using SET in a DATA Step to Concatenate Data Sets
• Using RENAME to Change Variable Names
• Merging Data Sets One-To-One
• Merging Data Sets One-To-Many
• Merging Data Sets with Nonmatches

Practice: Validate, Clean, and Combine Data

Course: 9 Minutes

• Exercise: Validating, Cleaning, and Combining Data

Reports

Course: 40 Minutes

• Course Introduction
• Producing a Basic Report
• Producing an Enhanced Report in SAS
• Using the LABEL Statement to Add Column Headings
• Formatting Values Using the FORMAT Statement
• Creating and Applying User-defined Formats
• Subsetting and Grouping Reports Using WHERE and BY
• Directing Output Using ODS Statements
• Specifying Styles in an ODS Statement

Summary Reports

Course: 28 Minutes

• Creating Frequency Tables with the FREQ Procedure
• Creating Enhanced Frequency Tables
• Creating Summary Tables with the MEANS Procedure
• Creating Summary Tables with the SUMMARY Procedure
• Creating Enhanced Summary Tables
• Creating Tabular Reports with the TABULATE Procedure
• Creating Output Data Sets Using the OUT= Option

Graphics

Course: 21 Minutes

• Overview of SAS/GRAPH SG Procedures
• Creating Pie Charts with SAS/GRAPH SG Procedures
• Creating Bar Charts with SAS/GRAPH SG Procedures
• Creating Histograms with SAS/GRAPH SG Procedures
• Producing Scatter Plots with SAS/GRAPH SG Procedures

Practice: Reports and Charts

Course: 4 Minutes

• Exercise: Creating Reports and Charts

Input and Output

Course: 24 Minutes

• Course Introduction
• Outputting Multiple Observations
• Writing to Multiple SAS Data Sets
• Controlling Variable Input and Output
• Controlling Observation Input and Output

Data Summarization

Course: 16 Minutes

• Creating an Accumulating Variable Using RETAIN
• Creating an Accumulating Variable Using SUM
• Summarizing Data by Groups
• Summarizing Data by Multiple Groups

Read Raw Data

Course: 26 Minutes

• Using Column Input
• Using Formatted Input
• Creating a Single Observation from Multiple Records
• Controlling When a Record Loads
• Reading Raw Data with Missing Values

Data Transformation

Course: 45 Minutes

• Using SAS Functions
• Extracting and Transforming Character Values
• Separating and Concatenating Character Values
• Finding and Modifying Character Values
• Using Descriptive Statistics Functions
• Truncating Numeric Values
• Converting Values Between Data Types

Debugging

Course: 10 Minutes

• Debugging with PUTLOG
• Debugging Logic Errors

Practice: Data Manipulation

Course: 5 Minutes

• Exercise: Manipulating Data

Iterative DO Loops

Course: 21 Minutes

• Course Introduction
• Creating a Simple DO Loop
• DO WHILE Loops
• DO UNTIL Loops
• Nesting DO Loops
• Using a DO Loop to Reduce Redundant Code

SAS Arrays

Course: 25 Minutes

• SAS Array Overview
• Creating a SAS Array
• Processing a SAS Array
• Using SAS Arrays to Create Variables
• Using SAS Arrays to Perform Calculations
• Assigning Initial Values to an Array

Restructuring and Combining Data Sets

Course: 29 Minutes

• Using the TRANSPOSE Procedure to Manipulate Data
• Rotating a Data Set with the TRANSPOSE
• Match-Merging SAS Data Sets
• Manipulations with a Match-Merge
• Match-Merging Data Sets that Lack a Common Variable
• Match-Merging a SAS Data Set and an Excel Workbook
• Match-Merging Data Sets with Same-named Variables

Proc SQL

Course: 12 Minutes

• Proc SQL Overview
• Querying with Proc SQL
• Joining Tables with Proc SQL

Practice: Array Processing & Merges

Course: 6 Minutes

• Exercise: Processing an Array & Merging Data Sets