Hi,   So I'm working in EG 7.1 and I have a dataset with over 4 million records and another dataset with around 200,000 records. For explanation purposes I'll call them lunch and time, respectively.   I need to output all the person_ids from lunch that aren't in time. I have tried the following -  proc sql; create table lunchtime as select * from lunch t1 where person_id not in (select person_id from time); quit; Proc SQL except function Left Join If in a and not b function Functionally, the code works. It's outputting around 3 million records which makes sense, however the result I need to get to is approx. 150,000. At this point I'm thinking that there's something my boss has forgotten to tell me about the data, however I was just wondering if anyone has any other ideas on how to do this?   Thanks in advance. ... View more