topic Re: PROC SQL Joins on 3 Tables in SAS Data Management

PROC SQL Joins on 3 Tables

Ujjawal — Wed, 15 Apr 2015 19:17:07 GMT

How can we use LEFT JOIN when we have more than 2 tables? PROC SQL equivalent code for the following merge statement code?l

Data abc;

merge a (in=X) b c;

by id;

if X;

run;

Re: PROC SQL Joins on 3 Tables

SASKiwi — Wed, 15 Apr 2015 20:01:56 GMT

proc sql

create table abc as

select *

from a

left join b

on a.id = b.id

left join c

on a.id = c.id;

quit;

Re: PROC SQL Joins on 3 Tables

SteveED — Wed, 30 Aug 2017 14:41:28 GMT

@SASKiwi gives a good example of a 3 table join.

The example @Ujjawal gave though is for a match-merge which would generate (potentially) different results. HERE is a link to a SUGI 30 paper highlighting the differences (there are many other papers as well). There are reasons to use the different types of merge/joins depending on the need.

Steve