Hi everyone,
I have a data set with different companies from 2002 till 2018, with the percentage of unionization per year per firm. I tried to create two dummy variables for the unionization variable(union_mem_t1). One, which is 1 when the observation is in the highest quantile of the unionization variable and one that equals 1, when it is in the lowest quantile.
I used the code below, which seems to work but the observations allocated to the yearly high and low quantile change every time I rund the do file.
bysort year (union_mem_t1): gen byte union_mem_dummy_quanhigh_t1 = _n > (0.75 * _N)
bysort year (union_mem_t1): gen byte union_mem_dummy_quanlow_t1 = _n < (0.25 * _N)
I then tried
xtile union_mem_dummy_quan_t1 = union_mem_t1, n(4)
gen union_mem_dummy_quanhigh_t1= union_mem_dummy_quan_t1
replace union_mem_dummy_quanhigh_t1 =0 if union_mem_dummy_quanhigh_t1!=4
replace union_mem_dummy_quanhigh_t1 =1 if union_mem_dummy_quanhigh_t1==4
gen union_mem_dummy_quanlow_t1= union_mem_dummy_quan_t1
replace union_mem_dummy_quanlow_t1 =0 if union_mem_dummy_quanlow_t1!=1
replace union_mem_dummy_quanlow_t1 =1 if union_mem_dummy_quanlow_t1==1
to see if I have the same problem when I am creating the dummies over all years and here the allocation is constantly the same.
Could someone please kindly help me to understand this? I would be really grateful.
Thank you in advance
Related Posts with Problem with creating yearly Quantile dummies
Import delimited - ignoring linebreaksHello, I have (random) linebreaks that I cannot remove with Notepad++ before importing. Three observ…
Probit versus marginsDear all, I am testing the effect of a policy using a DID strategy, I get positive and significant …
Drop duplicates imposing a conditionGood morning, I have divided Africa in a grid cell of 50x50 kilometers. However, there are some cel…
How to create balanced dataset from unbalanced datasetHi all, I have a dataset which looks like this: Code: * Example generated by -dataex-. To install…
import test.xmlDear All, Suppose that I run the following regressions and use (ssc install) outreg2 to save estimat…
Subscribe to:
Post Comments (Atom)
0 Response to Problem with creating yearly Quantile dummies
Post a Comment