Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

SAS® 9.4 Cert Prep: Part 12 Combining Tables

via LinkedIn Learning

Write review

No Longer Offered

Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More → Babbel Ad

Start speaking a new language. It’s just 3 weeks away.

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Prepare to take the SAS 9.4 certification exam. Learn how to consolidate your data by combining tables with the SAS DATA step.

Syllabus

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

Taught by

SAS Institute

Reviews

4.9 rating at LinkedIn Learning based on 28 ratings

Start your review of SAS® 9.4 Cert Prep: Part 12 Combining Tables

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.