Exploring PROC SQL ® Joins and Join Algorithms

Real systems rarely store all their data in one large table. To do so would require maintaining several duplicate copies of the same values and could threaten the integrity of the data. Instead, IT departments typically split their data among several different tables. As a result, a method is needed to access two or more tables to help answer the interesting questions about our data. This presentation describes the various join algorithms as well as the join processes including Cartesian product joins, inner joins, and outer joins.