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

Go to class Write review

Details

Go to class

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

28 minutes
Sessions

On-Demand

Found in

Part of

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

Overview

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