SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS

Prepare to take the SAS 9.4 certification exam. Learn how to integrate the power of SQL programming with SAS, in this SAS Institute cert prep course.

Want to get ahead in a crowded job market? Get certified with SAS. This course is part of a series by the SAS Institute, designed to prepare you for the SAS 9.4 certification. The following videos introduce you to methods to integrate the power of SQL programming with SAS. Instructor Stacey Syphus explains how SQL fits in the SAS pipeline and shows how to use SQL to filter and sort output and create and delete tables. Plus, learn how to join tables with SQL to easily combine your data.This course was created by SAS Institute. We are pleased to offer this training in our library.

Introduction

• Outside language integration with SAS

1. Using Structured Query Language (SQL) in SAS

• SQL and SAS
• PROC SQL syntax
• Filtering and sorting output
• Demo: Reading and filtering data with SQL
• Creating and deleting tables in SQL

2. Joining Tables Using SQL in SAS

• Creating inner joins in SQL
• Demo: Joining tables with PROC SQL
• Using table aliases