Hello,
I wouldn't know how to do that in Visual Analytics, but if you are preparing your data anyway, ... why don't you prepare fully to have a dataset with one row per date?
The program below is only correct if the time ranges for the same person do not overlap.
data have1;
input RequestID PersonID StartDate : ANYDTDTE9. EndDate : ANYDTDTE9.;
format StartDate EndDate date9.;
datalines;
1 1 01Jan2021 10Jan2021
2 2 05Jan2021 05Feb2021
3 1 20Jan2021 01Mar2021
;
run;
data have2(drop=StartDate EndDate);
set have1;
do MYDATE=StartDate to EndDate;
output;
end;
format MYDATE date9.;
run;
PROC FREQ data=have2 noprint;
tables MYDATE / out=WANT_count_MYDATE;
format MYDATE date9.;
run;
/* end of program */
Kind regards,
Koen
... View more
