SAS PROC SQL -- JOIN

Reference:

http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#p0o4a5ac71mcchn1kc1zhxdnm139.htm

 

FULL JOIN puts all variables in two tables together regardless of any conditions (e.g., values missing, etc.).