SQL Processing with SAS®
Duration: 2 days
If you experience any problems with our on-line booking service, you can call us on
+44 (0)131 225 6952.
Description
This two day course focuses on using SQL as a data query and manipulation tool with SAS.
You learn to use the SQL procedure as a powerful and efficient data retrieval tool within SAS programs.
Objectives
After attending this course you will be able to:
- perform queries on data involving column calculations and functions, subsets, summaries and subqueries
- retrieve data from multiple tables using subqueries, joins and set operations
- create views, indexes and tables
- update or delete values in existing tables and views
- use SQL procedure features to debug, test and optimize performance of SQL queries
Prerequisite Skills
Before attending this course, 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® Essentials: An Introduction
to SAS® Programming course.
No knowledge of SQL is necessary.
SAS® System Modules used
This course covers Version 9 of Base SAS®.
Course Topics
Introduction
- Structured Query Language
- SAS Functions
- Case Study
Basic Queries
- Overview of the SQL Procedure
- Specifying Columns
- Specifying Rows
- Presenting Data
- Summarising Data
- Subqueries
Combining Tables
- Overview
- Joins
- Complex Joins
- Set Operators
Creating and Modifying Tables and Views
- Creating Tables
- Creating Views
- Creating Indexes
- Maintaining Tables
Additional SQL Features
- Setting Proc SQL options
- Dictionary Tables and Views
- Interfacing Proc SQL with SAS® Macro Language (optional)
- Program Testing and Performance
Reserve your place on this Newtyne SAS Training Course
|
