Welcome to ONLC Training Centers

SAS SQL

Class Dates
(click date for class times)
(click Enroll for locations)

Fee:  $795

Savings options:

 Learning Credits
Need a price quote?

Follow the link to our self-service price quote form to generate an email with a price quote.

Need a class for a group?

We can deliver this class for a private group at your location. Follow the link to request more information.

Email Alert

Receive an email when this class is available as "Ready to Run" or "Early Notice" status.

Attend from your office or home

If you have high-speed internet and two computers you can likely take this class from your office or home.


SAS SQL Course Outline

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 this class is for?
SAS programmers, DBA’s, and business analysts.
Anyone who is moving from using SQL to SAS.

Prerequisites
SAS Fundamentals course or equivalent.

Number of Days
2 days

COURSE OUTLINE

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.

View outline in Word

XSASQL

Attend hands-on, instructor-led SAS SQL training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Courses and select the one that's right for you.

GENERAL INFO

Class Format
Class Policies
Student Reviews


HAVE QUESTIONS?
First Name

Last Name

Company

Phone

Email

Location

Question/Comment



ONLC TRAINING CENTERS
www.onlc.com