topic Calculate next Friday of a column date in SAS Programming

Calculate next Friday of a column date

ywon111 — Mon, 04 May 2020 12:31:34 GMT

It appears if it is a Friday then it will return next Friday.

E.g. 1 May 2020 then 8 May 2020.

Is it possible to return 1 May 2020 instead?

This is the current code: reportwk = intnx('week.6',today(),1,'b');

Thanks

PaigeMiller — Mon, 04 May 2020 12:33:58 GMT

reportwk = intnx('week.6',today(),0,'b');

FreelanceReinh — Mon, 04 May 2020 13:22:06 GMT

Hi, @ywon111: Use this instead:

reportwk = intnx('week.7',today(),0,'e');