Unmatched query

[Gil_]

I have a query that matches where stores rec ship based on sch I need to determine stores where ship were misd based on sch
My query looks
Proc SQL;
Create table part3 as
(Select * ,
B.Delivery
From part a left join sch b on a.id=b.id
Where a.day=b.day);
Run;

[Reeza]

Ok, so what's the question here?

[Gil_]

How do I determine sch ship that was not done. The query above gives me the stores that rec ship

[utrocketeng]

something like this?

Proc SQL;
Create table part3 as
(Select * ,
B.Delivery
From part a left join sch b on a.id=b.id and a.day=b.day
Where b.id is null);
Run;

[Gil_]

Question sch would not be null for example it has all the days with a sch date. When I match I have matching days part.date 06/19/19 sch.day=06/19/19. I would like to see where this happens. part.date 06/22 /19 sch.day=06/25/19. That means they weren't following the sch I need to see these

[anushreebiotech]

Hi,

Try this:

Proc SQL;
Create table part3 as

select * from part

where part.id not in
(Select * ,
B.Delivery
From part a join sch b on a.id=b.id
and a.day=b.day);
quit;

Regards,

Anushree