SAS® 9.4 Cert Prep: Part 12 Combining Tables

Prepare to take the SAS 9.4 certification exam. Learn how to consolidate your data by combining tables with the SAS DATA step.

Introduction

• Combine tables to consolidate your data

1. Concatenating Tables

• Concatenating tables with matching columns
• Demo: Concatenating tables
• Handling column attributes

2. Merging Tables

• What is a merge?
• Processing a one-to-one merge
• Processing a one-to-many merge
• Demo: Combining

3. Identifying Matching and Nonmatching Rows

• Merging tables with nonmatching rows
• Identifying matches and nonmatches
• Demo: Merging tables with nonmatching rows
• Merging tables with matching column names
• Merging tables without a common column
• DATA step merge and PROC SQL Join