SAS Advanced Certificate

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