grouping time variable

[Miracle]

Dear all,

Can I please ask how to I group the time variable into 2-hour block category ie 12:00 AM - 2:00 AM, 2:01 AM - 4:00 AM,...., 10:01 PM - 11:59 PM.

The time variable format is timeampm8.

Thank you very much.

[Haikuo]

Sounds like you can use some Proc Format. But without seeing your input data and your wanted output, it is all guessing.

Haikuo

[Miracle]

Hi Haikuo.

my input data looks like this

id     time

1     12:00 AM

2     3:59 AM

.

.

.

20     10:01 PM   

my wanted output:

id     time               timegrp

1     12:30 AM               1

2     3:59 AM                 2

.

.

.

20     10:01 PM              12

Thank you!

[Patrick_Tan]

  timegrp= hour(time/2) +1;