SAS SQL

Course Overview

This course provides a practical introduction to SQL programming in SAS, with a focus on clinical data management and transformation. You will learn how to use PROC SQL to query, join, summarize, and manipulate datasets efficiently. The course also highlights how SQL can complement traditional DATA step programming in SDTM and ADaM development.

Learning Objectives

• Understand the syntax and structure of PROC SQL in SAS.

• Perform dataset joins, subqueries, and data summarization.

• Combine multiple SDTM or ADaM datasets efficiently.

• Create derived variables and summary tables using SQL logic.

• Optimize SQL queries for performance and readability.

• Integrate SQL techniques into clinical data programming workflows.

Course Modules

Module 1: Introduction to PROC SQL

• Understanding the SQL procedure in SAS

• Basic SELECT, FROM, WHERE, and ORDER BY clauses

• Creating new tables and views

Module 2: Data Joins and Relationships

• INNER, LEFT, RIGHT, and FULL JOIN operations

• Combining SDTM domains (e.g., DM + AE + EX)

• Joining ADaM datasets for analysis

Module 3: Subqueries and Conditional Logic

• Using subqueries for data filtering

• CASE WHEN expressions for conditional derivations

• Complex query building in clinical datasets

Module 4: Summarization and Aggregation

• GROUP BY and HAVING clauses

• Statistical summaries using SQL functions (AVG, COUNT, MAX, MIN)

• Creating subject-level analysis summaries

Module 5: Advanced SQL Techniques

• Using dictionary tables and metadata queries

• Combining PROC SQL with macros and DATA steps

• Optimizing query performance

Module 6: Practical Applications in Clinical Programming

• Deriving analysis-ready datasets using SQL

• Generating subject counts and population summaries

• Creating safety and efficacy data views for TFL generation

Key Features

• 💻 Hands-on SQL programming with clinical datasets

• 📊 Integration with SDTM and ADaM programming workflows

• 📘 Focus on efficiency, clarity, and reproducibility

• ✅ Real-world examples from clinical trial data

Who Should Attend

• SAS programmers seeking to enhance data manipulation skills

• Clinical data analysts working with SDTM and ADaM

• Students in biostatistics or data science programs

• Anyone aiming to optimize data workflows in SAS

Duration

Approx. 8 hours (including coding exercises and case studies)

What You’ll Gain

After completing this course, you will be able to confidently use PROC SQL to query, merge, and summarize clinical data efficiently—enhancing your programming productivity and supporting accurate regulatory reporting.