Introduction to SAS Advanced Certificate
（更多资料和具体参加方法）
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
（更多资料和具体参加方法）
