topic Re: Finding Tuesday date in SAS Enterprise Guide

Finding Tuesday date

dhruvakumar — Wed, 23 May 2018 02:34:41 GMT

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.

Re: Finding Tuesday date

Reeza — Wed, 23 May 2018 02:44:01 GMT

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.

Re: Finding Tuesday date

PGStats — Wed, 23 May 2018 02:49:54 GMT

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.

Re: Finding Tuesday date

dhruvakumar — Wed, 23 May 2018 03:29:09 GMT

Dear Reeza,

Thank a lot.It working fine.