How to populate table with all possible dates between the first (minimum) and last (maximum) date.

[SchalkBurger]

Hello everyone.

I created a table with a first (minimum) and last (maximum) date from another dataset.

This is how the above metioned table looks.

I want to create another table starting from the first (Minimum) date and creating all possible dates up until the last (Maximum) date.

Do anyone maybe have a suggestion to do this?

Thank you.

[Reeza · Accepted solution]

Use a DO loop with the start and end variables as the dates and an explicit OUTPUT statement.

data want;

    set have;

   do date=start_date to end_date;
       
       OUTPUT;

   end;

run;

[SchalkBurger]

Thank you for the help Reeza.