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