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.
Related Posts with Used formatted variable to categorised new var
Multiple commands in one line stored in a localI have a problem executing a local with multiple Stata commands separated by ";". If I use this cod…
Coefplot graph error despite running the regressionI'm supposed to get a coefplot graph using the following data and code but unfortunately I'm coming …
anycountDear all I would like to count the number of values across 5 numeric variables. I tried using "anyc…
Problems with regressions (regress.ado r(199)Hi, I have run into some problems with making regressions in Stata (version 16). I have been using …
formula into regressionHi Is there any way to make a regression in this way regress ln(y) indep vars without generate a …
Subscribe to:
Post Comments (Atom)
0 Response to Used formatted variable to categorised new var
Post a Comment