Structured Query Language (SQL) using SAS

SAS

data-analysis   |   Advanced   |   18 Hours

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…”
●\tQuery and subset data.
●\tSummarize and present data.
●\tCombine tables using joins and set operators.
●\tCreate and modify tables and views.
●\tCreate data-driven macro variables using a query.
●\tAccess DBMS data with SAS/ACCESS technology.

What skills will you gain?

Databases

join (sql)

pro*c

modulo operation

macro (computer science)

having (sql)

order by

null coalescing operator

euler's totient function

Rowing