topic Re: Find same day after 3 month in SAS Programming

Find same day after 3 month

hhchenfx — Thu, 12 May 2022 03:28:30 GMT

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 — Thu, 12 May 2022 03:31:59 GMT

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

hhchenfx — Thu, 12 May 2022 03:37:46 GMT

Thank you,

It works perfectly.

HHC