1. Introduction

• Introducing the Structured Query Language

2. Basic Queries

• Overview of the SQL procedure
• Specifying columns
• Specifying rows

3. Displaying Query Results

• Presenting data
• Summarizing data

4. SQL Joins

• Introduction to SQL joins
• Inner joins
• Outer joins
• Complex SQL joins

5. Subqueries

• Noncorrelated subqueries
• In-line views

6. Set Operators

• Introduction to set operators
• UNION operator
• OUTER UNION operator
• EXCEPT operator
• INTERSECT operator

7. Creating Tables and Views

• Creating tables with the SQL procedure
• Creating views with the SQL procedure

8. Advanced PROC SQL Features

• Dictionary tables and views
• Using SQL procedure options
• Interfacing PROC SQL with the macro language

SAS Macro Language

 

1. Introduction

• Getting Familiar to the macro facility

2. Macro Variables

• Introduction to macro variables
• Automatic macro variables
• Macro variable references
• User-defined macro variables
• Delimiting macro variable references
• Macro functions

3. Macro Definitions

• Defining and calling a macro
• Macro parameters

4. DATA Step and SQL Interfaces

• Creating macro variables in the DATA step
• Indirect references to macro variables
• Creating macro variables in SQL

5. Macro Programs

• Conditional processing
• Parameter validation
• Iterative processing
• Global and local symbol tables

 

Advanced SAS Programming Techniques

• 1. Measuring Efficiencies
  • Measuring efficiency

  2. Controlling I/O Processing and Memory

  • SAS DATA step processing
  • Controlling I/O
  • Using SAS views
  • Reducing the length of numeric variables
  • Compressing SAS data sets

  3. Accessing Observations

  • Creating a sample data set
  • Creating an index
  • Using an index

  4. Using DATA Step Arrays

  • Introduction to lookup techniques
  • Using one-dimensional arrays
  • Using multidimensional arrays
  • Loading a multidimensional array from a SAS data set

  5. Using DATA Step Hash and Hiter Objects

  • Introduction
  • Using hash object methods
  • Loading a hash object with data from a SAS data set
  • Using the DATA step hiter object

  6. Combining Data Horizontally

  • DATA step merges and SQL procedure joins
  • Using an index to combine data
  • Combining summary and detail data
  • Combining data conditionally

  7. Expert Programmer Techniques

  • Creating user-defined functions
  • The experts’ FORMAT procedure