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. 鈥淏y 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...
Skills You'll Learn
Data Presentation, Database Management, Data Manipulation, Data Access, Data Processing, SAS (Software), Query Languages, Database Management Systems, Data Integration, SQL
Reviews
4.9 (282 ratings)
- 5 stars90.07%
- 4 stars9.21%
- 3 stars0.35%
- 1 star0.35%
SP
Sep 17, 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 .
RC
Jun 24, 2021
G鈥媟eat course! If you can follow this course, you will be no problem on SAS advanced certificate! The contents are much more indepth than the exam requirement!
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