SAS SQL

This course teaches you how to process SAS data using Structured Query Language (SQL). Learn How 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. Who Is SAS SQL For? SAS programmers, DBA’s, and business analysts. Anyone who is moving from using SQL to SAS.

Essentials • Setting up the course files and library. • Introducing the Structured Query Language. • Overview of the SQL procedure. • Exploring tables. • Specifying columns. PROC SQL Fundamentals • Subsetting data. • Presenting data. • Summarizing data. • Creating and managing tables. • Using DICTIONARY tables. SQL Joins • Introduction to SQL joins. • Inner joins. • Outer joins. • Complex SQL joins. Subqueries • Noncorrelated subqueries. • Correlated subqueries. • In-line views. • Creating views with the SQL procedure. • Subqueries in the SELECT clause. • Remerging summary statistics. Set Operators • Introduction to set operators. • The INTERSECT operator. • The EXCEPT operator. • The UNION operator. • The OUTER UNION operator. Using and Creating Macro Variables in SQL • Interfacing PROC SQL with the macro language. • Creating data-driven macro variables with a query. • Using macro variables in SQL.