topic SAS SQL "joinless" syntax in SAS Programming

SAS SQL "joinless" syntax

SAS_Ryan — Thu, 28 Sep 2017 21:07:01 GMT

My coding style is to explicity define inner/left joins. That said, I've increasingly run into code like this which is effectively an inner join:

Proc SQL;

Create table abc as

select *

from

table1 A,

table2 B

where

a.key = b.key and a.id = b.id;

quit;

I recently ran into this:

Proc SQL;

Create table abc as

select *

from

table1 A,

table2 B

where

a.key = b.key (+) and a.id = b.id;

quit;

Can someone tell me what the (+) is doing?

Re: SAS SQL "joinless" syntax

Patrick — Thu, 28 Sep 2017 21:13:08 GMT

@SAS_Ryan

"Can someone tell me what the (+) is doing?"

That's Oracle syntax for implicit left or right joins.