Hello
I have a panel data of all NYSE, AMEX and NASDAQ firms. I am trying to create size deciles based on total assets but only want to use the NYSE firms to set up the cutpoints.
How do I create size deciles by year (for all firms), but just based on the NYSE (i have the stock exchange code) cutpoints.
I used egen sizedecile = xtile(size), by (year) nq (10)
The problem is that it uses all firms to create the cutoff points.
Thank you!
Related Posts with Creating deciles/quintiles based on a certain group of observations by year
Repeated measures mixed model specificationHello everyone, I think I am stuck on a specification problem and struggling to find a way out. - Pr…
Determine number of unique values groupwiseHey community, I have grouped my observations by the variable companyid so that there are multiple …
Maximum Likelihood Estimation cannot find starting values in StataI am attempting to use Deal or No Deal Data to test for risk aversion parameters using Maximum Likel…
Panel Var IRF standard deviation reportDear experts, I used pvar syntax by Abrigo and Love(2015) because of unbalanced panel data. Fore m…
Regression analysis to detect herd behaviorDear all, I am new to this forum and also new to Stata. Therefore, I would like to apologize for an…
Subscribe to:
Post Comments (Atom)
0 Response to Creating deciles/quintiles based on a certain group of observations by year
Post a Comment