DateTime

[liyongkai800]

Hello,

I want to get the exact datetime 3 weeks from now. However, the intnx function will always return the time 00:00:000. Any idea on this issue? 

Here is an example, thanks.

data example;
a=intnx('dtweek',datetime(),-3);
a1=put(a,datetime22.3);
b=datetime();
b1=put(b,datetime22.3);
run;

[PaigeMiller · Accepted solution]

The INTNX function has a modifier, which if you set it to 'S' ought to give you the answer you want.

https://documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget=p...

[liyongkai800]

Yes, adding 'same' to the function fix the problem.
Thanks.
Here is the revision.

data example;
a=intnx('dtweek',datetime(),-3,'same');
a1=put(a,datetime22.3);
b=datetime();
b1=put(b,datetime22.3);
run;