Sunday for every year 1st JAN

[BrahmanandaRao]

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

[andreas_lds]

And the question is?

[BrahmanandaRao]

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

[Kurt_Bremser]

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.

[Astounding · Accepted solution]

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;

[BrahmanandaRao]

Thank you Astounding
your are solved this question

[ballardw]

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.

[Ksharp]

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

[BrahmanandaRao]

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;