Flattening a data set (newbie question)

[bkann]

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:

machine   start_dte     days_out
92347     21feb2011     3
45885     02mar2011     2

I'd ultimately like to end up with a data set that represents each day of an outage as its own record, eg:

machine   date
92347     21feb2011
92347     22feb2011
92347     23feb2011
45885     02mar2011
45885     03mar2011

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!

[Mean Joe]

In this code, _DAYSREM is a counter (counting downard from the beginning value DAYS_OUT)--as long as _DAYSREM>0 you keep outputting a record.

data outage;
retain _daysrem;
set equipment; *or whatever name of the dataset you are starting with;
_daysrem = days_out;
do while (_daysrem>0);
    date=start_dte+(days_out-_daysrem);
    output;
    _daysrem=_daysrem-1;
end;
drop _daysrem start_dte days_out;
run;

[bkann]

This is perfect. Thanks very much, Joe! Worked perfectly.