topic Re: Determine no orders in ODS and Base Reporting

Determine no orders

Gil_ — Sat, 16 Feb 2019 06:10:41 GMT

I have a table that derermines orders on off days it looks like this SUN THRU SAT is weekly sch N no orders Y yes order

Id. Date s. m tue. wed thu fri sat
A1. 02/14/19. N. Y. N. Y. Y. N. N
B1. 02/14/19. N. Y. N. Y. N N. N

As you can see A1 02/14/19 is done correctly
And B1 was done on wrong sch date
I would need the ones done on wrong sch day to
Create a different dataset . Its should vary count from 3 to 300 .. thank you for the help

Re: Determine no orders

Patrick — Sat, 16 Feb 2019 06:32:43 GMT

"I have a table that derermines orders on off days it looks like this SUN THRU SAT is weekly sch N no orders Y yes order"

I can't make sense of your description. Can you please elaborate/re-formulate.

Re: Determine no orders

Gil_ — Sat, 16 Feb 2019 14:56:33 GMT

Ok my table looks like this
Id. Date s. m tue. wed thu fri sat
A1. 02/14/19. N. Y. N. Y. Y. N. N
B1. 02/14/19. N. Y. N. Y. N N. N
The date is day of order sun-Sat is the schedule days order should be place. A1 is good since order was done on thur and sch indicates Y on Thur. Im interested only on the ones that had order place but weren't Scheduled like B1

Re: Determine no orders

Cynthia_sas — Sat, 16 Feb 2019 14:57:30 GMT

Hi:
I agree with @Patrick, your question is not clear. In addition, you seem to think that B1 is incorrect, but I don't see what is wrong with B1, if you say that A1 is correct.

Cynthia

Re: Determine no orders

Tom — Sat, 16 Feb 2019 16:37:27 GMT

Use the WEEKDAY() function.

data have;
  input id $ date (d1-d7) (:$1.);
  informat date mmddyy.;
  format date yymmdd10. ;
cards;
A1  02/14/19  N  Y  N  Y  Y  N  N
B1  02/14/19  N  Y  N  Y  N  N  N
;

data check;
  set have ;
  array sched d1-d7 ;
  bad = 'Y' ne sched(weekday(date));
run;

Obs    id       date       d1    d2    d3    d4    d5    d6    d7    bad

 1     A1    2019-02-14     N     Y     N     Y     Y     N     N     0
 2     B1    2019-02-14     N     Y     N     Y     N     N     N     1

Re: Determine no orders

Gil_ — Sat, 16 Feb 2019 15:13:02 GMT

Thank you Tom will give it a try

Re: Determine no orders

Gil_ — Sat, 16 Feb 2019 15:16:06 GMT

Cynthia
The reason B1 is incorrect is the order was placed on 02/14/19. And per the schedule thur has a N. Which means the order was place on off day

Re: Determine no orders

Reeza — Sat, 16 Feb 2019 18:17:29 GMT

So for the order date, you need to find that day of the week, ie February 14, 2019 is a Thursday, so Thursday should have a Y. Since it doesn't you flag that record?

@Gil_ wrote:
Cynthia
The reason B1 is incorrect is the order was placed on 02/14/19. And per the schedule thur has a N. Which means the order was place on off day

Re: Determine no orders

Gil_ — Fri, 22 Feb 2019 20:28:47 GMT

Thanks Tom