topic Re: Unmatched query in ODS and Base Reporting

Unmatched query

Gil_ — Fri, 21 Jun 2019 18:20:47 GMT

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;

Re: Unmatched query

Reeza — Fri, 21 Jun 2019 18:30:07 GMT

Ok, so what's the question here?

Re: Unmatched query

Gil_ — Fri, 21 Jun 2019 18:48:58 GMT

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

Re: Unmatched query

utrocketeng — Fri, 21 Jun 2019 18:54:33 GMT

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;

Re: Unmatched query

Gil_ — Fri, 21 Jun 2019 19:06:29 GMT

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

Re: Unmatched query

anushreebiotech — Sat, 22 Jun 2019 05:49:26 GMT

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