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.
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 stars
90.07%
4 stars
9.21%
3 stars
0.35%
1 star
0.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
Course Overview and Data Setup
In this module you get an overview of what you learn in this course and you set up the software and data you use for activities and practices in the course.