DATA Step, Macro, Functions and more

How do I duplicate obs on date

Accepted Solution Solved
Reply
New User
Posts: 1
Accepted Solution

How do I duplicate obs on date

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?

 

 


Accepted Solutions
Solution
‎07-04-2017 08:54 AM
Super User
Super User
Posts: 7,942

Re: How do I duplicate obs on date

[ Edited ]

Use a do loop:

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

View solution in original post


All Replies
Solution
‎07-04-2017 08:54 AM
Super User
Super User
Posts: 7,942

Re: How do I duplicate obs on date

[ Edited ]

Use a do loop:

data want (drop=check_in check_out);
  set have;
  do date_want=check_in to check_out;
    output;
  end;
run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 78 views
  • 0 likes
  • 2 in conversation