topic Re: Leap Years divisible by 4000 in SAS Programming

Leap Years divisible by 4000

d_simpson — Fri, 19 Jun 2020 13:00:00 GMT

SAS does not let me assign 29-Feb-4000 as a valid date.

Tt looks like it is defining years divisible by 4000 as not leap years. I think this is incorrect.

I tried 29-FEB-8000 and that generates an error too.

28 a_date = '29FEB4000'd; output;
____________
77
ERROR: Invalid date/time/datetime constant '29FEB4000'd.
ERROR 77-185: Invalid number conversion on '29FEB4000'd.

Re: Leap Years divisible by 4000

PaigeMiller — Fri, 19 Jun 2020 13:15:10 GMT

According to this article, 4000 is not a leap year.

Re: Leap Years divisible by 4000

d_simpson — Fri, 19 Jun 2020 13:19:12 GMT

I understand that the 4000 rule is still a proposal though.

Re: Leap Years divisible by 4000

PaigeMiller — Fri, 19 Jun 2020 14:07:11 GMT

Well, that is how SAS handles leap years. I read somewhere that in Excel, 4000 is a leap year.

Re: Leap Years divisible by 4000

ballardw — Fri, 19 Jun 2020 14:08:31 GMT

One might ask why is so important to have a 29 Feb 4000 date. or 8000, 12000, 16000?

Once the programming is set for the rules to exclude 4000 why might you think 8000 would be different.