Wow--thank you Reeza for such a comprehensive answer. I will work through this and update you on the result. The version of SAS Enterprise Guide that I am using is more of a GUI/low code environment so I have not written any custom programs. I've already learned a lot--syntax especially--from the snippet of code to recreate the two rows of data. Thank you again, I am diving into this today. ... View more

Thanks for explaining this Tom. I will try to recreate this data in a program to share. Like I said, I am new, but I'll give it a shot. I appreciate your guidance. ... View more

Interesting! Thanks for this piece of code. I am a total newbie so bear with me. My source data comes from work.setup_meets and my output is named work.count_meets. Here is the code I used and the result. Any ideas on where I went wrong here? Thanks for your guidance! data work.count_meets; set work.setup_meets; total=0; do day = bannerstartdate to bannerenddate ; total + ( 0 < whichn(weekday(day), '1','2','3','4','5','6','7') ); end; run; Output ... View more

Originally I was trying to assign each weekday it's numerical equivalent in SAS and somehow create some sort of crosswalk to assign these days to the dates. This didn't end up working and I just never removed it. I do not need those columns at all. Great catch, thanks! ... View more

Yes, that logic is correct: The 1st row meets every Tuesday and Thursday between January 10, 2022 and March 1, 2022. I counted the number of Tuesdays and Thursdays in this date range to arrive at 15.    You make a great point, I had not considered holidays. Standard US Holidays should be excluded from the count if this is possible. If not, that's ok. Thanks for your guidance! ... View more

Certainly, thanks for your help.   The 1st row meets every Tuesday and Thursday between January 10, 2022 and March 1, 2022. I counted the number of Tuesdays and Thursdays in this date range to arrive at 15.    The 2nd row meets every Monday and Wednesday between January 10, 2022 and May 5, 2022. I counted the number of Mondays and Wednesdays in this date range to arrive at 34.   Thank you ... View more

Thanks so much for explaining this. I have updated the post. 😊 ... View more