SAS® 9.4 Cert Prep: Part 12 Combining Tables

Offered By: LinkedIn Learning

Tags

SAS Courses Data Manipulation Courses

Course Description

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

Related Courses

Excel 2010
Miríadax Intro to Data Science
Udacity Data Manipulation at Scale: Systems and Algorithms
University of Washington via Coursera Statistical Computing with R - a gentle introduction
University College London via Independent Introducción a Data Science: Programación Estadística con R
Universidad Nacional Autónoma de México via Coursera