Mastering PROC SQL in SAS: Analyze, Query & Optimize Data

本课程是 Advanced SAS Programming, Macros & Reporting 专项课程的一部分

位教师：EDUCBA

访问权限由 Coursera Learning Team 提供

9个模块

深入了解一个主题并学习基础知识。

初级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

9个模块

深入了解一个主题并学习基础知识。

初级等级

推荐体验

2 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Build, query, and analyze SAS datasets using PROC SQL joins, subqueries, and reporting features.
Optimize SQL performance, apply constraints, and troubleshoot real-world PROC SQL scenarios.
Automate and enhance SQL workflows using macro variables and advanced PROC SQL techniques.

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

34 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

本课程是 Advanced SAS Programming, Macros & Reporting 专项课程专项课程的一部分

在注册此课程时，您还会同时注册此专项课程。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
获得可共享的职业证书

该课程共有9个模块

Learners will build, query, analyze, optimize, and maintain SAS datasets using PROC SQL. They will apply joins, construct complex queries, generate reports, automate workflows with macro variables, enforce data integrity with constraints, and troubleshoot performance issues across real-world data scenarios.

This comprehensive course equips learners with the practical skills needed to work confidently with SQL inside the SAS environment. Throughout the course, learners benefit from hands-on demonstrations, clear explanations of SQL logic, and structured modules that progressively develop beginner to advanced capabilities. By the end, learners will be able to transform raw datasets into reliable, meaningful insights using professional SQL techniques. What makes this course unique is its complete coverage of PROC SQL—from foundational SELECT statements to advanced subqueries, indexing strategies, metadata manipulation, and matrix-style analytical logic rarely covered in traditional SQL training. The combination of SAS-focused best practices, real examples, and step-by-step problem-solving ensures that learners not only understand how PROC SQL works but also why certain techniques produce better accuracy, performance, and scalability.

This module introduces learners to the fundamentals of PROC SQL in SAS, covering essential SQL syntax, selection operations, basic functions, and foundational grouping techniques used in data processing.

涵盖的内容

9个视频4个作业

9个视频总计88分钟

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

4个作业总计60分钟

Graded - Foundations of PROC SQL in SAS 30分钟
Getting Started with PROC SQL 10分钟
Core SQL Building Blocks 10分钟
Grouping & Basic Functions 10分钟

This module builds on core SQL skills by exploring random number generation, aggregate computations, ordering logic, and foundational SQL clause interactions used for structured data analysis.

涵盖的内容

5个视频3个作业

5个视频总计42分钟

Ranuni and Max Function 10分钟
Ranuni and Max Function Continue 6分钟
Proc SQL Group By and Order by Statement 11分钟
Examples of Order by Clause 9分钟
Examples of Proc SQL Clauses 6分钟

3个作业总计50分钟

Graded - Working with Functions & Data Organization 30分钟
Randomization & Aggregates 10分钟
Ordering & SQL Clause Applications 10分钟

This module teaches learners to manage SAS datasets using PROC SQL, including creating result tables, computing new columns, applying filter logic, and detecting sequential or data structure issues.

涵盖的内容

8个视频4个作业

8个视频总计68分钟

PROC SQL-Data Set 8分钟
PROC SQL-Data Set Continues 6分钟
Selective Statement and Storing Result 10分钟
Creating New Columns and Aggregation 11分钟
Constitutionality and Filtering 7分钟
Example of Filtering 9分钟
Reordering Row and Elimination of Duplicates 8分钟
Statistics Based on Original 10分钟

4个作业总计60分钟

Graded - Dataset Handling and Filtering Logic 30分钟
Creating & Managing SQL Datasets 10分钟
New Columns, Aggregations & Filters 10分钟
Row Manipulation & Efficiency 10分钟

This module introduces inline views, explores key structures, examines join behavior, and builds competency in subqueries and correlated subquery logic.

涵盖的内容

7个视频4个作业

7个视频总计63分钟

Source with Inline Views 11分钟
Ambiguity in Column References 6分钟
Non Repeating Keys 9分钟
Repeating Keys 12分钟
Joins and Mergers 10分钟
Sub Queries 10分钟
Sub Queries Continues 5分钟

4个作业总计60分钟

Graded - Advanced Column Handling & Joins Fundamentals 30分钟
Inline Views & Column Disambiguation 10分钟
Understanding Key Structures 10分钟
Join Concepts & Subqueries 10分钟

This module covers set operations, dictionary tables, creation of SQL views, reporting techniques, and formatting strategies to enhance data presentation.

涵盖的内容

14个视频4个作业

14个视频总计117分钟

Contrasts Between Joins 9分钟
Interleaving with Outer Joins 12分钟
Intersect Set Operator 7分钟
Expect All Set Operator 6分钟
Global Statements 9分钟
PROC SQL-Dictionary 11分钟
PROC SQL-Report Generator 10分钟
PROC SQL-Report Generator Continues 8分钟
Defining Views 9分钟
Changing Table Via View 6分钟
Managing Library References 7分钟
Formatting Output in Proc SQL 8分钟
Formatting Output Using Scalar Expression 7分钟
Sub Setting Group with Having Clause 8分钟

4个作业总计60分钟

Graded - Set Operators, Views, Reports & Metadata 30分钟
Set Operators & Outer Joins 10分钟
Views & Report Generation 10分钟
Metadata & Table Structures 10分钟

This module deepens understanding of logical operators, character handling, row analysis, and macro variable creation to support dynamic, automated SQL workflows.

涵盖的内容

17个视频4个作业

17个视频总计141分钟

Generating Proc SQL Code 9分钟
Sql Selection and Maxmin Function 8分钟
Creating Aliases 7分钟
Logical Operator 6分钟
Aligning Characters 5分钟
Extracting Information from String 8分钟
Data with Count Function 11分钟
Non Consecutive Values 9分钟
Identifying Duplicate Row from Coding 3分钟
Populating with Macro Variables 11分钟
Marco Variables Using SQL Examples 9分钟
Marco Variables Using SQL Examples Continues 7分钟
Coding Logic in Proc SQL Continues 12分钟
More on Coding Logic in Proc SQL 6分钟
Coding Logic in Proc SQL 12分钟
Coding Proc SQL 10分钟
Creating Multiple Macro Variable 11分钟

4个作业总计60分钟

Graded - Coding Logic & Macro Integration 30分钟
Logical & Character Operations 10分钟
Advanced Row Analysis 10分钟
Macro Variable Creation & SQL Automation 10分钟

This module teaches table creation, metadata updates, numeric data handling, and constraint enforcement through keys and indexes to maintain relational integrity.

涵盖的内容

12个视频4个作业

12个视频总计121分钟

Table Maintenance 12分钟
Distinguishing Persistent From Replacement 12分钟
Create Table for Data Maintenance 10分钟
Modify and Update Data Maintenance Table 9分钟
Metadata Maintenance 11分钟
Metadata Data Sets Library 8分钟
Alter Tables in Metadata Maintenance 8分钟
Creating Numeric Data 7分钟
Check Constraint in Proc SQL 12分钟
Establishing Primary and Foreign Keys 10分钟
Modifying Updating Tables 12分钟
Creating Simple and Composite Index 12分钟

4个作业总计60分钟

Graded - Data Maintenance, Constraints & Indexing 30分钟
Table Creation & Updating 10分钟
Metadata & Numeric Data Handling 10分钟
Keys, Constraints & Indexes 10分钟

This module builds expertise in multi-table joins, complex SQL query structures, view layering, debugging, and performance tuning for optimized SQL execution.

涵盖的内容

14个视频4个作业

14个视频总计128分钟

Coding Complex Queries 8分钟
Equi Joins and Reflexive Joins Queries 10分钟
Performance Computations in Joins 7分钟
Joins in Proc SQL 8分钟
Joins in Proc SQL Continues 6分钟
Complex Queries in Proc SQL 11分钟
Comparing Complex Queries in Proc SQL 12分钟
Complex View in Proc SQL 11分钟
Complex View in Proc SQL Continues 10分钟
Trouble Shooting and Debugging Techniques 12分钟
Using INOBS and Loops Option in Trouble Shooting 10分钟
Prompt and Reset Statement in Trouble Shooting 10分钟
Tuning Codes in PROC SQL 12分钟
Tuning Codes in PROC SQL Continues 3分钟

4个作业总计60分钟

Graded - Mastering Joins, Complex Queries & Optimization 30分钟
Professional-Level Joins 10分钟
Working with Complex Queries & Views 10分钟
Debugging & Performance Tuning 10分钟

This final module integrates advanced SQL capabilities, including multi-level subqueries, dynamic table creation and population, constraint enforcement, and matrix-style analytical solutions.