Hi, I want to create dummy variables based on the median. Sometiems I do that based on quartile and tercile. I do the following
1. This will create a yearly median variable and median dummy
egen ana= xtile(num), n(2) by(fyear)
gen num_dummy = cond(missing(ana), ., (ana>1))
2. This will create a yearly tercile variable and a dummy based on top tercile
egen ana= xtile(num), n(3) by(fyear)
gen num_dummy = cond(missing(ana), ., (ana>2))
3. This will create a yearly quartile variable and a dummy based on top quartile
egen ana= xtile(num), n(4) by(fyear)
gen num_dummy = cond(missing(ana), ., (ana>3))
Though I checked that the codes give me the correct answer even if I calculate them by using slightly different code, I want to make sure from the expert that I am doing it correctly.
So, experts, could you please tell me whether I am doing things correctly or not?
Related Posts with Median, Tercile and Quartile
-khb- and multiple imputed dataHi! I am doing mediation analyses with continuous iv and m, and binary dv. Is it possible to use the…
two fpfit plots on one with estoptsHello stata-users, I have tried plotting two fpfit curves on one graph using Code: twoway (fpfit v…
Opening and cleaning SPSS -> STATADear Statalist, I hope this finds you well and rested after the weekend. I've recently been trying …
New version of descgen on SSCThanks once again to Kit Baum, a new version of the descgen package is now available for download fr…
Long to wide, converting values to label for new variableHi all, I've got a raw dataset in the following format: indicatorcode indicatordescription regi…
Subscribe to:
Post Comments (Atom)
0 Response to Median, Tercile and Quartile
Post a Comment