proc sql; title 'Left Outer Join'; select * from lefttab as l left join righttab as r on l.continent=r.continent; A right outer join, specified with the keywords RIGHT JOIN and ON, has all the rows ...

This example illustrates a left outer join of the PROCLIB.PAYROLL and PROCLIB.PAYROLL2 tables. proc sql outobs=10; title 'Most Current Jobcode and Salary Information'; select p.IdNumber, p.Jobcode, ...