Apply PROC SQL Fundamentals for Data Analysis in SAS

Instructor: EDUCBA

Access provided by Masterflex LLC, Part of Avantor

6 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Construct efficient PROC SQL queries using functions, aggregations, joins, and set operators in SAS.
Automate and parameterize SQL queries using macro variables for scalable data analysis workflows.
Manage, update, and maintain structured datasets and metadata following SQL best practices in SAS.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 6 modules in this course

By the end of this course, learners will be able to construct efficient PROC SQL queries, apply SQL functions and aggregations, combine data using joins and set operators, automate queries with macro variables, and manage data and metadata within the SAS environment. Learners will also gain the ability to create, update, and maintain structured datasets while adhering to best practices in SQL-based data management.

This course is designed to help learners build practical, job-ready skills in using PROC SQL for real-world data analysis and reporting tasks. Through structured modules and progressively complex examples, learners will move from foundational SQL concepts to advanced query automation and metadata maintenance. The hands-on approach enables learners to confidently transform, filter, and summarize large datasets using industry-standard SQL techniques in SAS. What makes this course unique is its end-to-end coverage of PROC SQL—from core query construction to advanced joins, subqueries, macro integration, and metadata governance. The course emphasizes practical application, clear conceptual understanding, and scalable SQL design, making it ideal for data analysts, SAS programmers, and professionals seeking to strengthen their SQL proficiency within SAS.

This module introduces the fundamentals of PROC SQL in SAS, focusing on core concepts, basic syntax, and essential SELECT operations. Learners gain a strong foundation in how SQL operates within the SAS environment, enabling them to retrieve, organize, and summarize data efficiently.

What's included

8 videos4 assignments

8 videos Total 78 minutes

Introduction to Comprehensive PROC SQL - SAS Training 11 minutes
Select Statement 11 minutes
Select Statement Continues 11 minutes
Proc SQL Basic 11 minutes
SQL Operator 8 minutes
SQL Syntax 10 minutes
SQL Group By Statement 7 minutes
Count Miss and Monotonic Function 8 minutes

4 assignments Total 60 minutes

Getting Started with PROC SQL 10 minutes
Building SELECT Queries 10 minutes
SQL Syntax and Grouping Basics 10 minutes
Graded - Foundations of PROC SQL in SAS 30 minutes

This module explores SQL functions and aggregation techniques in PROC SQL, emphasizing data summarization, ordering, and clause usage. Learners develop the ability to manipulate data values and control query output using built-in functions and sorting logic.

What's included

8 videos4 assignments

8 videos Total 66 minutes

Coalesce Function and Sounder Function 10 minutes
Ranuni and Max Function 10 minutes
Ranuni and Max Function Continue 6 minutes
Proc SQL Group By and Order By Statement 11 minutes
Examples of Order By Clause 9 minutes
Examples of Proc SQL Clauses 6 minutes
PROC SQL Data Set 8 minutes
PROC SQL Data Set Continues 6 minutes

4 assignments Total 60 minutes

Working with SQL Functions 10 minutes
Grouping and Ordering Results 10 minutes
Applying PROC SQL Clauses 10 minutes
Graded - Functions and Data Summarization 30 minutes

This module focuses on transforming query results into reusable datasets and applying advanced filtering logic. Learners practice creating new columns, eliminating duplicates, and structuring complex queries using inline views and conditional logic.

What's included

8 videos4 assignments

8 videos Total 71 minutes

Selective Statement and Storing Result 10 minutes
Creating New Columns and Aggregation 11 minutes
Constitutionality and Filtering 7 minutes
Example of Filtering 9 minutes
Reordering Row and Elimination of Duplicates 8 minutes
Statistics Based on Original 10 minutes
Source with Inline Views 11 minutes
Ambiguity in Column References 6 minutes

4 assignments Total 60 minutes

Creating and Storing SQL Results 10 minutes
Conditional Logic and Filtering 10 minutes
Advanced Query Sources 10 minutes
Graded - Data Transformation and Filtering 30 minutes

This module examines relational data concepts in PROC SQL, including keys, joins, subqueries, and set operators. Learners develop skills to combine datasets accurately and analyze relationships across multiple data sources.

What's included

8 videos4 assignments

8 videos Total 73 minutes

Non Repeating Keys 9 minutes
Repeating Keys 12 minutes
Joins and Mergers 10 minutes
Sub Queries 10 minutes
Sub Queries Continues 5 minutes
Contrasts Between Joins 9 minutes
Interleaving with Outer Joins 12 minutes
Intersect Set Operator 7 minutes

4 assignments Total 60 minutes

Understanding Data Keys 10 minutes
Joins and Subqueries 10 minutes
Advanced Join and Set Techniques 10 minutes
Graded - Keys, Joins, and Set Operations 30 minutes

This module introduces automation techniques by integrating PROC SQL with SAS macro variables. Learners gain experience generating dynamic SQL code and using macro-driven logic to enhance query flexibility and reusability.

What's included

8 videos4 assignments

8 videos Total 70 minutes

Expect All Set Operator 6 minutes
Global Statements 9 minutes
Generating Proc SQL Code 9 minutes
Populating with Macro Variables 11 minutes
Macro Variables Using SQL Examples 9 minutes
Macro Variables Using SQL Examples Continues 7 minutes
SQL Selection and Maxmin Function 8 minutes
Table Maintenance 12 minutes

4 assignments Total 60 minutes

Set Operators and Global Statements 10 minutes
Generating Dynamic SQL 10 minutes
Advanced Macro Applications 10 minutes
Graded - Automation with PROC SQL and Macros 30 minutes

This module focuses on managing data persistence and metadata using PROC SQL. Learners explore table creation, updates, structural modifications, and metadata-bound libraries to maintain data integrity and governance.