topic Need Help in Grouping Time in SAS Programming

Need Help in Grouping Time

pp2014 — Tue, 05 Jul 2016 18:16:27 GMT

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.

Re: Need Help in Grouping Time

JohnHoughton — Tue, 05 Jul 2016 18:42:51 GMT

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;

Re: Need Help in Grouping Time

pp2014 — Wed, 06 Jul 2016 02:31:19 GMT

Thanks John...