If you don't remove the first ELSE then the code won't work properly if status=1 for the very first row of a new ID. Please use below code to always get a correct result. data want; set have; by id date hour; if first.id or status_hour=24 then status_hour=0; if status=1 then status_hour=1; else if status_hour>0 then status_hour+1; run; ... View more

Tom,  I really want to display my gratitude. You are awesome. I appreciate the time you took, and everyone else in this great community, to lend me a hand on finalizing this report. I can finally complete this and have it run on auto pilot. Have a great day.  ... View more

That works but you're still making that Excel file. You really can get around it if you want, up to you though. ... View more