Thank you very much for your help. can you please explain where i need to create the identifier you are saying to merge with the output i posted ... View more

Thank you very much RW9. i highly appreciate your help. ... View more

    Hi KurtBremser, below is the example of the output i want.   Thanks for yoyur reply   id               ts                          unit                    first                                  last 5307  29NOV12:14:06:00       1        29NOV12:14:06:00               30NOV12:20:06:00  5307  29NOV12:15:45:00       1        29NOV12:14:06:00               30NOV12:20:06:00  5307  30NOV12:17:00:00       1        29NOV12:14:06:00               30NOV12:20:06:00  5307  30NOV12:20:06:00       1        29NOV12:14:06:00               30NOV12:20:06:00  5307  01DEC12:14:06:00       2        01DEC12:14:06:00               02DEC12:21:06:00        5307  01DEC12:20:16:00       2        01DEC12:14:06:00               02DEC12:21:06:00        5307  02DEC12:21:06:00       2        01DEC12:14:06:00               02DEC12:21:06:00        5307  03DEC12:14:06:00       1        03DEC12:14:06:00               04DEC12:14:06:00 5307  03DEC12:20:06:00       1        03DEC12:14:06:00               04DEC12:14:06:00 5307  04DEC12:14:06:00       1        03DEC12:14:06:00              04DEC12:14:06:00 ... View more

This is excatly what i did. Thanks again, i am really grateful! ... View more

Never mind, i figure this out. I am having a bad day. My brain is not working.   Thanks again for the solution ... View more

I am so sorry i do not know how this is happening. ... View more

Hi, thank you very much for your reply.   Time in and time out is different for each encounter. I have thousands of encounters with diffrent time in and time out. Above codes are changing time in and time out to one time in and time out for all the encounters Thanks again     ... View more

Hi all,   I am trying to calculate number of hours from surgery time out and time stamp when heart rate is recorded. I have time stamp for heart rate in all the rows but not for the surgery time out. I know how to calculate number of hours from two time stamps but since time out is not recorded for each row, I am not able to do it. I have tried lag fuction but no help. Can some one please help me. Attached is the fabricated data. I want to calculate the difference in hours from time_out to time heart rate recorded for each row.   Thanks 　 data hr; infile datalines missover; input encounter date mmddyy10. hr_ts : datetime. hr time_in : datetime. time_out : datetime.; format date mmddyy10. hr_ts datetime. time_in datetime. time_out datetime.; datalines; 5307 4/18/2014 18APR14:14:28:00 85 18APR14:07:12:00 18APR14:13:15:00 5307 4/18/2014 18APR14:17:00:00 124 18APR14:07:12:00 18APR14:13:15:00 5307 4/19/2014 19APR14:01:13:00 125 5307 4/19/2014 19APR14:04:00:00 130 5307 4/20/2014 20APR14:13:05:00 99 1602 1/06/2012 06JAN12:14:00:00 89 06JAN12:07:20:00 06JAN12:13:09:00 1602 1/06/2012 06JAN12:15:00:00 109 06JAN12:07:20:00 06JAN12:13:09:00 1602 1/07/2012 07JAN12:23:00:00 99 1602 1/07/2012 07JAN12:01:00:00 90 1602 1/07/2012 07JAN12:23:00:00 99 1602 1/07/2012 07JAN12:02:00:00 89 ; run; proc print data=work.hr; run; ... View more

Ohh sorry, i ddinot know that ... View more

Hi ballardw,   If i am looking for the pre-op plus the day of surgery data (ignoring the post-op data), how can i do that? ... View more

Thanks Daniel for your reply ... View more

Thank you very much RW9. you guys are awesome. ... View more

Thanks ballardw, your codes are doing the trick. I am very grateful.     ... View more