Create Date Variable

Toni2 — Thu, 22 Jul 2021 10:23:48 GMT

hi, i have the below dates in months. i want to insert some more dates after the last date (30/04/2021). I mean i want to add dates till 31/12/2026 but not sure how i can do it. Please note that i want the last day of each month. for example, 30/05/2021, 31/06/2021 etc.

Any idea it would be appreciated ?

31/07/2020

31/08/2020

30/09/2020

31/10/2020

30/11/2020

31/12/2020

31/01/2021

28/02/2021

31/03/2021

30/04/2021

Re: Create Date Variable

andreas_lds — Thu, 22 Jul 2021 10:37:53 GMT

Do you have strings looking like dates, or sas dates?

Maybe something like (code is untested):

data want;
  set have end=startLoop;
  output;
  if startLoop then do;
   do until (date = '31Dec2026'd);
     date = intnx('month', date, 1, 'end');
    output;
  end;
run;

topic Re: Create Date Variable in New SAS User

Create Date Variable

Re: Create Date Variable