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.
Overview
Loading...
Reviews
4.9 (215 ratings)
- 5 stars89.76%
- 4 stars9.76%
- 3 stars0.46%
V
Feb 14, 2022
Good instructions, videos, quizzes, and assignments. Instructors also provided additional resources. So much easier using SQL in SAS than standard SAS language.
SP
Sep 16, 2021
It was an amazing experience learning from coursera. Truly one of the best. I just wish that they had provided with more of practice exercises for each topic .
From the lesson
Set Operators
In this module, you learn to concatenate tables vertically using the INTERSECT, EXCEPT, UNION and OUTER UNION set operators. You learn the difference between the set operators, as well as how to use modifiers to adjust the default behavior.
Taught By
Peter Styliadis
Senior Technical Training Consultant
Explore our Catalog
Join for free and get personalized recommendations, updates and offers.
Coursera Footer
© 2023 Coursera Inc. All rights reserved.
