Proc SQL:

create table merged as 
select treat, removal_date from
Treatments, remdates
Where treatments.tid *= remdates.rid;
The *= is the left outer join operator and it means that all rows should be returned from 
the treatments table even if there is not a matching row from the remdates table.
The *= is the right outer join operator and it is used to specify that all rows should be 
returned from the table on the right side of the statement, in this case the remdates tables.
Some databases require a slightly different syntax for an outer join. Oracle uses the 
following syntax for their outer joins:
Proc SQL:
create table merged as 
select treat, removal_date from 
Treaments, remdates 
Where treatments.tid(+) = remdates.rid;