topic Re: Next Tuesday in SAS Procedures

Next Tuesday

Flip — Fri, 21 Aug 2009 13:32:44 GMT

Is there a function which would easily give me the SAS date of next Tuesday? I know I can loop through days until Tuesday pops up, but if there is a simple function, I would like to use that instead.

Flip

Re: Next Tuesday

Peter_C — Fri, 21 Aug 2009 13:37:41 GMT

the function is INTNX
You will need an "adjusted interval", something like Weekday3 (iirc)
The doc are at http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a003065889.htm .

good luck

PeterC

Re: Next Tuesday

Flip — Fri, 21 Aug 2009 14:02:17 GMT

Thanks. It is exp_date = intnx('week.3', today(), 1);

Re: Next Tuesday

data_null__ — Fri, 21 Aug 2009 14:05:29 GMT

'week.3'

[pre]
data _null_;
do d = today() to today()+14;
t = intnx('week.3',d,1);
put (d t) (+5 weekdate.-r);
end;
run;
[/pre]