alias specifies an alias for table-name. sql-expression is described in sql-expression. table-name can be one of the following: the name of a PROC SQL table. the name of a SAS data view. a ...
RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.