Overview This course teaches you how to process SAS data using Structured Query Language (SQL).
2 DaysLive Online & In-CenterInstructor-led since 1983Course Code: XSASQL
Course overview
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.
or equivalent.
Number of Class Days
2 days