两天完成

SQL Basics

PROC SQL SELECT

FROM

WHERE

GROUP BY

HAVING

ORDER BY

PROC SQL OPTIONS

Validating Query Syntax

两天完成

CREATE TABLE statement

LIKE

AS

INSERT

DESCRIBE TABLE

Dictionary tables

一天完成

Understanding Joins

Inner Joins

Natural Joins

Outer Joins

Comparing Join and Merge

一天完成

Set Operators

EXCEPT set

INTERSECT set

UNION set

OUTER UNION

一天完成

Subsetting Data using Subqueries

Creating and managing views using PROC SQL

一天完成

Creating Data-Driven Macro Variables with PROC SQL

Accessing DBMS Data with SAS/ACCESS

FedSQL Procedure

两天完成

Macro Variables

SAS Macro Facility

Using Macro Variables

Troubleshooting Macro Variable References

Delimiting Macro Variable References

三天完成

Processing Text with Macro Functions

SAS Macro Functions to Mnipulate Character Strings

SAS Functions with Macro Variables

SAS Macro Functions to Mask Special Characters

Creating Macro Variables during PROC SQL Step Execution

Creatign Macro Variables during DATA step execution

Referencing Macro Variables Indirectly

两天完成

Defining and Calling a Macro

Passing Information into a Macro Using Parameters

Controlling Variable Scope

Debugging Macros

Conditional Processing

Iterative Processing

两天完成

Storing Macro Definitions in External Files

Understanding Session Compiled Macros

Using the Auto Call Facility

Data-Driven Macro Calls

两天完成

Defining and Referencing One_Dimensional Arrays

Expanding Your Use of One-Dimensional Arrays

Defining and Referncing Two-Dimentional Arrays

三天完成

Declaring Hash Objects

Defining Hash Objects

Finding Key Values in a Hash Object

Writing a Hash Object to a Table

Hash Object Processing

Using Hash Iterator Objects

一天完成

Creating Pcture Formats with the FORMAT procedure

Creating Functions with Proc FCMP

一天完成

Using a Variety of Advanced Function

Performing Pattern Matching with Perl Regular Expressions