How do I duplicate obs on date

[sivatheg]

Hi!

I have a problem. I have a dataset looking like the following:

ID      check-in        check-out

XX      5/1/2016         7/1/2016

YX      12/31/2016     3/1/2017

I want to duplicate the data such that I have the intensity on each day. I want it to look like the following:

ID        date

XX        5/1/2016

XX        6/1/2016

XX        7/1/2016

YX        12/31/2016

YX        1/1/2017

YX        2/1/2017

YX        3/1/2017

Does anyone now how to do this?

[RW9 · Accepted solution]

Use a do loop:

data want (drop=check_in check_out);
  set have;
  do date_want=check_in to check_out;
    output;
  end;
run;