Greetings!
As per the model on which I am working where I try to find the impact of mentoring versus formal business classes on profits of small entrepreneurs, I regressed profits (tprofits) on Mentee (a categorical variable if assigned the status of mentorship), Class (a categorical variable if assigned the status of business classes), previous years baseline profits (tprofits_b) and a few other control variables like age, education, sector fixed effects etc. for which I used the global command: ($controls). The code I ran is as follows:
global controls ln_age higher_edu l_empl sec_0 sec_1 sec_02
reg tprofits Mentee Class tprofits_b $controls, cluster(id) robust
estadd local Controls "Yes", replace
est sto tab3_col1
reg tprofits Mentee Class tprofits_b $controls if months_since_treatment == 1, cluster(id) robust
estadd local Controls "Yes", replace
est sto tab3_col2
reg tprofits Mentee Class tprofits_b $controls if months_since_treatment == 17, cluster(id) robust
estadd local Controls "Yes", replace
est sto tab3_col3
esttab tab3_col* using table3.rtf, replace label b(3) se(3) stats(N r2 Controls, fmt(0 3 0) labels("Observations" "R2" "Controls")) nomtitle onecell
1. My first question is that in my newly created table, I want only the Mentee and Class variables to be displayed on the rows, however, although I control for the other variables, I do not want to display them in my table. I am not able to use the absorb command as the error message says that there are too many variables to absorb. Could you please tell me how I can go about this?
2. I also want to add the p-value of the null hypothesis: Mentee = Class to test for the equality in the treatment effects across these 2 groups using estadd command for each of the columns, but totally clueless how to add them.
Thanks in advance for your precious time!
As per the model on which I am working where I try to find the impact of mentoring versus formal business classes on profits of small entrepreneurs, I regressed profits (tprofits) on Mentee (a categorical variable if assigned the status of mentorship), Class (a categorical variable if assigned the status of business classes), previous years baseline profits (tprofits_b) and a few other control variables like age, education, sector fixed effects etc. for which I used the global command: ($controls). The code I ran is as follows:
global controls ln_age higher_edu l_empl sec_0 sec_1 sec_02
reg tprofits Mentee Class tprofits_b $controls, cluster(id) robust
estadd local Controls "Yes", replace
est sto tab3_col1
reg tprofits Mentee Class tprofits_b $controls if months_since_treatment == 1, cluster(id) robust
estadd local Controls "Yes", replace
est sto tab3_col2
reg tprofits Mentee Class tprofits_b $controls if months_since_treatment == 17, cluster(id) robust
estadd local Controls "Yes", replace
est sto tab3_col3
esttab tab3_col* using table3.rtf, replace label b(3) se(3) stats(N r2 Controls, fmt(0 3 0) labels("Observations" "R2" "Controls")) nomtitle onecell
1. My first question is that in my newly created table, I want only the Mentee and Class variables to be displayed on the rows, however, although I control for the other variables, I do not want to display them in my table. I am not able to use the absorb command as the error message says that there are too many variables to absorb. Could you please tell me how I can go about this?
2. I also want to add the p-value of the null hypothesis: Mentee = Class to test for the equality in the treatment effects across these 2 groups using estadd command for each of the columns, but totally clueless how to add them.
Thanks in advance for your precious time!
Comment