This course is part of the SAS Advanced Programmer Professional Certificate

4.9
stars
214 ratings

Peter Styliadis

11,345 already enrolled

Offered By

SAS Advanced Programmer Professional CertificateSAS

About this Course

37,482 recent views

Course Description
In this course, you learn about Structured Query Language (SQL) and how it can be used in SAS programs to create reports and query your data.   

“By the end of this course, a learner will be able to…”
●	Query and subset data.
●	Summarize and present data.
●	Combine tables using joins and set operators.
●	Create and modify tables and views.
●	Create data-driven macro variables using a query.
●	Access DBMS data with SAS/ACCESS technology.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

SAS Advanced Programmer Professional Certificate

Approx. 26 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 1 of 3 in the

SAS Advanced Programmer Professional Certificate

Approx. 26 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.83/5 (85 Ratings)

Peter Styliadis

Senior Technical Training Consultant

SAS Education

13,926 Learners

5 Courses

Offered by

SAS

Through innovative software and services, SAS empowers and inspires customers around the world to transform data into intelligence. SAS is a trusted analytics powerhouse for organizations seeking immediate value from their data. A deep bench of analytics solutions and broad industry knowledge keep our customers coming back and feeling confident. With SAS®, you can discover insights from your data and make sense of it all. Identify what’s working and fix what isn’t. Make more intelligent decisions. And drive relevant change.

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

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week1

Week 1

1 hour to complete

Course Overview and Data Setup

1 hour to complete

1 video (Total 1 min), 4 readings

1 hour to complete

Essentials

1 hour to complete

8 videos (Total 13 min), 1 reading, 2 quizzes

Week2

Week 2

7 hours to complete

PROC SQL Fundamentals

7 hours to complete

29 videos (Total 56 min), 5 readings, 18 quizzes

29 videos

Overview31sFiltering Rows Using the WHERE Clause4mSpecial WHERE Operators: Missing Values52sAdditional Special WHERE Operators1mSorting the Output with the ORDER BY Clause33sOrdering Columns by Position17sEnhancing Reports4mDemo: Creating Simple Reports4mCreating a New Column1mSubsetting Calculated Values43sAssigning Values Conditionally with the CASE Expression1mDemo: Assigning Values Conditionally2mEliminating Duplicate Rows with the DISTINCT Keyword54sSummarizing Data1mDemo: Using Summary Functions to Analyze a Table3mSummarizing Data Using the COUNT Function20sGrouping Data2mDemo: Analyzing Groups of Data4mSummarizing Date and Time Data1mCounting Rows Using a Boolean Expression37sDemo: Summarizing Data Using a Boolean Expression2mCreating Tables1mCreating Tables from a Query1mCreating Table Structures1mInserting Rows into Tables2mDropping Tables in PROC SQL10sScenario31sDICTIONARY Tables1mDemo: Using DICTIONARY Tables5m

5 readings

Date, Time, and Datetime Values10mCommonly Used Summary Functions10mAdditional Statements to Maintain Tables10mSQL Order of Execution Cheat Sheet (optional)1mLearning More (optional)1m

18 practice exercises

Activity 2.0110mActivity 2.0210mActivity 2.0310mActivity 2.0410mActivity 2.0510mLevel 1 Practice: Querying a Table20mLevel 2 Practice: Working with Datetime Values20mActivity 2.0610mActivity 2.0710mActivity 2.0810mLevel 1 Practice: Eliminating Duplicates20mLevel 2 Practice: Grouping and Summarizing Data20mActivity 2.0910mActivity 2.1010mActivity 2.1110mPractice Level 1: Counting the Number of Tables in a Library20mPractice Level 2: Counting the Number of Tables in All Libraries20mPROC SQL Fundamentals 1h 15m

Week3

Week 3

4 hours to complete

SQL Joins

4 hours to complete

22 videos (Total 29 min), 3 readings, 14 quizzes

22 videos

Overview19sJoining Tables2mTypes of Joins1mJoining Two Tables with an Inner Join1mDemo: Performing an Inner Join with PROC SQL2mAlternative SQL Inner Join Syntax40sUsing Table Aliases39sMatching Rows with a Natural Join1mSelecting Data from More Than Two Tables39sDemo: Performing an Inner Join with Four Tables2mHandling Missing Values1mCreating Non-Equijoins47sSQL Outer Joins1mPerforming Left and Right Outer Joins1mJoining Two Tables with a Full Join42sDemo: Performing a Full Join with Proc SQL2mIdentifying Nonmatching Rows1mUsing Reflexive Joins1mDemo: Performing a Reflexive Join2mUsing Functions to Join Tables39sUsing Functions to Join When Column Types Are Different17sConverting Column Values with Functions1m

3 readings

Table Relationships10mSQL Join Summary Cheat Sheet (optional)1mLearning More (optional)1m

14 practice exercises

Activity 3.0110mActivity 3.0210mActivity 3.0310mActivity 3.0410mPractice Level 1: Performing an Inner Join20mPractice Level 2: Joining on Inequality20mActivity 3.0510mActivity 3.0610mPractice Level 1: Using Outer Joins to Find Nonmatches20mPractice Level 2: Using Outer Joins to Summarize Data20mActivity 3.0710mActivity 3.0810mActivity 3.0910mSQL Joins 50m

Week4

Week 4

4 hours to complete

Subqueries

4 hours to complete

19 videos (Total 33 min), 2 readings, 12 quizzes

19 videos

Overview17sWhat Is a Subquery?1mUsing a Subquery in the WHERE Clause2mDemo: Using a Subquery That Returns a Single Value2mUsing a Subquery in the HAVING Clause1mSubquery That Returns Multiple Values1mDemo: Using a Subquery That Returns Multiple Values2mUsing the ANY Keyword1mUsing Correlated Subqueries1mUsing Temporary Tables1mWhat Is an In-Line View?34sDemo: Using an In-Line View3mCreating a View2mMaking a View Portable2mUsing a Subquery in the SELECT Clause45sRemerging Summary Statistics in PROC SQL1mDemo: Remerging Summary Statistics2mControlling Remerging1mRemerging GROUP BY Summary Statistics1m

2 readings

Advantages/Disadvantage of Views10mLearning More (optional)1m

12 practice exercises

Activity 4.0110mActivity 4.0215mActivity 4.0310mPractice Level 1: Using a Subquery That Returns a Single Value20mPractice Level 2: Using a Subquery with Multiple Functions20mActivity 4.0410mPractice Level 1: Using an In-Line View20mPractice Level 2: Building a Complex Query Using In-Line Views20mActivity 4.0510mPractice Level 1: Remerging Summary Statistics20mPractice Level 2: Using a Subquery in the SELECT Clause with an In-Line Views20mSubqueries50m

Week5

Week 5

3 hours to complete

Set Operators

3 hours to complete

12 videos (Total 18 min), 4 readings, 6 quizzes

12 videos

Overview14sCombining Data Using Set Operators2mWhat Are Set Operators?2mUsing Set Operators1mUsing the INTERSECT Operator1mUsing the EXCEPT Operator1mUsing the UNION Operator34sDemo: Using the UNION Operator to Find All Unique Rows2mDefault Behavior of the UNION Operator36sCombining Set Operators40sUsing the OUTER UNION Operator48sDemo: Using the OUTER UNION Operator to Combine Tables3m

4 readings

Using a Set Operator Versus a Join10mUsing a Set Operator Versus a Subquery10mSQL Versus Traditional SAS Programming10mLearning More (optional)1m

6 practice exercises

Activity 5.0110mActivity 5.0210mPractice Level 1: Using the EXCEPT Set Operator20mPractice Level 2: Using the EXCEPT Set Operator with the DISTINCT Keyword20mPractice: Using the OUTER UNION Set Operator20mSet Operators50m

2 hours to complete

Using and Creating Macro Variables in SQL

2 hours to complete

7 videos (Total 15 min), 2 readings, 5 quizzes

7 videos

Overview16sCreating User-Defined Macro Variables2mCreating Data-Driven Macro Variables2mDemo: Using a PROC SQL Data-Driven Macro Variable2mCreating Multiple Macro Variables1mConcatenating Values into One Macro Variable1mDemo: Using PROC SQL to Concatenate Multiple Values into One Macro Variable4m

2 readings

Using Formats with Macro Variables10mLearning More (optional)1m

5 practice exercises

Activity 6.0110mActivity 6.0210mPractice Level 1: Creating a Macro Variable from an SQL Query20mPractice Level 2: Creating a Macro Variable with a List of Values from an SQL Query20mUsing and Creating Macro Variables in SQL50m

Week6

Week 6

2 hours to complete

Accessing DBMS Data with SAS/ACCESS

In this module, you learn about SAS/ACCESS technology to retrieve data from third party database management systems (DBMS). You learn about accessing data from a DBMS through the SQL Pass-Through Facility, which allows you to use the specific DBMS implementation of SQL, and the SAS/ACCESS LIBNAME statement, which translates SAS SQL to native DBMS SQL. Finally, you learn about the FEDSQL procedure to use vendor neutral SQL to push as much processing into the DBMS as possible.

2 hours to complete

15 videos (Total 24 min), 6 readings, 2 quizzes

15 videos

Overview23sDefining SAS/ACCESS Technology1mConnection Options41sOverview of the SQL Pass-Through Facility59sSteps for Using the SQL Pass-Through Facility3mDemo: Using an SQL Pass-Through Query3mSQL Pass-Through Facility Considerations57sOverview of the SAS/ACCESS LIBNAME Statement59sDemo: Using the SAS/ACCESS LIBNAME Statement3mSAS/ACCESS LIBNAME Considerations2mWhat Is PROC FEDSQL?56sComparing PROC SQL to PROC FEDSQL3mPROC FEDSQL Syntax47sExamining the Submitted SQL Code37sFedSQL and SAS Viya40s

6 readings

Note about the Demos that Access Databases in this Lesson10mSaving SQL Pass-Through Query Results10mAccess SAS DBMS-Specific Reference Documentation10mPROC SQL Versus PROC FEDSQL10mPROC SQL Versus PROC FEDSQL Cheat Sheet (optional)1mLearning More (optional)1m

2 practice exercises

Activity 7.0310mAccessing DBMS Data with SAS/ACCESS20m

2 hours to complete

Case Study (Honors) and Certification Practice Exam

2 hours to complete

3 readings

Reviews

4.9

53 reviews

5 stars
89.76%
4 stars
9.76%
3 stars
0.46%

TOP REVIEWS FROM STRUCTURED QUERY LANGUAGE (SQL) USING SAS

by SHOct 14, 2020

Really good course really appreciate the efforts they made to design this course

by SOSep 24, 2022

This course was great overview of SQL and it can be used in SAS.

by YYMar 25, 2021

Concise lectures, relevant exercises/quizzes, fun case study project, and prompt discussion forum help! 100% recommended!

by TWMar 27, 2021

Another fantastic course from SAS and Coursera! Even though I have been programming in SAS for several years, I learned quite a lot and enjoyed every minute of the course.

View all reviews

About the SAS Advanced Programmer Professional Certificate

When you complete this professional certificate program, you will have experience in SAS programming using SAS 9 and will be able to process data using Structured Query Language in the SAS environment, use the SAS macro facility to design, write, and debug dynamic macro programs, and use advanced DATA step techniques and procedures to manipulate data. These skills prepare you for the SAS Advanced Programming Professional certification exam.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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 Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, 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. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Structured Query Language (SQL) using SAS

About this Course