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
 
(更多资料和具体参加方法)
本页最后更新: | -- | 网站设计和虚拟主机服务 WECAN.ca CMS