topic grouping time variable in SAS Procedures

grouping time variable

Miracle — Mon, 10 Feb 2014 01:37:27 GMT

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 — Mon, 10 Feb 2014 03:52:18 GMT

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

Haikuo

Miracle — Mon, 10 Feb 2014 04:11:33 GMT

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 — Mon, 10 Feb 2014 10:57:54 GMT

timegrp= hour(time/2) +1;