I am doing a panelregression with industry and year FE
Is it possible to create a new panelid
Code:
egen panelid = group(industry_key year)
Code:
xtset panelid
Code:
xtreg firm_beta_w esg_single_lag1 operating_leverage_lag1 diversification_lag1 RnD_lag1 advertising_lag1 leverage_lag1 capex_lag1 cash_lag1 size_lag1 earnings_variability_lag1 state_tax_lag1, fe
Fixed-effects (within) regression Number of obs = 5,011
Group variable: panelid Number of groups = 413
R-sq: Obs per group:
within = 0.0118 min = 1
between = 0.0212 avg = 12.1
overall = 0.0213 max = 60
F(11,4587) = 5.00
corr(u_i, Xb) = 0.0711 Prob > F = 0.0000
-------------------------------------------------------------------------------------------
firm_beta_w | Coef. Std. Err. t P>|t| [95% Conf. Interval]
--------------------------+----------------------------------------------------------------
esg_single_lag1 | -.0915714 .0362866 -2.52 0.012 -.1627106 -.0204322
operating_leverage_lag1 | -.0000463 .0010595 -0.04 0.965 -.0021234 .0020307
diversification_lag1 | .002271 .0033245 0.68 0.495 -.0042466 .0087887
RnD_lag1 | .9691038 .1826924 5.30 0.000 .6109388 1.327269
advertising_lag1 | -.0395175 .0520266 -0.76 0.448 -.1415147 .0624798
leverage_lag1 | .0378296 .0380948 0.99 0.321 -.0368546 .1125138
capex_lag1 | .0393854 .1811958 0.22 0.828 -.3158456 .3946164
cash_lag1 | -.0029276 .0048622 -0.60 0.547 -.0124599 .0066047
size_lag1 | .0416424 .0143322 2.91 0.004 .0135443 .0697404
earnings_variability_lag1 | .0049405 .0023344 2.12 0.034 .000364 .0095171
state_tax_lag1 | -.6195115 .1996369 -3.10 0.002 -1.010896 -.228127
_cons | .715787 .1415617 5.06 0.000 .4382579 .993316
--------------------------+----------------------------------------------------------------
sigma_u | .28925279
sigma_e | .38517848
rho | .36058832 (fraction of variance due to u_i)
-------------------------------------------------------------------------------------------
F test that all u_i=0: F(412, 4587) = 3.46 Prob > F = 0.0000
0 Response to generating new paneid
Post a Comment