topic Sunday for every year 1st JAN in SAS Programming

Sunday for every year 1st JAN

BrahmanandaRao — Fri, 30 Dec 2022 05:59:25 GMT

data ds (drop=st  ed);
do date='01jan1970'd to '01jan2023'd  by 12 ;
if weekday(date)=1 then output;
end;
format date date9.;
w=put(i,downame.);
proc print ;
run;

Herer i am trying to get 1st Jan comes in sundays for given date range

requiried output

1978, 1989, 1995, 2006, 2017, and 2023 years

1st Jan comes in suday

Re: Sunday for every year 1st JAN

andreas_lds — Fri, 30 Dec 2022 07:01:23 GMT

And the question is?

Re: Sunday for every year 1st JAN

BrahmanandaRao — Fri, 30 Dec 2022 08:30:53 GMT

I want get which years 1st Jan come sundays given date range

Re: Sunday for every year 1st JAN

Kurt_Bremser — Fri, 30 Dec 2022 08:33:11 GMT

Dates are counts of days, not counts of months. That's why BY 12 can't work.

Instead of an iterative DO loop, use a DO WHILE and the INTNX function to increment.

Re: Sunday for every year 1st JAN

Astounding — Fri, 30 Dec 2022 08:35:58 GMT

Here's one way to approach that.

data want;
  do year = 1970 to 2023;
      jan1 = mdy(1, 1, year);
      if weekday(jan1) = 1 then output;
   end;
   format jan1 date9.;
run;

Re: Sunday for every year 1st JAN

ballardw — Fri, 30 Dec 2022 08:39:04 GMT

Consider just using the date of interest, 1 Jan for each year.

data ds ;
do year=1970 to 2023;
  if weekday(mdy(1,1,year)) = 1 then output;
end;
run;

Your do loop by 12 was incrementing by 12 day intervals, not months or years so was pretty far off. And since 12 seldom goes into a year evenly when considering days doesn't hit a 1 Jan date very often.

The MDY function creates a date value from numeric parameters of Month number, day number and year.

Re: Sunday for every year 1st JAN

Ksharp — Fri, 30 Dec 2022 10:44:30 GMT

data want;
 do year=1978 to 2023;
   sunday=nwkdom(1,1,1,year);
   output;
 end;
 format sunday date9.;
run;

Re: Sunday for every year 1st JAN

BrahmanandaRao — Fri, 30 Dec 2022 11:01:29 GMT

Thank you Astounding
your are solved this question

Re: Sunday for every year 1st JAN

BrahmanandaRao — Fri, 30 Dec 2022 11:03:04 GMT

Thank you Sharp

data want;
do year = 1960 to 2050;
jan1 = mdy(1, 1, year);
if weekday(jan1) = 1 then output;
end;
format jan1 downame.;
proc print;
run;