Like this?
data WANT;
set HAVE;
_LAST=END;
do DAYS=START to _LAST;
if DAYS ne START then call missing(START, END);
output;
end;
drop _:;
run;
COMPANY_ID
QUARTER
START
END
DAYS
1
1
130
133
130
1
1
.
.
131
1
1
.
.
132
1
1
.
.
133
1
2
190
194
190
1
2
.
.
191
1
2
.
.
192
1
2
.
.
193
1
2
.
.
194
1
3
230
231
230
1
3
.
.
231
... View more
