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

Social Network Analysis
University of Michigan via Coursera Intro to Algorithms
Udacity Data Analysis
Johns Hopkins University via Coursera Computing for Data Analysis
Johns Hopkins University via Coursera Health in Numbers: Quantitative Methods in Clinical & Public Health Research
Harvard University via edX