（更多资料和具体参加方法） 

SAS Advanced Certification

After the completion of this course, you will have the following abilities to

• Use advanced DATA step programming statements
• Use efficiency techniques to solve complex problems
• Write and interpret SAS SQL code
• Create and use the SAS MACRO facility

Topic 1 Review of SAS BASE

• Introduction

-review of displaying SAS data sets

-working with existing SAS data sets

• Controlling Input and Output

-outputting multiple observations

-writing to multiple SAS data sets

-selecting variables and observations

-writing to external files 

• Summarizing Data

-creating an accumulating total variable

-accumulating totals for a group of data

• Reading Different Types of Data
• Data Transformations

-manipulating character and numeric variables

-manipulating numeric variables based on dates

• Combining SAS Data Sets

-match-merging two or more SAS data sets

-set statement and PROC APPEND

• Processing Data Iteratively

-performing DO loop processing

-performing SAS array processing

Topic 2             Accessing Data Using SQL

• Introduction
• Generate reports using PROC SQL and the appropriate options
• Construct sub-queries within a PROC SQL step
• Compare solving a problem using the SQL procedure versus using traditional SAS programming techniques
• Access Dictionary Tables using the SQL procedure
• Demonstrate advanced PROC SQL skills by creating and updating tables, updating data values, working with indexes using the macro interface/creating macro variables with SQL, SQL views and SET operators

Topic 3 Macro Processing

• Overview of SAS Macro Language
• Macro Variables
• Introduction to Automatic Macro Variables 
• Macro Program
• SYMPUT
• SYMGET
• Macro Functions
• SQL and Macro Language
• System Options

Topic 4 Advanced Programming Techniques I

• Optimizing System Performance

-Controlling Memory, I/O resources and CPU

• SAS Processing
• SAS Index
• PROC FORMAT:

-VALUE Statement

-INVALUE Statement

-Permanent

-CNTLIN and CNTLOUT

-Data Extraction

• PROC TRANSPOSE
• Array with Examples
• Tables Lookup
• Hashing and Hash table

Topic 5       Advanced Programming Techniques II

·         Sampling Data

-GENERATING RANDOM NUMBERS

-ASSOCIATING A RANDOM NUMBER WITH A RANDOM INTEGER (SPECIAL SAS FUNCTIONS: CEIL, INT, FLOOR)

-PROC SURVEYSELECT

• PROC DATASETS
• Proc append
• Reduce the Space Required to Store SAS

-reducing the length of numeric variables

-compressing data files

-creating a DATA step view

• How to Control Which Variables and Observations You Want to Read and Write by

Using SAS

• Creating Integrity Constraints, and Audit Trails
• Some tips of Improving Efficiency with Examples