topic Re: DateTime in SAS Programming

DateTime

liyongkai800 — Fri, 04 Oct 2019 18:33:16 GMT

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;

Re: DateTime

PaigeMiller — Fri, 04 Oct 2019 18:37:19 GMT

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=p10v3sa3i4kfxfn1sovhi5xzxh8n.htm&locale=en

Re: DateTime

liyongkai800 — Fri, 04 Oct 2019 18:47:29 GMT

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;