topic Replacing year in the datetime24.3 in Microsoft Integration with SAS

Replacing year in the datetime24.3

2023newsas — Sat, 21 Jan 2023 21:48:19 GMT

Hi all,

I am new to SAS, can you please suggest the best way to replace on the year portion of a date with datetime24.3

Example date in column dd_date is 01OCT2022: 15:00:28.000. I only need to change 2022 to 2020

Re: Replacing year in the datetime24.3

PaigeMiller — Sat, 21 Jan 2023 22:02:17 GMT

Assuming you have a numeric variable named DATETIME_VALUE that contains this date/time value, and you want to subtract two years, the INTNX command will do that. The format is irrelevant; if a variable contains date/time values, this works regardless of the format.

data want;
    set have;
    new_value = intnx('dtyear',datetime_value,-2,'s');
    format new_value datetime24.3;
run;

Re: Replacing year in the datetime24.3

2023newsas — Sat, 21 Jan 2023 22:35:00 GMT

Hi there thank you very much!