Black Friday 2024: 25+ Ways to Save on Online Learning

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

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Grab it
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

Go to class

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.