SAS® 9.4 Cert Prep: Part 12 Combining Tables
28mBeginner2020-01-07
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 exam. Here you can explore techniques to consolidate your data by combining tables with the SAS DATA step. Instructor Stacey Syphus explains how to concatenate and merge tables and identify matching and nonmatching rows. Plus, learn the difference between a DATA step merge and the PROC SQL join.
Skills covered
SASStatisticsCert PrepData Science
Concepts
0. Introduction
- 01 - Combine tables to consolidate your data
1. Concatenating Tables
- 02 - Concatenating tables with matching columns
- 03 - Demo - Concatenating tables
- 04 - Handling column attributes
2. Merging Tables
- 05 - What is a merge
- 06 - Processing a one-to-one merge
- 07 - Processing a one-to-many merge
- 08 - Demo - Combining
3. Identifying Matching and Nonmatching Rows
- 09 - Merging tables with nonmatching rows
- 10 - Identifying matches and nonmatches
- 11 - Demo - Merging tables with nonmatching rows
- 12 - Merging tables with matching column names
- 13 - Merging tables without a common column
- 14 - DATA step merge and PROC SQL Join
Related courses
- SAS® 9.4 Cert Prep: Part 14 Restructuring Tables
- SAS® 9.4 Cert Prep: Part 06 Exporting Results
- SAS® 9.4 Cert Prep: Part 07 Using SQL in SAS
- SAS® 9.4 Cert Prep: Part 09 Summarizing Data
- SAS® 9.4 Cert Prep: Part 10 Manipulating Data with Functions
- SAS® 9.4 Cert Prep: Part 01 SAS Programming Essentials
- SAS® 9.4 Cert Prep: Part 02 Accessing Data
- SAS® 9.4 Cert Prep: Part 05 Analyzing and Reporting on Data