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
Databases, Data Management, Data Analysis, Computer Programming, Statistical Programming, 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
Essentials
In this module, you learn about the Structured Query Language (SQL) and begin exploring data using the SQL procedure in SAS.
Taught By
Peter Styliadis
Senior Technical Training Consultant