SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

counting specific days between two dates

Reply
Occasional Contributor
Posts: 8

counting specific days between two dates

Hi,

 

I have a question about how to calculate the numbers of specific days between two dates? For example, row 1 of the listed data has 34 Mondays plus Wednesdays and Saturdays between 8/29/2016 and 11/15/2016, how to program it?

 

d_start1 d_end1
8/29/2016 11/15/2016
8/29/2016 12/10/2016
8/29/2016 12/20/2016
8/29/2016 12/20/2016
8/29/2016 8/30/2016
8/29/2016 11/9/2016
8/29/2016 12/20/2016
8/29/2016 12/20/2016
8/29/2016 12/20/2016
8/29/2016 11/16/2016

 

Thank you.

 

Ying Ker

Super User
Posts: 5,503

Re: counting specific days between two dates

There may be shorter ways, but brute force is always a possibility:

 

n_Mondays=0;

n_Wednesdays=0;

n_Saturdays=0;

do i=d_start to d_end;

   wd = weekday(i);

   if wd=2 then n_Mondays + 1;

   else if wd=4 then n_Wednesdays + 1;

   else if wd=7 then n_Saturdays + 1;

end;

Occasional Contributor
Posts: 8

Re: counting specific days between two dates

Posted in reply to Astounding

Thank you.

Ask a Question
Discussion stats
  • 2 replies
  • 143 views
  • 1 like
  • 2 in conversation