SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS
16mBeginner2020-01-06
Authors
SAS Institute
Business analytics software and services
Course details
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.
Skills covered
SASStatisticsSQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisCert PrepProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Outside language integration with SAS
1. Using Structured Query Language (SQL) in SAS
- 02 - SQL and SAS
- 03 - PROC SQL syntax
- 04 - Filtering and sorting output
- 05 - Demo - Reading and filtering data with SQL
- 06 - Creating and deleting tables in SQL
2. Joining Tables Using SQL in SAS
- 07 - Creating inner joins in SQL
- 08 - Demo - Joining tables with PROC SQL
- 09 - Using table aliases