Hands-On SAS for Data Analysis

Right join

The only difference from the left join is that the records from the right table are selected whether a match is found or not. In Proc SQL the order of the tables in the join is critical. However, this isn't the case in the merge process using data steps. The following diagram shows a right join Venn diagram:

We will now keep the Interests table as the right-hand table and attempt a right join with the Class table:

Proc Sql;            Create table Right_Join as            Select A., B.            From Class as A            Right Join Interests as B            On A.ClassID=B.ClassID            ;Quit;

As you can see, the code is similar to what we used earlier except for the fact that we have now ...