Need Help in Grouping Time

[pp2014]

I have time in the format timeampm8.

For eg.  2:35 AM,  5:03 Am etc. etc.

I want to group the time as following :   "1 AM - 3 AM"

                                                              "3 AM - 5 AM"

                                                              "5 AM - 7 AM"

                                                                ---- etc.

[JohnHoughton · Accepted solution]

Need to define & apply a format as follows

proc format;
value timerng
"01:00"t -< "03:00"t="1 AM - 3 AM"
"03:00"t -< "05:00"t="3 AM - 5 AM"
"05:00"t -< "07:00"t="5 AM - 7 AM";
*fill in the rest;
run;
data want;
format time timerng.;
time='01:35 AM't; output;
time='03:00 AM't; output;
time='03:02 AM't; output;
run;

[pp2014]

Thanks John...