Find same day after 3 month

[hhchenfx]

Hi Everyone,

I have a column with date and I want to create a new column for the same date in the next 3 month.

So '5MAY2022'd will have '5AUG2022'd and '5NOV2022' will have '5FEB2023'd.

Can you please help?

Thank you,

HHC

data have;
    format my_date date9.;
    input my_date date9.;
    datalines;
05MAY2022
05NOV2022
;
run;

[japelin · Accepted solution]

data want;
  set have;
  newdate=intnx('month',my_date,3,'s');
  format newdate date9.;
run;

[hhchenfx]

Thank you,

It works perfectly.

HHC