1. SAS Fundamentals, Datasets & Libraries
Core architecture of the SAS programming environment, WORK vs. Permanent libraries, and syntax rules.
SAS Program Syntax: Statements, Semicolons & Structure
Master the foundational rules of SAS program statements, global options, and syntax parsing.
Read Guide →SAS Libraries & LIBNAME Statement: WORK vs Permanent
How SAS pointers map physical directories to logical two-level dataset names.
Read Guide →2. DATA Step Lifecycle, PDV & Compilation Mechanics
Deep-dive into Program Data Vector memory allocation, execution loops, RETAIN logic, and explicit output.
SAS Program Data Vector (PDV): Compilation vs. Execution
The complete mental model of how SAS processes records one row at a time in memory.
Read Guide →SAS RETAIN Statement vs. SUM Statement Accumulators
Preserve values across DATA step iterations without resetting to missing.
Read Guide →Implicit vs. Explicit OUTPUT Statement in SAS DATA Step
Controlling when and where observations are written to output datasets.
Read Guide →3. Data Ingestion, Sorting, Duplicates & Formats
Reading raw files, INFORMATS vs. FORMATS, PROC SORT deduplication (NODUP vs NODUPKEY), and BY-groups.
SAS INFORMATS vs. FORMATS & PROC FORMAT Custom Mappings
Understand how SAS reads raw data into internal values and renders visual representations.
Read Guide →PROC SORT: NODUP vs. NODUPKEY & FIRST./LAST. BY-Groups
Eliminate duplicate records, order observations, and utilize FIRST. and LAST. automatic variables.
Read Guide →Merging Datasets: DATA Step MERGE vs. PROC SQL Joins
Compare match-merging using IN= variables with relational SQL inner, left, and full joins.
Read Guide →4. SAS Macro Facility & PROC SQL Mastery
Macro variables, %MACRO functions, CALL SYMPUTX, and SQL aggregation.
SAS Macro Facility: Macro Variables, %MACRO & CALL SYMPUTX
Automate repetitive data workflows with macro substitution and dynamic runtime code generation.
Read Guide →PROC SQL in SAS: Aggregate Queries, GROUP BY & Subqueries
Execute ANSI SQL queries directly on SAS datasets for grouping, summarization, and conditional filtering.
Read Guide →5. Data Reshaping & Built-in SAS Functions
PROC TRANSPOSE long-to-wide restructuring, ID statements, SUBSTR, SCAN, and numeric rounding functions.
PROC TRANSPOSE: Long-to-Wide Restructuring & ID Statement Logic
Transform longitudinal observation rows into clean structured analytical columns.
Read Guide →Essential SAS Functions: SUBSTR, SCAN, STRIP, CEIL & FLOOR
Master core string slicing, token extraction, and numeric rounding operations in DATA steps.
Read Guide →🌐 Explore Companion Knowledge Hubs
Ready for comprehensive video walkthroughs and exercises?
Get lifetime access to step-by-step video lessons, downloadable files, practice questions, and certified completion credentials.