SAS SQL "joinless" syntax

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 5
Accepted Solution

SAS SQL "joinless" syntax

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?


Accepted Solutions
Solution
‎09-28-2017 05:28 PM
Respected Advisor
Posts: 4,284

Re: SAS SQL "joinless" syntax

@SAS_Ryan

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

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

View solution in original post


All Replies
Solution
‎09-28-2017 05:28 PM
Respected Advisor
Posts: 4,284

Re: SAS SQL "joinless" syntax

@SAS_Ryan

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 119 views
  • 0 likes
  • 2 in conversation