It would be fine to try MAGIC=103 option in PROC SQL statement. Option Description MAGIC=101 Influences the SQL optimizer to select the Nested Loop join algorithm. MAGIC=102 Influences the SQL optimizer to select the Sort-Merge join algorithm. MAGIC=103 Influences the SQL optimizer to select the Hash join algorithm http://www.mwsug.org/proceedings/2012/S1/MWSUG-2012-S109.pdf
... View more