SAS SQL

Course Description:

The SAS SQL course teaches students 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 this class is for?
SAS programmers, DBAs, 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.

We offer live-instructor group training classes for your team.

Upskill your team from the comfort of your office or online.

Benefits of Group Training Include:

• Experienced Professional Instructor Trains Your Team
• Content Focused On Your Team's Needs
• Convenient Scheduling and Class Setup
• Significant Per/Student Cost Savings
• Online, On-Site and Blended Options Available

Get A Free Consultation