PROC SQL follows most of the guidelines set by the American National Standards Institute (ANSI) in its implementation of SQL. However, it is not fully compliant with the current ANSI Standard for SQL.

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