How to merge two datasets and exclude date from one?

[sasnewbie5]

I have attached the two datasets I'm working with. I need to merge the staffmaster and staffchanges datasets but exclude the people found in the staff changes from the staffmaster dataset. How could I go about doing that? I've attached the two datasets.

[r_behata · Accepted solution]

Assuming EmpId is Unique :

data want;
	merge staff.staffmaster(in=a) staff.staffchanges(in=b);
	by empid;

	if a and not b;
run;

[PGStats]

Simply:

proc sql;
create table StaffCurrent as
select * from StaffMaster
where empId not in (select empId from StaffChanges);
quit;

[PeterClemmensen]

data want;
   if 0 then set staff.staffchanges;
   if _N_ = 1 then do;
      declare hash h(staff.staffchanges);
      h.defineKey('empid');
      h.defineData(all:"Y");
      h.defineDone();
   end;

   set staff.staffmaster;

   rc=h.check();
   if rc ne 0;
run;