Hi all,

I want to create a variable Timegroups which uses another variable Time to create categories.

Time is created from variable RideDate (2020/11/02, 13:57:04) using below code:
gen double Time=clock(RideDate, "YMDhms")
format Time %tcHHMM

So although Time appears as e.g. 1023, 1145, or 2234, the non-formatted version is 02nov2020 10:23:15.

I want to create a variable Timegroups which categorises each Time into a group.
Essentially I want times before 0800 to be categorised as 0, everything between 0800 and 2200 to be categorised as 2, and everything above 2200 to be categorised as 3.

I tried with the code
gen Timegroups=.
replace Timegroups=0 if Time < 0800
replace Timegroups=1 if Time>=0800 & Time<=2200
replace Timegroups=2 if Time>2200

But this obviously doesn't work since Time is formatted differently to what I wrote in the code (and I can't figure out a way for Stata to dismiss the date in the non-formatted section so it only considers the hours).

Thank you.