SAS® SQL 1: Essentials
SQL1 : SQ1M6
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 Should Attend
SAS programmers and business analysts
Prerequisites
Before attending this class, you should be able to do the following:
- Submit SAS programs on your operating system.
- Create and access SAS data sets.
- Use arithmetic, comparison, and logical operators.
- Invoke SAS procedures.
SAS Products Covered
Base SAS
Course Outline
Essentials
- Setting up for this course.
- Overview of SAS Foundation.
- Course logistics.
- Course data files.
- Introducing the Structured Query Language.
- Overview of the SQL procedure.
- Exploring tables.
- Specifying columns.
- Subsetting data.
- Presenting data.
- Summarizing data.
- Creating and managing tables.
- Using DICTIONARY tables.
- Introduction to SQL joins.
- Inner joins.
- Outer joins.
- Complex SQL joins.
- Noncorrelated subqueries.
- Correlated subqueries.
- In-line views.
- Creating views with the SQL procedure.
- Subqueries in the SELECT clause.
- Remerging summary statistics.
- Introduction to set operators.
- The INTERSECT operator.
- The EXCEPT operator.
- The UNION operator.
- The OUTER UNION operator.
- Interfacing PROC SQL with the macro language.
- Creating data-driven macro variables with a query.
- Using macro variables in SQL.
- Overview of SAS/ACCESS technology.
- SQL pass-through facility.
- SAS/ACCESS LIBNAME statement.
- PROC FedSQL.
Live Class Schedule
Duration: 14 hours
Step into our live classes and experience a dynamic learning environment where you can ask questions, share ideas, and connect with your instructor and classmates. With on-demand lab hours, you can explore the material at your own pace. Our globally acclaimed instructors will motivate you to think bigger, so you can take what you've learned and achieve your biggest goals.
Live Class Schedule
SOLD SEPARATELY
08-12 DEC 2025
Live Web, US
1:00 PM-4:30 PM EST
English
1,600 USD
06-07 JAN 2026
Live Web, US
9:00 AM-5:00 PM EST
English
2,000 USD
26-30 JAN 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
02-06 MAR 2026
Live Web, US
1:00 PM-4:30 PM EST
English
2,000 USD
23-26 MAR 2026
Live Web, US
10:30 AM-3:00 PM EDT
Spanish
1,600 USD
Private Training
Get training tailored specifically for your team, led by expert SAS instructors. Choose from virtual sessions, or training at your location (or ours). Perfect for teams seeking a customized curriculum and plenty of interaction with a SAS specialist. We'll schedule it at a time that works for you.
Mentoring Services
Take your training to the next level with personalized mentoring. While private training offers structured coursework, mentoring provides hands-on, real-time support from a subject matter expert. As you work with your own data, you'll receive expert guidance to help you uncover insights, unlock the full potential of your data, and make faster progress. Perfect for those looking to apply what they’ve learned and see quicker results.
This course helps prepare you to earn the following SAS Knowledge Badge:
This course helps prepare you to earn the following SAS Credentials:
SAS Certification Manager
SAS partners with Pearson VUE to provide you with the best possible certification experience.
Certification Resources
