Dear Forum,
I would like to create a table for descriptive statistics and a table for correlations. I have panel data and three dependent variables (emissions, tq and rdi), one independent variable (purpose) and seven control variables.
When I run the regressions, stata automatically drops the observations that are empty in one place and that stata cannot use.
For the tables, stata does not do this and accordingly the data for the variables are skewed. Namely, for example, the mean values are wrong, because more values are considered than later in the regression.
Is there a command so that only those observations are included in the two tables that are also included in the regressions? My current commands are these:
asdoc sum emissions tq rdi purpose_l2 dirty_l2 b2c_l2 cf_l2 growth_l2 capexi_l2 adexi_l2 sl_l2 fs_l2 om_l2, label s(count sum mean max min variance sd) dec(3) save(Descriptive statistics.doc)replace
asdoc pwcorr emissions tq rdi purpose_l2 dirty_l2 b2c_l2 cf_l2 growth_l2 capexi_l2 adexi_l2 sl_l2 fs_l2 om_l2, obs label star(0.05) fhc(\b) fhr(\b) sig dec(3) save(Correlations table) replace
Thank you very much and best regards,
Jana
I would like to create a table for descriptive statistics and a table for correlations. I have panel data and three dependent variables (emissions, tq and rdi), one independent variable (purpose) and seven control variables.
When I run the regressions, stata automatically drops the observations that are empty in one place and that stata cannot use.
For the tables, stata does not do this and accordingly the data for the variables are skewed. Namely, for example, the mean values are wrong, because more values are considered than later in the regression.
Is there a command so that only those observations are included in the two tables that are also included in the regressions? My current commands are these:
asdoc sum emissions tq rdi purpose_l2 dirty_l2 b2c_l2 cf_l2 growth_l2 capexi_l2 adexi_l2 sl_l2 fs_l2 om_l2, label s(count sum mean max min variance sd) dec(3) save(Descriptive statistics.doc)replace
asdoc pwcorr emissions tq rdi purpose_l2 dirty_l2 b2c_l2 cf_l2 growth_l2 capexi_l2 adexi_l2 sl_l2 fs_l2 om_l2, obs label star(0.05) fhc(\b) fhr(\b) sig dec(3) save(Correlations table) replace
Thank you very much and best regards,
Jana

Comment