topic Subtract exactly one year from a date in New SAS User

Subtract exactly one year from a date

NewUsrStat — Thu, 06 Feb 2025 09:42:50 GMT

Hi guys, I have a date like this: 01JUL2021. How can I get 01JUL2020? I need to subtract exactly one year.

I tried the following but without success. The date is no more "01JUL"

my_new_date = INTNX('YEAR',mydate,-1);

Thank you in advance

Best

Re: Subtract exactly one year from a date

FreelanceReinh — Thu, 06 Feb 2025 09:58:46 GMT

Hi @NewUsrStat,

Use 's' (the "SAME alignment") in the fourth argument of the INTNX function:

my_new_date = INTNX('YEAR',mydate,-1,'s');

The default is 'b' (beginning).

Re: Subtract exactly one year from a date

PaigeMiller — Thu, 06 Feb 2025 10:21:16 GMT

@NewUsrStat wrote:

Hi guys, I have a date like this: 01JUL2021. How can I get 01JUL2020? I need to subtract exactly one year.

I tried the following but without success. The date is no more "01JUL"
my_new_date = INTNX('YEAR',mydate,-1);

So just to be 100% complete, when a date is 01JUL2021 in a numeric variable, then @FreelanceReinh has the solution. But if the date of 01JUL2021 is in a character variable (is it? you don't tell us) then that won't work. Then you want this:

one_year_ago = intnx('year',input(char_date_variable_name,date9.),-1,'s');

Re: Subtract exactly one year from a date

Kurt_Bremser — Thu, 06 Feb 2025 13:32:28 GMT

Maxim 1: Read the Documentation

INTNX Function: Alignment