My final solution is: DATA P_sort;
set L***;
hour = hour(time);
run;
proc sql;
create table selected_P_sort as
select assoc_count, hour
from P_sort
where datepart(time) between '01APR2018'd and '15APR2018'd AND hour between 7 and 23;
quit;
proc summary data=selected_P_sort;
var assoc_count;
class hour;
output out=fin_P_sort MEAN=;
run; Thanks PaigeMiller and SASKiwi.
... View more