Finding Tuesday date

[dhruvakumar]

Dear All,

Good morning ! I need to find tuesday date of the week dynamically. 

For instance today date is 23-05-2018, when I run my code the date should be assigned to  22-05-2018

Another instance if run the code next week i.e 28-05-2018 , the date value should be assigned to 29-05-2018..

Please help to provide advise. Thank you.

[Reeza · Accepted solution]

INTNX(). 

Align it to the beginning of the week and then add 2. Check the docs for the details. 

Tuesday = intnx('week', today(), 0, 'b') + 2;

---

@dhruvakumar wrote:

Dear All,

Good morning ! I need to find tuesday date of the week dynamically. 

For instance today date is 23-05-2018, when I run my code the date should be assigned to  22-05-2018

Another instance if run the code next week i.e 28-05-2018 , the date value should be assigned to 29-05-2018..

Please help to provide advise. Thank you.

---

[dhruvakumar]

Dear Reeza,

Thank a lot.It working fine.

[PGStats]

This is reliably done with SAS date interval functions:

data test;
do date = '01may2018'd to '31may2018'd;
    tuesday = intnx("day", intnx("week", date, 0), 2);
    output;
    end;
format date tuesday yymmdd10.;
run;

proc print data=test noobs; run;

i.e. find the date of the beginning of the week (a Sunday) and then move forward two days.