Then, you will create an outer join that combines this data with data from another table to compute the gross monthly pay for employees who have taken leave. Creating a Query View You can create an ...

a query-expression. A query-expression in the FROM clause ... table that do not match any row in the second (RIGHTTAB) table. proc sql; title 'Left Outer Join'; select * from lefttab as l left join ...