I'm relatively new to SAS, so please forgive me if this has an entirely obvious answer. I've searched the Web extensively for the past several days and have come up empty for a solution.
I have a data set that describes equipment, the date a piece of equipment went out of service for repairs, and the number of days it was out, eg:
I'd ultimately like to end up with a data set that represents each day of an outage as its own record, eg:
I'm wondering if anyone can suggest how I might achieve this. I'm open to anything. Using SAS EG 4.1
Many thanks in advance for any help you can provide!