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.
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.
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.
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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.