Skip to Main Content
Hands-On SAS for Data Analysis
book

Hands-On SAS for Data Analysis

by Harish Gulati
September 2019
Beginner to intermediate content levelBeginner to intermediate
346 pages
7h 35m
English
Packt Publishing
Content preview from Hands-On SAS for Data Analysis

Many-to-many merging

In the one-to-many merge illustration, we had multiple observations for the same BY group in dataset C. In a many-to-many merge situation, we can end up with multiple observations for the same BY group in different datasets. Let's use the same program we used in the one-to-many merging but with slightly modified datasets:

The merged output is as follows:

The merge was performed successfully as per the LOG. However, the output is incorrect in many ways. The following are a few lines of the LOG:

NOTE: MERGE statement has ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Big Data Analytics with SAS

Big Data Analytics with SAS

David Pope, Subhashini S Tripathi
An Introduction to SAS Visual Analytics

An Introduction to SAS Visual Analytics

Tricia Aanderud, Rob Collum, Ryan Kumpfmiller

Publisher Resources

ISBN: 9781788839822Supplemental Content