Replacing year in the datetime24.3

[2023newsas]

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

[PaigeMiller · Accepted solution]

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;

[2023newsas]

Hi there thank you very much!