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

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

SchalkBurger — Sun, 14 May 2017 17:21:05 GMT

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 — Sun, 14 May 2017 18:49:48 GMT

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 — Sun, 14 May 2017 20:04:49 GMT

Thank you for the help Reeza.