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 ...

You often need data that are stored in separate tables. For example, you may want to produce a report that gets information about flight delays from one table and boarding capacity from another.

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 ...