SAS programming topics
12 short topics in SQL and Relational Databases. Each one is a single focused exercise with a clear piece of evidence at the end.
12 topics, one exercise each.
Work through them in order, or jump to the one you need.
These are draft topic outlines (draft; instructor review pending). Full lessons follow after review; ask Ajay if you need a topic sooner.
- 01
Query expression syntax
Demonstrate query expression syntax in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 02
Data selection and projection
Demonstrate data selection and projection in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 03
Predicates and filtering
Demonstrate predicates and filtering in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 04
Grouping and aggregation
Demonstrate grouping and aggregation in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 05
Ordering and result windows
Demonstrate ordering and result windows in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 06
Combining data sources
Demonstrate combining data sources in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 07
Null and missing-value behavior
Demonstrate null and missing-value behavior in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 08
Reusable query parameters
Demonstrate reusable query parameters in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 09
Query composition and subexpressions
Demonstrate query composition and subexpressions in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 10
Query execution and optimization reasoning
Demonstrate query execution and optimization reasoning in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 11
Query result validation
Demonstrate query result validation in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course → - 12
Query integration with applications
Demonstrate query integration with applications in a focused SAS programming example; verify normal behavior and one edge or failure case. Keep the exercise bounded and record the behavior supported by the chosen version.
Open micro-course →
More in Specialist languages and industry programming.
You have the curiosity.
Let’s turn it into capability.
Start with a practical workshop or bring a specific question to Ajay.