This works:
data have;
infile datalines dsd dlm=",";
input Grp $ Event $ Start Stop;
datalines;
X,a,1,10
X,b,8,12
X,c,16,20
X,d,1,10
Y,e,3,4
;
run;
DATA want(keep = grp totaldays);
SET have;
by grp;
array days [1:100] _temporary_;
DO day=start to stop;
days(day) = 1;
END;
if last.grp then do;
totaldays = sum(of days(*));
output;
call missing(of days(*));
end;
RUN;
... View more
