proc sql; title 'Full Outer Join'; select * from lefttab as l full join righttab as r on l.continent=r.continent; See Performing an Outer Join for another example. Joining More Than Two Tables: Inner ...

Passing Joins to the DBMS Prior to Version 7 of the SAS System, an SQL query involving one or more DBMS tables or view descriptors was processed by the SQL procedure as if the DBMS tables were ...