SAS VA Date Formats

barlocaroni — Mon, 17 Dec 2018 09:12:05 GMT

Hi all,

recently I've found that the date 2936547 (i.e. 31dec9999) is formatted differently in SAS (9.4) and VA (7.4):

SAS seems "correct", while VA formats this date as 29dec9999.

So, it seems that SAS uses the "4000" rule for leap years (there is no 29feb4000 and 29feb8000), while VA does not.

Is this correct? Is the "4000" rule valid and accepted?

Thank you very much,

Carlo

Re: SAS VA Date Formats

Amir — Mon, 17 Dec 2018 09:43:30 GMT

Hi,

Looks like this question has been asked before, but without a firm solution:

Might be worth checking how the days 28feb4000 and 01mar4000 are represented and see if they are 1 or 2 days apart.

Getting in touch with SAS Technical Support might also be a way forward if no one else has an answer.

Regards,

Amir.