Dear Statalist,
I am working on a panel dataset (xtset firm year).
I want to divide the firms into two subgroups. One for small firms and the second for bigger firms.
The category a firm belongs to should be determined by the mean of its assets over time.
This is also an unbalanced panel so that for some firms, the mean must be based on two years, while it can be based on eight years for other firms.
Then, firms with mean(ASSETS) above median should be categorized as "big_firms" (dummy=1), while small firms get dummy=0.
I hope you can help me with this.
Related Posts with Divide panel data into subgroups
Statistical Area fixed effectsHi, I am trying to control for the CBSA (a statistical area) in my dataset. To do this I think I wo…
CHAID decision tree to determine significant cutoff of continuous variableI am using Stata 13 SE and have installed the chaid and chaidforest packages. I have a dataset of pa…
New Stata module for nonparametric errors-in-variables regressionA new Stata module for estimation of nonparametric errors-in-variables (EIV) regression (and constru…
Imputation QuestionHello everyone, I am performing time series analysis. I have performed multiple imputation on only …
Firm fixed effects with reghdfeHi statalist community, I am working with a dataset that looks like this: Code: input float(abs_DA…
Subscribe to:
Post Comments (Atom)
0 Response to Divide panel data into subgroups
Post a Comment