topic Re: i need to find out the months in which 4 sunday and 4 saturday are there in the last three years in SAS Programming

i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

prianca — Tue, 19 Feb 2019 07:23:40 GMT

i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

Re: i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

Kurt_Bremser — Tue, 19 Feb 2019 07:36:30 GMT

For every possible month length (31/30/29/28 days), determine the weekdays on which the first has to fall for the condition to be true.

Then do a loop over months and look if the first falls on one of these weekdays.

Re: i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

FreelanceReinh — Tue, 19 Feb 2019 08:49:45 GMT

Hello @prianca and welcome to the SAS Support Communities!

You can use the NWKDOM function:

data want;
do y=2016 to 2018;
  do m=1 to 12;
    if (nwkdom(4,1,m,y)=nwkdom(5,1,m,y))
     & (nwkdom(4,7,m,y)=nwkdom(5,7,m,y)) then output;
  end;
end;
run;

(This assumes that you mean "exactly 4 Sundays and exactly 4 Saturdays" -- otherwise the task would be trivial, after all.)

Re: i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

Kurt_Bremser — Tue, 19 Feb 2019 09:26:01 GMT

... and every now and then, Maxim 9 does an end-around on me 🙂

Re: i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

prianca — Tue, 19 Feb 2019 10:03:36 GMT

find out the months in which last days are weekends????

Re: i need to find out the months in which 4 sunday and 4 saturday are there in the last three years

Kurt_Bremser — Tue, 19 Feb 2019 10:08:59 GMT

where weekday(intnx('month',mdy(month,1,year),0,'e')) in (1,7);