topic Re: counting specific days between two dates in SAS Data Management

counting specific days between two dates

CynthiaFan — Tue, 04 Apr 2017 19:11:55 GMT

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

Re: counting specific days between two dates

Astounding — Tue, 04 Apr 2017 20:10:57 GMT

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;

Re: counting specific days between two dates

CynthiaFan — Mon, 24 Apr 2017 23:39:15 GMT

Thank you.