esttab issue

[Collin James]

Hi,

When I look at panelquad1f.tex and balancep2kids.tex, it does not show all of tehse results. It only shows the variables black, male, and investigation for one sample. Not sure why , can you help

*Table 0 - balance 
include "https://raw.githubusercontent.com/steveofconnell/PanelCombine/master/PanelCombine.do"

gen allbw=(Black==1|White==1)
eststo clear
local count=1

    foreach var in Black male inv_p6m service_p6m removed_p6m dw_housing_p6 dw_medicaid_p6 dw_outpatient_p6 dw_crt_fam_dep_p6 anycrtp6 dw_drug_alc_p6 dw_benefits_p6 dw_jail_p6 selfhea_p6 injaut_p6 nutrit_p6 injnoaut_p6 schnitzer_p6 prevent_p6 wellness_p6 immune_p6 poison_p6 {
        
        
        rdrobust `var' poolednormscore2 if allbw==1,c(0) h($bw2lvp $bw2rvp ) vce(cluster refer_id) 
        estadd scalar leftbw= e(N_h_l) 
        estadd scalar rightbw= e(N_h_r) 
        sum `var'  if (poolednormscore2> -$bw2lvp & poolednormscore2 < 0 ) & allbw==1
        estadd scalar ymean = r(mean)
        eststo mal`i'1619p2f
    }
    
        foreach var in Black male inv_p6m service_p6m removed_p6m dw_housing_p6 dw_medicaid_p6 dw_outpatient_p6 dw_crt_fam_dep_p6 anycrtp6 dw_drug_alc_p6 dw_benefits_p6 dw_jail_p6 selfhea_p6 injaut_p6 nutrit_p6 injnoaut_p6 schnitzer_p6 prevent_p6 wellness_p6 immune_p6 poison_p6 {
        
        
        rdrobust `var' poolednormscore2 if White==1,c(0) h($bw2lvp $bw2rvp ) vce(cluster refer_id) 
        estadd scalar leftbw= e(N_h_l) 
        estadd scalar rightbw= e(N_h_r) 
        sum `var'  if (poolednormscore2> -$bw2lvp & poolednormscore2 < 0 ) & White==1
        estadd scalar ymean = r(mean)
        eststo mwh`i'1619p2f
    }
    
    foreach var in Black male inv_p6m service_p6m removed_p6m dw_housing_p6 dw_medicaid_p6 dw_outpatient_p6 dw_crt_fam_dep_p6 anycrtp6 dw_drug_alc_p6 dw_benefits_p6 dw_jail_p6 selfhea_p6 injaut_p6 nutrit_p6 injnoaut_p6 schnitzer_p6 prevent_p6 wellness_p6 immune_p6 poison_p6 {
        
        
        rdrobust `var' poolednormscore2 if Black==1,c(0) h($bw2lvp $bw2rvp ) vce(cluster refer_id) 
        estadd scalar leftbw= e(N_h_l) 
        estadd scalar rightbw= e(N_h_r) 
        sum `var'  if (poolednormscore2> -$bw2lvp & poolednormscore2 < 0 ) & Black==1
        estadd scalar ymean = r(mean)
        eststo mbl`i'1619p2f
    }

    esttab *1619p2f using "Panelquad`count'f.tex", style(tex) replace stats(ymean rightbw leftbw,labels("Mean" "RightBW" "LeftBW")) label se star(* 0.1 ** 0.05 *** 0.01) mtitles("Black" "Male" "Investigation" "Accepted" "Removed" "Housing" "Medicaid" "Outpatient" "Dependent crt" "any charge" "DA" "Benefits" "Jail" "Selfharm" "Injaut" "Nutr" "Injnoaut" "Schnitzer" "Prevent" "Wellness" "Immune" "Poison" ) coeflabels(RD_Estimate "Estimate")

    
  *prime balance table in paper
panelcombine, use(Panelquadf.tex) columncount(22) paneltitles("All" "White children" "Black children") save(balancep2kids.tex) cleanup

[Nils Enevoldsen]

Just eyeballing it: you never increment `count', so you keep overwriting your estimation results. I’m not sure if that’s the whole issue, but it’s the first thing I noticed.