As the output shows, all rows from the left table, PROCLIB.PAYROLL, are returned. PROC SQL assigns missing values for rows in the left table, PAYROLL, that have no matching values for IdNum in PAYROLL2.
Most Current Jobcode and Salary Information
Id New New
Number Jobcode Salary Jobcode Salary
--------------------------------------------
1009 TA1 28880 .
1017 TA3 40858 .
1036 TA3 39392 TA3 $42,465
1037 TA1 28558 .
1038 TA1 26533 .
1050 ME2 35167 .
1065 ME2 35090 ME3 $38,090
1076 PT1 66558 PT1 $69,742
1094 FA1 22268 .
1100 BCK 25004 .
|