SAS SQL 1: Essentials
SAS SQL 1: Essentials Course Details:
This course teaches you how to process SAS data using Structured Query Language (SQL).
No classes are currenty scheduled for this course.
Call (919) 283-1674 to get a class scheduled online or in your area!
1. Introduction
- Overview of SAS Foundation
- Course logistics
- Course data files
- Introducing the SQL
2. Basic Queries
- Overview of the SQL procedure
- Specifying columns
- Specifying rows
3. Displaying Query Results
- Presenting data
- Summarizing data
4. SQL Joins
- Introduction to SQL joins
- Inner joins
- Outer joins
- Complex SQL joins
5. Subqueries
- Noncorrelated subqueries
- In-line views
6. Set Operators
- Introduction to set operators
- The UNION operator
- The OUTER UNION operator
- The EXCEPT operator
- The INTERSECT operator
7. Creating Tables and Views
- Creating tables with the SQL procedure
- Creating views with the SQL procedure
8. Advanced PROC SQL Features
- Dictionary tables and views
- Using SQL procedure options
- Interfacing PROC SQL with the macro language
9. Learning More
- SAS resources beyond this course
*Please Note: Course Outline is subject to change without notice. Exact course outline will be provided at time of registration.
Exercises or hands-on workshops are included with most SAS courses.
SAS programmers and business analysts