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

Offered By: LinkedIn Learning

Tags

Sass Courses Data Analysis Courses SQL Courses Data Sorting Courses Data Filtering Courses Data Manipulation Courses Database Management Courses

Course Description

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.

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

Related Courses

Apply advanced testing for your Django web application
Coursera Project Network via Coursera Amazon Aurora Service Introduction
Amazon Web Services via AWS Skill Builder Amazon Aurora Service Introduction (Italian)
Amazon Web Services via AWS Skill Builder Amazon Aurora Service Introduction (Japanese) (日本語字幕版)
Amazon Web Services via AWS Skill Builder Amazon Aurora Service Primer
Amazon Web Services via AWS Skill Builder