Table
|
Relevant Columns
|
---|---|
Sasuser.Staffchanges
lists information for all new employees and existing employees who
have had a change in salary or job code
|
FirstName, LastName
|
Sasuser.Staffmaster
lists information for all existing employees
|
FirstName, LastName
|
proc sql;
select firstname, lastname
from sasuser.staffchanges
intersect all
select firstname, lastname
from sasuser.staffmaster;