SAS Institute Of Management Studies - Advanced SAS Programming Techniques 

Welcome to the Course

Practicing in the Course

DATA Step Processing

Processing a Data Set

Demo: Reviewing DATA Step Syntax and Processing

Learner Prerequisites

Using Forums and Getting Help

Access SAS Software for this Course

Set Up Data for This Course

Activity 1.01

Overview

Using Functions in SAS

Using the LAG Function

Demo: Retrieving Previous Values with the LAG Function

Calculating a Moving Average

Best Practice for Calculating a Moving Average

Using COUNT Functions

Using FIND Functions

Demo: Counting and Finding Words with Character Functions

What are Perl Regular Expressions?

What are Metacharacters?

PRXPARSE and PRXMATCH Functions

Demo: Validating Data with the PRXMATCH Function

PRXCHANGE Function

Capture Buffers

Demo: Standardizing Data with the PRXCHANGE Function

Metacharacter Examples

Activity 2.01

Activity 2.02

Activity 2.03

Activity 2.04

Practice Level 1: Using the LAG Function

Practice Level 2: Using the COUNT and FINDW Functions

Question 2.05

Activity 2.06

Activity 2.07

Practice Level 1: Using the PRXMATCH and PRXCHANGE Functions

Practice Level 2: Using the PRXCHANGE Function with Capture Buffers

Using Advanced Functions Review

Overview

Processing Repetitive Code

Using an Array

Referencing an Array in a DO Loop

Unknown Number of Array Elements

Creating Numeric Columns with an Array

Specifying Lower and Upper Bounds

Demo: Processing One-Dimensional Arrays: Part 1

Rotating Data

Specifying Initial Values for Array Elements

Creating Character Columns with an Array

Demo: Processing One-Dimensional Arrays: Part 2

Two-Dimensional Arrays

Performing a Table Lookup

Demo: Processing Two-Dimensional Arrays: Part 1

Specifying Initial Values for Two-Dimensional Array Elements

Loading a Two-Dimensional Array from a Table

Demo: Processing Two-Dimensional Arrays: Part 2

Array Advantages and Disadvantages

Activity 3.01

Activity 3.02

Activity 3.03

Question 3.04

Practice Level 1: Using One-Dimensional Arrays on Numeric Data

Practice Level 2: Using One-Dimensional Arrays on Character Data

Question 3.05

Activity 3.06

Practice Level 1: Using a Two-Dimensional Array Based on Initial Values

Practice Level 2: Using a Two-Dimensional Array Based on Loading a Table

Defining and Processing Arrays Review

Overview

Performing a Table Lookup: Example 1

What is a Hash Object?

Hash Object Process: Example 1

Declaring a Hash Object

Using Hash Object Methods

Demo: Declaring and Defining a Hash Object

Performing a Table Lookup: Example 2

FIND Method

KEY Arguments

Demo: Performing a Table Lookup with the FIND Method

Adding Data to a Hash Object

Saving a Hash Object

Demo: Creating a Table with the ADD and OUTPUT Methods

Unique and Duplicate Key Components

What is a Hash Iterator Object?

Creating the Hash Object and Hash Iterator Object

Hash Iterator Object Methods

Demo: Reading Data in Forward and Reverse Direction

Specifying the DATASET Argument

Using Multiple Method Statements

Hash Object Advantages and Disadvantages

Activity 4.01

Activity 4.02

Practice Level 1: Performing a Table Lookup Using One Key

Practice Level 2: Performing a Table Lookup Using Three Keys

Activity 4.03

Practice Level 1: Creating a Sorted Table from a Hash Object

Practice Level 2: Eliminating a PROC SORT step by Creating a Sorted Table from a Hash Object

Practice Level 1: Reading Data in Forward and Reverse Direction

Practice Level 2: Reading Data in Forward and Reverse Directions

Defining and Processing Hash Objects Review

Overview

Creating Custom Formats

Custom Date and Datetime Formats

Demo: Specifying a Template for Datetime Values

Custom Numeric Formats

Custom Large Number Format

Demo: Specifying a Template for Large Numbers

Creating and Using a Custom Function

Demo: Creating Functions Containing One Argument

Passing and Returning Values

Demo: Creating Functions Containing Multiple Arguments

Creating a Custom Call Routine

Advantages to Custom Functions and Call Routines

Question 5.01

Activity 5.02

Question 5.03

Practice Level 1: Specifying a Template Based on Date Directives

Practice Level 2: Specifying a Template Based on Digit Selectors

Activity 5.04

Practice Level 1: Creating a Custom Function That Returns a Numeric Value

Practice Level 2: Creating a Custom Function That Returns a Character Value

Using Utility Procedures Review