Help using Base SAS procedures

grouping time variable

Reply
Regular Contributor
Posts: 217

grouping time variable

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.

Respected Advisor
Posts: 3,124

Re: grouping time variable

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

Haikuo

Regular Contributor
Posts: 217

Re: grouping time variable

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!

Occasional Contributor
Posts: 6

Re: grouping time variable

  timegrp= hour(time/2) +1;

Ask a Question
Discussion stats
  • 3 replies
  • 374 views
  • 3 likes
  • 3 in conversation