topic Date generation in SAS Programming

Date generation

Jyuen204 — Wed, 11 Mar 2020 18:54:54 GMT

Apologies for the rather simplistic question. But I have a date set I generate in the code to reference.

REPORTDATE = intnx('Week',today(),-1,'E');

CW_END = intnx('Week',ReportDate,0,'E');

This gives me the most recent Saturday that passed for a report I generate. I need to be able to get this exact Date in the previous year. So in this case March 7 2020 is the date generated from above code. I need to get March 7 2019. I would use a hard coded calculation but that would mess up in Leap years like this year.

Thanks in advance!

Re: Date generation

PaigeMiller — Wed, 11 Mar 2020 18:57:14 GMT

oneyearago=intnx('year',cw_end,-1,'s');

Re: Date generation

Reeza — Wed, 11 Mar 2020 19:14:17 GMT

The last parameter in the INTNX function is the alignment parameter. The option you're looking for is 'same' which will move it to the same date. Verify it treats leap years the way you want and you're good to go. You can also extract the month day and increment the year and use MDY() BUT that won't work for leap years so INTNX() is safer.

Re: Date generation

Jyuen204 — Wed, 11 Mar 2020 19:42:11 GMT

Thanks so much!