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, ...

Read this SQL tutorial ... are several types of JOIN — LEFT, RIGHT, and FULL OUTER; INNER; and CROSS. The type you use is determined by the results you want to see. For example, using a LEFT ...