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

returns all matching rows in both tables, in addition to rows in the left table that have ... Creating a Query View You can create an SQL view that contains the syntax of your query. You will use this ...