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%
VW
Feb 15, 2022
Good instructions, videos, quizzes, and assignments. Instructors also provided additional resources. So much easier using SQL in SAS than standard SAS language.
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
SQL Joins
In this module, you learn about joining data horizontally from multiple tables using the Cartesian product. You learn how to perform INNER, OUTER and complex joins.
Taught By
Peter Styliadis
Senior Technical Training Consultant