40-Hour Unit-by-Unit Syllabus Structure
Turnkey course structure designed for semester elective adoption or intensive placement bootcamps.
SAS Studio & Cloud Environment • LIBNAME Engines & Two-Level Names • Ingesting Delimited (CSV), Fixed-Width, and Excel Files with `INFILE` and `PROC IMPORT` • Compilation vs. Execution Phases • Program Data Vector (PDV) Deep Dive.
Conditional Logic (`IF-THEN/ELSE`, `SELECT-WHEN`) • Cumulative Processing with `RETAIN` and Sum Statements • Character, Date & Numeric Functions • BY-Group Processing (`FIRST.` and `LAST.` boolean logic) • Reshaping Multi-Dimensional Data with SAS Arrays.
Set Theory vs. Row-by-Row Execution • Inner, Left, Full Outer Joins • Subqueries & In-line Views • Calculating Summary Statistics and Dynamic Group Re-merges • Dynamic Macro Variable Creation with `INTO :variable SEPARATED BY`.
Macro Variables & Macro Symbol Table • Macro Functions (`%SCAN`, `%SUBSTR`, `%EVAL`) • Modular Macro Definitions with Positional & Keyword Parameters • `%DO` Loops and Conditional Logic • Dynamic Execution with `CALL SYMPUTX`.
Banking & Retail Case Study: End-to-end data pipeline cleaning multi-million row transactional logs, automating monthly executive summaries, and sitting a full timed certification mock exam.
