your the man! ... View more

Patrick - ok, I took out a ; and it worked!! and again, can't thank you enough!!    ... View more

I added your code and I didn't get any errors!  however, I also didn't get any obs.  I am not sure which is worse. lol.    and I apologize for the 5 day break confusion. disregard that.  I just need to know if there is break in consecutive biz days.  With no detail in the log as to why zero obs came back, I am not sure what went wrong.      ... View more

Again, I really appreciate you taking the time!  However, I still am not getting the output I am looking for.  And your code is WAY above my head so I highly doubt it is you!!  Very impressive to say the least, btw.   With that said, I decided to take another approach by using multiple data steps to create additional variables that ultimately created a column 'day_int' with 0/1 values.  0 being the start date then value of 1 for each date thereafter accounting for holiday/weekend and if there was a skip of more than 1 it started over at 0. I then added:   if day_int = 0 then x=1 ; else x+1;   Which provided a the variable X, counting each line....ex, 1-17, 1-4, 1-59, 1-223, 1-8, 1-9, etc....   From there I added :   if x>9 then output;   Which worked (kind of) it outputted all those that exceeded 10+ days, but only lines 10-17, 10-59, 10-223, etc.... it did not include 1-4, 1-8, or 1-9 which was good,  but for the 10+,  I need lines 1-17, 1-59, 1-223 vs starting from 10.  Any suggestions on doing that?    Thanks again!!   ... View more

Thank you.  Below is an example of the data.  The impact font lines are is what needs to be in the output dataset. They are in 10+ consecutive business day order.  For example, the first 9 lines are in order then there is Mar 14th missing, which is not a holiday or weekend. But then continues on Mar15 -Mar30 without a biz day break, which qualifies it for output. The account continues on Apr03-Apr17, however skips Apr04 which is not a holiday or weekend, therefor even know there are ten days, the skip of the 2nd prevents it from qualifying. It then starts back up on May21-Jun06 without a skip, so this section would be part of the output.  For account tr892, the only section would be from Mar09-24; the other lines would not apply due to breaks not involving holiday or weekends.  An account will not duplicate on the same day, however the income can fluctuate and does not apply but is needed in the output. There may be other variables needed as well, including income, but kept it short for learning purpose.  Thanks again for any assistance you may be able to provide.   data have;    input account_id $ date : date9.  income ;    format date date9.; datalines; ac245 01MAR2012 22659 ac245 02MAR2012 22659 ac245 05MAR2012 22659 ac245 06MAR2012 22659 ac245 07MAR2012 22659 ac245 08MAR2012 22659 ac245 09MAR2012 22659 ac245 12MAR2012 22659 ac245 13MAR2012 22659 ac245 15MAR2012 22659 ac245 16MAR2012 22659 ac245 19MAR2012 22659 ac245 20MAR2012 22659 ac245 21MAR2012 22659 ac245 22MAR2012 22659 ac245 23MAR2012 19475 ac245 26MAR2012 22659 ac245 27MAR2012 6281 ac245 28MAR2012 22659 ac245 29MAR2012 22659 ac245 30MAR2012 22659 ac245 03APR2012 22659 ac245 05APR2012 22659 ac245 06APR2012 22659 ac245 09APR2012 22659 ac245 10APR2012 22659 ac245 11APR2012 22659 ac245 12APR2012 22659 ac245 13APR2012 22659 ac245 16APR2012 22659 ac245 17APR2012 22659 ac245 21MAY2012 12420 ac245 221MAY2012 12420 ac245 231MAY2012 12420 ac245 241MAY2012 12420 ac245 251MAY2012 12420 ac245 291MAY2012 12420 ac245 30MAY2012 12420 ac245 31MAY2012 12420 ac245 01JUN2012 12420 ac245 04JUN2012 12420 ac245 05JUN2012 12420 ac245 06JUN2012 12420 tr892 26JAN2022 1087 tr892 27JAN2022 1087 tr892 28JAN2022 1087 tr892 31JAN2022 1087 tr892 03FEB2022 1087 tr892 04FEB2022 1087 tr892 07FEB2022 1087 tr892 10FEB2022 1087 tr892 11FEB2022 1087 tr892 14FEB2022 1087 tr892 15FEB2022 1087 tr892 17FEB2022 1087 tr892 18FEB2022 1087 tr892 22FEB2022 1087 tr892 22FEB2022 1087 tr892 23FEB2022 1087 tr892 24FEB2022 1087 tr892 25FEB2022 1087 tr892 28FEB2022 1284 tr892 03MAR2022 1284 tr892 04MAR2022 1284 tr892 07MAR2022 1284 tr892 09MAR2022 1284 tr892 10MAR2022 1284 tr892 11MAR2022 1284 tr892 14MAR2022 1284 tr892 15MAR2022 1284 tr892 16MAR2022 1284 tr892 17MAR2022 1284 tr892 18MAR2022 1284 tr892 21MAR2022 1284 tr892 22MAR2022 1284 tr892 23MAR2022 1284 tr892 24MAR2022 1284 tr892 28MAR2022 1284 ; ... View more

correction, where it readys May17-Jun06,  s/b May21-Jun06 ... View more

Thank you.  Below is an example of the data.  The impact font lines are is what needs to be in the output dataset. They are in 10+ consecutive business day order.  For example, the first 9 lines are in order then there is Mar 14th missing, which is not a holiday or weekend. But then continues on Mar15 -Mar30 without a biz day break, which qualifies it for output. The account continues on Apr03-Apr17, however skips Apr04 which is not a holiday or weekend, therefor even know there are ten days, the skip of the 2nd prevents it from qualifying. It then starts back up on May17-Jun06 without a skip, so this section would be part of the output.  For account tr892, the only section would be from Mar09-24; the other lines would not apply due to breaks not involving holiday or weekends.  An account will not duplicate on the same day, however the income can fluctuate and does not apply but is needed in the output. There may be other variables needed as well, including income, but kept it short for learning purpose.  Thanks again for any assistance you may be able to provide.   data have;    input account_id $ date : date9.  income ;    format date date9.; datalines; ac245 01MAR2012 22659 ac245 02MAR2012 22659 ac245 05MAR2012 22659 ac245 06MAR2012 22659 ac245 07MAR2012 22659 ac245 08MAR2012 22659 ac245 09MAR2012 22659 ac245 12MAR2012 22659 ac245 13MAR2012 22659 ac245 15MAR2012 22659 ac245 16MAR2012 22659 ac245 19MAR2012 22659 ac245 20MAR2012 22659 ac245 21MAR2012 22659 ac245 22MAR2012 22659 ac245 23MAR2012 19475 ac245 26MAR2012 22659 ac245 27MAR2012 6281 ac245 28MAR2012 22659 ac245 29MAR2012 22659 ac245 30MAR2012 22659 ac245 03APR2012 22659 ac245 05APR2012 22659 ac245 06APR2012 22659 ac245 09APR2012 22659 ac245 10APR2012 22659 ac245 11APR2012 22659 ac245 12APR2012 22659 ac245 13APR2012 22659 ac245 16APR2012 22659 ac245 17APR2012 22659 ac245 21MAY2012 12420 ac245 221MAY2012 12420 ac245 231MAY2012 12420 ac245 241MAY2012 12420 ac245 251MAY2012 12420 ac245 291MAY2012 12420 ac245 30MAY2012 12420 ac245 31MAY2012 12420 ac245 01JUN2012 12420 ac245 04JUN2012 12420 ac245 05JUN2012 12420 ac245 06JUN2012 12420 tr892 26JAN2022 1087 tr892 27JAN2022 1087 tr892 28JAN2022 1087 tr892 31JAN2022 1087 tr892 03FEB2022 1087 tr892 04FEB2022 1087 tr892 07FEB2022 1087 tr892 10FEB2022 1087 tr892 11FEB2022 1087 tr892 14FEB2022 1087 tr892 15FEB2022 1087 tr892 17FEB2022 1087 tr892 18FEB2022 1087 tr892 22FEB2022 1087 tr892 22FEB2022 1087 tr892 23FEB2022 1087 tr892 24FEB2022 1087 tr892 25FEB2022 1087 tr892 28FEB2022 1284 tr892 03MAR2022 1284 tr892 04MAR2022 1284 tr892 07MAR2022 1284 tr892 09MAR2022 1284 tr892 10MAR2022 1284 tr892 11MAR2022 1284 tr892 14MAR2022 1284 tr892 15MAR2022 1284 tr892 16MAR2022 1284 tr892 17MAR2022 1284 tr892 18MAR2022 1284 tr892 21MAR2022 1284 tr892 22MAR2022 1284 tr892 23MAR2022 1284 tr892 24MAR2022 1284 tr892 28MAR2022 1284 ;     ... View more

This is great and I really appreciate you taking the time to respond! Sorry for delay in replying as this was my first ever post and I missed an email.  Anyway....   I forgot one minor detail, smh.  I need to account for holidays and weekends.  In other words, I neeUsing a holiday table with company dates, I need to somehow pull that in.   So an account needs to appear 10+ business days in a row.  Once it skips a business day, the count needs to start over. Each iteration of 10+ consec biz days per account needs to be output.          ... View more