How do I duplicate obs on date

sivatheg — Tue, 04 Jul 2017 11:36:05 GMT

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?

Re: How do I duplicate obs on date

RW9 — Tue, 04 Jul 2017 11:50:27 GMT

Use a do loop:

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