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

SAS® 9.4 Cert Prep: Part 12 Combining Tables

via LinkedIn Learning

Write review

No Longer Offered

Details

No Longer Offered

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Effort

28 minutes
Sessions

No Longer Offered
Level

Intermediate

Found in

Part of

Prepare for the SAS 9.4 Base Programming (A00-231) Certification Exam

Noble Desktop

NY State-Licensed Certificates in Design, Coding & AI — Online

University of the People

Earn Your Business Degree, Tuition-Free, 100% Online!

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

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