topic Re: SAS Enterprise Guide Left Join in New SAS User

SAS Enterprise Guide Left Join

dxtran — Fri, 10 Jan 2020 15:11:45 GMT

Hello

I'm refreshing my knowledge on SAS EG. I have table A that contains a list of all employees since the beginning of time and table B that has a list of all employees who terminated. I want to keep only employees from A who are still with the company. I can do this in Access with a left join A to B on EmpID where B.EmpID is null (Pictorially). I don't know how to do this in EG once I do a left join. How/where do I set the condition B.EmpID is null?

Thank you

Re: SAS Enterprise Guide Left Join

JeffMaggio — Fri, 10 Jan 2020 15:16:39 GMT

I would use a set operator for this:

proc sql; 

create table want as 
select * from a 
   except 
   select * from b; 

quit;

Re: SAS Enterprise Guide Left Join

dxtran — Fri, 10 Jan 2020 15:43:20 GMT

Thank you, this is great! However, I was hoping for a solution in EG, not code, which I know would be difficult to illustrate here. 😞 but I think I'll "cheat" and build the code in EG. 🙂