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

Access SQLite in an Android Studio Project
Coursera Project Network via Coursera Advanced SAS Programming Techniques
SAS via Coursera Advanced SQL
Kaggle الترجيح الإحصائي أو Statistical Weighting فى Microsoft Excel
Coursera Project Network via Coursera Análise de dados com programação em R
Google via Coursera