1

An overview foundation of SAS

1

Introduction to SAS programs

2

Submitting a program

3

Exercises /quiz

1

Mastering Fundamental Concepts

2

Diagnosis and Correcting syntax errors

3

Exercises

1

Understanding the PDV Process

2

Accessing sas data libraries and Relational databases

3

Exercises

1

Introduction to Reading Data

2

Using SAS Data as Input

3

Subsetting Observations variables

4

Adding permanent attributes

5

Exercises

1

Using excel data as input

2

Reading excel worksheets

3

Exercises

1

Using standard delimited data as input

2

Using NON standard delimited data as input

3

Exercises

1

Introduction to Validating and Cleaning data

2

Examining data errors when reading raw datafiles

3

Validating data with print and freq procedure

4

Validation data with means and Univariate procedure

5

Cleaning invalid data with windows and UNIX

6

Using FSEDIT window to clean the data

7

Exercises

1

Creating variables

2

Creating Varibles conditionally

3

Subsetting observations

4

Excersises

1

Introduction to Combining the datasets

2

Appending the sas datasets

3

Concatenation of sas datasets

4

Merging the sas datasets [One to one / One to many ]

5

Merging datasets with Non-Matches

6

Exercises

1

Using global statements

2

Adding labels and formats

3

Creating used defined formats

4

Subetting and Grouping Observations

5

Direct output to the external files HTML /PDF/EXCELXP/RTF

6

Exercises

1

Using Freq Procedure

2

Using means procedure

3

Using Tabulate Procedure

1

Output multiple observations

2

Writing to multiple sas datasets

3

Selecting variables and Observations

4

Writing to an external file

5

Exercises

1

Creating and Accumulating total variables

2

Accumulating totals for a group of data

3

Exercises

1

Reading Delimited rawdata files

2

Controlling when a record loads

3

Reading hierarchical rawdata files

4

Exercises

1

Introduction

2

Manipulating character values

3

Manipulating Numeric Values

4

Manipulating Numeric values based on Dates

5

Converting variable type

6

Exercises

1

Using PUT Statement

2

Debug Option

1

Match merging two or more sas datasets

2

Simple joins using sas sql procedure

3

Exercises

1

Setting up for this course.

2

DATA step review.

3

Using Advanced Functions

4

Using a variety of advanced functions.

5

Performing pattern matching with Perl regular expressions.

6

Defining and Processing Arrays

7

Defining and referencing one-dimensional arrays.

8

Doing more with one-dimensional arrays.

9

Defining and referencing two-dimensional arrays.

10

Defining and Processing Hash Objects

11

Declaring hash objects.

12

Defining hash objects.

13

Finding key values in a hash object.

14

Writing a hash object to a table.

15

Using hash iterator objects.

16

Using Utility Procedures

17

Creating picture formats with the FORMAT procedure.

18

Creating functions with the FCMP procedure.

1

Structured Query Language

2

SAS Functions

3

Case Study

1

Overview of sql procedure

2

Specifying Columns

3

Specifying Rows

4

Presenting data

5

Summarizing data

6

Exercises

1

Overview

2

Joins

3

Complex Joins

4

Set operators

5

Exercises

1

Creating tables

2

Creating views

3

Creating Indexes

4

Maintaining Tables

5

Exercises

1

Setting PROC SQL Options

2

Dictionary Tables and Views

3

Interfacing PROC SQL with macro language

4

Program testing and performance

1

Table and Column names Sorted by Column names

2

Table and column names Sorted by table names

3

Partial table listings

1

Purpose of the macro facility

2

Program flow

3

Course data

1

Introduction to Macro variables

2

Automatic Variables

3

Macro Variable References

4

User defined macro variables

5

Delimiting macro variables names

6

Macro Functions

1

Defining and calling a Macro

2

Macro Parameters

1

Creating Macro variables in the data step

2

Indirect reference to macro variables

3

Retrieving macro variables in the data step

4

Creating macro variables in SQL

1

Conditionally Processing

2

Iterative processing

3

Global and Local Symbol tables