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