When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Apply PROC SQL Fundamentals for Data Analysis in SAS

本课程是 Apply and Analyze Data Using SAS PROC SQL 专项课程的一部分

位教师：EDUCBA

包含在中

了解更多

6个模块

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

初级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

6个模块

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

初级等级

推荐体验

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

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.

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

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

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

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

积累特定领域的专业知识

本课程是 Apply and Analyze Data Using SAS PROC SQL 专项课程专项课程的一部分

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

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

该课程共有6个模块

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.

涵盖的内容

8个视频4个作业

8个视频总计78分钟

Introduction to Comprehensive PROC SQL - SAS Training11分钟
Select Statement11分钟
Select Statement Continues11分钟
Proc SQL Basic11分钟
SQL Operator8分钟
SQL Syntax10分钟
SQL Group By Statement7分钟
Count Miss and Monotonic Function8分钟

4个作业总计60分钟

Graded - Foundations of PROC SQL in SAS30分钟
Getting Started with PROC SQL10分钟
Building SELECT Queries10分钟
SQL Syntax and Grouping Basics10分钟

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.

涵盖的内容

8个视频4个作业

8个视频总计66分钟

Coalesce Function and Sounder Function10分钟
Ranuni and Max Function10分钟
Ranuni and Max Function Continue6分钟
Proc SQL Group By and Order By Statement11分钟
Examples of Order By Clause9分钟
Examples of Proc SQL Clauses6分钟
PROC SQL Data Set8分钟
PROC SQL Data Set Continues6分钟

4个作业总计60分钟

Graded - Functions and Data Summarization30分钟
Working with SQL Functions10分钟
Grouping and Ordering Results10分钟
Applying PROC SQL Clauses10分钟

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.

涵盖的内容

8个视频4个作业

8个视频总计71分钟

Selective Statement and Storing Result10分钟
Creating New Columns and Aggregation11分钟
Constitutionality and Filtering7分钟
Example of Filtering9分钟
Reordering Row and Elimination of Duplicates8分钟
Statistics Based on Original10分钟
Source with Inline Views11分钟
Ambiguity in Column References6分钟

4个作业总计60分钟

Graded - Data Transformation and Filtering30分钟
Creating and Storing SQL Results10分钟
Conditional Logic and Filtering10分钟
Advanced Query Sources10分钟

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.

涵盖的内容

8个视频4个作业

8个视频总计73分钟

Non Repeating Keys9分钟
Repeating Keys12分钟
Joins and Mergers10分钟
Sub Queries10分钟
Sub Queries Continues5分钟
Contrasts Between Joins9分钟
Interleaving with Outer Joins12分钟
Intersect Set Operator7分钟

4个作业总计60分钟

Graded - Keys, Joins, and Set Operations30分钟
Understanding Data Keys10分钟
Joins and Subqueries10分钟
Advanced Join and Set Techniques10分钟

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.

涵盖的内容

8个视频4个作业

8个视频总计70分钟

Expect All Set Operator6分钟
Global Statements9分钟
Generating Proc SQL Code9分钟
Populating with Macro Variables11分钟
Macro Variables Using SQL Examples9分钟
Macro Variables Using SQL Examples Continues7分钟
SQL Selection and Maxmin Function8分钟
Table Maintenance12分钟

4个作业总计60分钟

Graded - Automation with PROC SQL and Macros30分钟
Set Operators and Global Statements10分钟
Generating Dynamic SQL10分钟
Advanced Macro Applications10分钟

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.