topic Re: Datetime in SAS Programming

Datetime

Pandu2 — Fri, 07 Jan 2022 05:16:11 GMT

Hi all,

I've a datetime value which is
Date = %sysfunc(datetime(), e8601dt24.3);
output : 2022-01-07T10:38:49.095
I would like to subtract 365 days from Date Variable i.e a year.
The wanted Date Variable should look like this
2021-01-07T10.38.49.095
Can anyone please help me on achieving this. Thanks in advance.

Re: Datetime

andreas_lds — Fri, 07 Jan 2022 06:11:17 GMT

Don't apply a format to a date, datetime or time macro-variable if you want to use in calculations.

Try

%let wanted = %sysfunc(intnx(dtyear, %sysfunc(datetime()), -1, s), e8601dt24.3);

or if you need the variable date (bad name for a variable not containing a date, but a datetime-value):

%let date = %sysfunc(datetime());
%let want = %sysfunc(intnx(dtyear, &date., -1, s), e8601dt24.3);
%put &=want;

Re: Datetime

Pandu2 — Fri, 07 Jan 2022 06:43:55 GMT

Thank you veryy muchh. This looks good and it is working.