topic sas inner join vs left join with same data set in SAS Procedures

sas inner join vs left join with same data set

Sasadomo — Fri, 15 Jun 2018 01:32:09 GMT

I am wondering if there's any difference between inner join and left join if I am self merging.

Say I use the DOSING data set in the following document

And I condition it on patient ID = patient ID, Then using inner join and left join would create the same result right?

SASKiwi — Fri, 15 Jun 2018 01:41:35 GMT

Why not try it and prove it to yourself?

RW9 — Fri, 15 Jun 2018 07:48:59 GMT

There are plenty of resources that graphically show what joins do.

Kurt_Bremser — Fri, 15 Jun 2018 09:17:17 GMT

Maxim 4.