I have a time variable on the basis of which i wish to categorize my study subjects into groups (for eg 09:00am-05:00pm becomes group 1, and 5:00pm-9:00am becomes group 2). i am trying to figure this out in STATA software.
also can i possibly categorize based on days as well? (weekends vs weekdays)?
Say you have a variable days with 1=weekends and 2=weekdays and a variable time with entries like "09:00am" or "10:40pm" you can create a variable group based on both days and time as follows:
gen double t = clock(time, "hm")
format t %tcHH:MM
gen group=1 if days==1 & hh(t)>=9 & hh(t)=9 & hh(t)
Thanks Alex!
Since i already had a variable defined for time and date I had to extract the individual hour of day and day of week as two separate variables using the STATA commands below:
. gen admithour = hh(admittime) for the hour of the day
. gen day_of_week = dow(dofc(eventtime)) for week of the day.
where admittime was the time & date variable originally available.
Days were eventually numbered 0-6 (0=Sunday), and hours were numbered 0-23 in the generated variables. This allows to further code the data into groups based on the hour and/or day of the week.
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics