SQL Processing with SASŪ

Role

Data Manager, SAS Programmer.

Duration

2 days

Description

This course focuses on using SQL as a data query and manipulation tool with SASŪ software. You learn to use the SQL procedure as a powerful and efficient data retrieval tool within SAS programs.

Prerequisites

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 Programming course. No knowledge of SQL is necessary.

SAS Modules Used

Course Topics

Introduction:

Structured Query Language

• SAS Functions
• Case Study

Basic Queries:

• Overview of the SQL Procedure
• Specifying Columns
• Specifying Rows
• Presenting Data
• Summarizing 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 Macro Language (Optional)
• Using the SQL Procedure Pass-Through Facility
• Program Testing and Performance

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 optimise performance of SQL queries.