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

Left join

The dataset on the left-hand side of a join will be present in the output dataset irrespective of the matching records that the connecting dataset has. The following diagram is an illustration of a left join Venn diagram:

In the previous hospital inner join example, we had a list where recipients and donors matched. The hospital might be interested in retaining its recipient list and flagging instances when the donor is available. In such an instance a left joint becomes important.

In the case of the Class table, if we want to retain all the information and add on the information of the Interests table, we can use a left joint where ...

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