hash vs proc sql join

[Babloo]

Could you please help me understand the difference between hash join and proc sql join?

[Kurt_Bremser]

Maxim 1: Read the Documentation

Data Step Component Objects

SQL Procedure Users Guide

[Kurt_Bremser]

And use the search function of the communities to find hash- and SQL-related posts.

[novinosrin]

Hi @Babloo  , Besides documentation, why not invest in some books offered by SAS press?

PROC SQL: Beyond the Basics Using SAS, Second Edition

[Kurt_Bremser]

And that's a very fine introduction to hash programming:

SAS Hash Object Programming Made Easy

[LinusH]

Perhaps just adding confusion, but "hash" is a quite generic term. If one refer to the programming technique in the data step, I think we should call it Hash Table (join).

Because, you can do hash joins in SQL as well (but here it happens behind the scenes given certain criteria’s, upon which the optimizer makes a decision what algorithm to use).