topic Re: How to merge two datasets and exclude date from one? in SAS Programming

How to merge two datasets and exclude date from one?

sasnewbie5 — Mon, 10 Dec 2018 22:29:30 GMT

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.

Re: How to merge two datasets and exclude date from one?

r_behata — Mon, 10 Dec 2018 22:39:08 GMT

Assuming EmpId is Unique :

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

	if a and not b;
run;

Re: How to merge two datasets and exclude date from one?

PGStats — Mon, 10 Dec 2018 22:39:51 GMT

Simply:

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

Re: How to merge two datasets and exclude date from one?

PeterClemmensen — Mon, 10 Dec 2018 22:50:24 GMT

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;