Introduction Advanced SAS Certificate

 
Audience
Successful candidates for the SAS Certified Advanced Programmer credential should have experience in programming and data management using SAS.
 
Goal
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
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
  • 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
  • Improve Efficiency with Examples

More info button
(Let someone contact you) 

 

Share
Last update:. Visits -- | Web site design and hosting by WECAN.ca CMS