SAS Institute Of Management Studies - Getting Started with SAS Programming 

Welcome to the Course!

Demo: Programming in SAS

Practicing in This Course

Learner Prerequisites

Using Forums and Getting Help

Access SAS Software and Set Up Practice Files (REQUIRED)

Overview

SAS Programming Interfaces

Demo: Programming with SAS Studio

SAS Program Structure

SAS Program Syntax

Demo: Understanding SAS Program Syntax

Demo: Finding and Resolving Syntax Errors

Practice Using SAS Studio

Syntax Review

Activity 1.01

Activity 1.02

Essentials

Overview

Types of Data

What is a SAS Table?

Required Column Attributes for SAS Tables

Listing Table and Column Attributes

Accessing Data in a Program

Using a Library to Read SAS Data

Automatic SAS Libraries

Demo: Exploring Automatic SAS Libraries

Using a Library to Read Other File Types

Demo: Using a Library to Read Excel Files

Importing Unstructured Data

Demo: Importing a Comma-Delimited (CSV) File

Importing an Excel File

Syntax Review

Question 2.01

Activity 2.02

Activity 2.03

Activity 2.04: Create a Library for This Course (Required)

Activity 2.05

Activity 2.06

Level 1 Practice: Importing Excel Data from a Single Worksheet

Level 2 Practice: Importing Data from a CSV File

Accessing Data

Overview

Exploring Data with Procedures

Demo: Exploring Data with SAS Procedures

Filtering Rows with the WHERE Statement

Combining Expressions in a WHERE Statement

Demo: Filtering Rows with Basic Operators

Using Special WHERE Operators

Creating and Using Macro Variables

Demo: Filtering Rows Using Macro Variables

Formatting Data Values in Results

Common Formats for Numeric Values

Common Formats for Date Values

Demo: Formatting Data Values in Results

Sorting Data

Identifying and Removing Duplicates

Demo: Identifying and Removing Duplicate Values

Syntax Review

Activity 3.01

Level 1 Practice: Exploring Data with Procedures

Level 2 Practice: Using Procedures to Validate Data

Activity 3.02

Activity 3.03

Level 1 Practice: Filtering Rows in a Listing Report Using Character Data

Level 2 Practice: Using Macro Variables to Subset Data in Procedures

Activity 3.04

Activity 3.05

Activity 3.06

Level 1 Practice: Sorting Data and Creating an Output Table

Level 2 Practice: Sorting Data to Remove Duplicate Rows

Exploring and Validating Data

Overview

Using the DATA Step to Create a SAS Data Set

DATA Step Processing

Demo: Working with the DATA Step

Demo: Using Expressions to Create New Columns

Using Numeric Functions to Create Columns

Demo: Using Character Functions

Demo: Using Date Functions

Demo: Conditional Processing with IF-THEN

Conditional Processing with IF-THEN/ELSE

Creating Character Columns with the LENGTH Statement

Processing Multiple Statements with IF-THEN/DO

Demo: Processing Multiple Statements with IF-THEN/DO

Common Summary Functions for Creating Columns

Common Character Functions for Creating Columns

Common Date Functions for Creating Columns

Syntax Review

Question 4.01

Question 4.02

Activity 4.03

Level 1 Practice: Creating a SAS Table

Level 2 Practice: Subsetting by Multiple Conditions and Creating a Sorted SAS Table

Activity 4.04

Activity 4.05

Activity 4.06

Level 1 Practice: Creating New Columns

Level 2 Practice: Creating New Columns with Character and Date Functions

Activity 4.07

Activity 4.08

Activity 4.09

Level 1 Practice: Processing Statements with IF-THEN/ELSE

Level 2 Practice: Processing Statements Conditionally with DO Groups

Preparing Data

Overview

Using Titles and Footnotes

Using Macro Variables and Functions in Titles and Footnotes

Applying Temporary Labels to Columns

Segmenting Reports

Demo: Enhancing Reports

Applying Permanent Labels to Columns

Demo: Creating Frequency Reports and Graphs

Demo: Creating Two-Way Frequency Reports

Demo: Creating a Summary Statistics Report

Creating an Output Summary Table

Examples of Procedures that Analyze Data

Syntax Review

Activity 5.01

Activity 5.03

Activity 5.04

Level 1 Practice: Creating One-Way Frequency Reports

Level 2 Practice: Creating Two-Way Frequency Reports

Activity 5.05

Activity 5.06

Level 1 Practice: Producing a Descriptive Statistics Report

Level 2 Practice: Creating an Output Table with Custom Columns

Analyzing and Reporting on Data

Overview

Exporting Data

Demo: Exporting Data to an Excel Workbook

Using the SAS Output Delivery System

Exporting Results to CSV

Demo: Exporting Results to Excel

Exporting Results to PowerPoint and Microsoft Word

Demo: Exporting Results to PDF

Create a Macro Variable (REQUIRED)

Activity: Create PowerPoint and RTF Files

Syntax Review

Activity 6.01

Activity 6.02

Activity 6.03

Level 1 Practice: Creating an Excel File Using ODS EXCEL

Level 2 Practice: Creating a Document with ODS RTF

Exporting Results

Overview

SQL and SAS

PROC SQL Syntax

Filtering and Sorting Output

Demo: Reading and Filtering Data with SQL

Creating and Deleting Tables in SQL

Creating Inner Joins in SQL

Demo: Joining Tables with PROC SQL

Using Table Aliases

You've Finished the Course!

Syntax Review

Activity 7.01

Activity 7.02

Activity 7.03

Using SQL in SAS