topic Re: Make groups by time interval (hours of day) in SAS Programming

Make groups by time interval (hours of day)

Zax7 — Tue, 27 Nov 2018 10:52:42 GMT

Hi All,

I am looking for a way to make time groups from datetime values.

Further I have to summarize observations in these groups (time intervals).

The result must be like this:

Date, time	Interval time
2017.10.25 6:40	6:00-7:00
2017.10.25 8:11	8:00-9:00
2017.10.25 10:27	10:00-11:00
2017.10.25 11:06	11:00-12:00
2017.10.25 12:53	12:00-13:00
2017.10.25 13:20	13:00-14:00

I tried this code:

data want;
set have;
interval=cats(put(hour(Date_time),2.),':00-',put(hour(Date_time)+1,2.),':00');
run;

It looks like this is very good for me but I don't know this is an appropriate solution or not.

I am a very beginner SAS programmer.

Thank you for your answers.

Re: Make groups by time interval (hours of day)

RW9 — Tue, 27 Nov 2018 11:09:06 GMT

Looks fine for your required output. What I would say is that for further processing, i.e. checking if time is within those hours or what not, it would be a good idea to have a numeric upper and lower boundary, e.g.:

data want;
  set have;
  lower=hour(date_time);
  upper=hour(date_time)+1;
  interval=cats(put(lower,2.),':00-',put(upper,2.),':00');
run;

That way you can do comparisons on lower/upper and use the text for outputs.

Re: Make groups by time interval (hours of day)

Zax7 — Tue, 27 Nov 2018 11:36:22 GMT

Thank you and i consider your suggestion.