I want to export the results of a regression with the outreg2 command. How can I make it look like the following screenshot. I am using different (main) independent variables in the different models, therefore the rows should be filled in only with the one which is used in the respective regression.
I tried it with the keep option but that doesn't work.
I tried it with the keep option but that doesn't work.
Code:
use "ind_size_sample_-1_1.dta", clear reg CAR total_acc_freq_5 DV CashOnly Diversifying relsize i.Year i.SIC_two outreg2 using CAR_-1_1_freq.xls, replace ctitle(CAR) bdec(4) tstat tdec(2) addtext(Year FE, YES, Industry FE, YES, Robust SE, NO) keep(total_acc_freq_5 Acc_Costs_Average_5 Acc_Costs_Bucket_5 DV CashOnly Diversifying relsize) vif reg CAR Acc_Costs_Average_5 DV CashOnly Diversifying relsize i.Year i.SIC_two outreg2 using CAR_-1_1_acosts.xls, append ctitle(CAR) bdec(4) tstat tdec(2) addtext(Year FE, YES, Industry FE, YES, Robust SE, NO) keep(total_acc_freq_5 Acc_Costs_Average_5 Acc_Costs_Bucket_5 DV CashOnly Diversifying relsize) vif reg CAR Acc_Costs_Bucket_5 DV CashOnly Diversifying relsize i.Year i.SIC_two outreg2 using CAR_-1_1_bcosts.xls, append ctitle(CAR) bdec(4) tstat tdec(2) addtext(Year FE, YES, Industry FE, YES, Robust SE, NO) keep(total_acc_freq_5 Acc_Costs_Average_5 Acc_Costs_Bucket_5 DV CashOnly Diversifying relsize) vif