Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

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

via LinkedIn Learning

Overview

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.

Syllabus

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

Taught by

SAS Institute

Reviews

Start your review of SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.