SAS SQL 1: Essentials
*Please Note: Completing the registration form will result in the generation of an invoice. Payment is expected within 30 days of course completion. Cancellation less than two weeks prior to class start date will result in a cancellation fee equal to 50% of the registration cost. No Exceptions.
Course Overview
This course teaches you how to process SAS data using Structured Query Language (SQL).
This course can help prepare you for the following certification exam(s): SAS Advanced Programming for SAS 9.
Learn how to
- query and subset data
- summarize and present data
- combine tables, including complex joins and merges
- create and modify table views and indexes
- replace multiple DATA and PROC steps with one SQL query.
Who should attend
SAS programmers and business analysts.
Prerequisites
Before attending this class, you should be able to
- submit SAS programs on your operating system
- create and access SAS data sets
- use arithmetic, comparison, and logical operators
- invoke SAS procedures.
You can gain this experience from the SAS Programming 1: Essentials course. No knowledge of SQL is necessary.
This course addresses Base SAS software.This course is appropriate for students who are using SAS 9 software.
Pricing
SAS SQL1: Essentials: $1,300
Course Outline
Note: This course will last all day for the length of the course. Most classes will start at 9:00AM and end at 5:00PM.
Introduction
- overview of SAS Foundation
- course logistics
- course data files
- introducing the Structured Query Language
Basic Queries
- overview of the SQL procedure
- specifying columns
- specifying rows
Displaying Query Results
- presenting data
- summarizing data
SQL Joins
- introduction to SQL joins
- inner joins
- outer joins
- complex SQL joins
Subqueries
- noncorrelated subqueries
- in-line views
Set Operators
- introduction to set operators
- the UNION operator
- the OUTER UNION operator
- the EXCEPT operator
- the INTERSECT operator
Creating Tables and Views
- creating tables with the SQL procedure
- creating views with the SQL procedure
Advanced PROC SQL Features
- dictionary tables and views
- using SQL procedure options
- interfacing PROC SQL with the macro language
Learning More
- SAS resources
- beyond this course
Course Logistics
Location: FedEx Institute of Technology, 365 Fogelman Drive
Duration: 9:00 AM - 5:00 PM CST
We ask that attendees bring their own device in order to follow along with the class presentations. The temperature in our training room tends to be cooler, we advise you to bring a light jacket or sweater. Parking passes are provided for the garage across to the FedEx Institute of Technology (located on Fogelman Drive).
If you have any additional questions please let us know at fedex@memphis.edu.
Travel Information
Click here to learn more about travel information.