clear set more off cd "$constructeddirectory\" use alldhsirclean, clear cd "$outdirectory\" keep if polyg~=. global outopts dec(3) label nocons excel ctitle(" ") cttop(" ") nonotes *Main controls global controls $giscontrols $indivcontrols ***Conditional correlations genl anyeduc=respeducyears>0 if respeducyears~=., l(Any education) foreach depvar in respeducyears anyeduc { *Sample without geographic controls cap erase table4_`depvar'_nogeog.txt cap erase table4_`depvar'_nogeog.xml reg poly `depvar', cl(clusterid) outreg2 `depvar' using table4_`depvar'_nogeog, $outopts /// addtext(Other cont., None, F.E., None, Clustering, Cluster) append reg poly `depvar' $indivcontrols, cl(clusterid) outreg2 `depvar' using table4_`depvar'_nogeog, $outopts /// addtext(Other cont., Indiv., F.E., None, Clustering, Cluster) append areg polyg `depvar' $indivcontrols, a(countryroundid) cl(clusterid) outreg2 `depvar' using table4_`depvar'_nogeog, $outopts /// addtext(Other cont., Indiv., F.E., Country-round, Clustering, Cluster) append areg polyg `depvar' $indivcontrols, a(regionid) cl(clusterid) outreg2 `depvar' using table4_`depvar'_nogeog, $outopts /// addtext(Other cont., Indiv., F.E., Region, Clustering, Cluster) append areg polyg `depvar' $indivcontrols, a(clusterid) cl(clusterid) outreg2 `depvar' using table4_`depvar'_nogeog, $outopts /// addtext(Other cont., Indiv., F.E., Cluster, Clustering, Cluster) append cap erase table4_`depvar'_nogeog.txt *Sample with geographic controls cap erase table4_`depvar'_geog.txt cap erase table4_`depvar'_geog.xml reg poly `depvar' $giscontrols, cl(clusterid) outreg2 `depvar' using table4_`depvar'_geog, $outopts /// addtext(Other cont., None, F.E., None, Clustering, Cluster) append reg poly `depvar' $giscontrols $indivcontrols, cl(clusterid) outreg2 `depvar' using table4_`depvar'_geog, $outopts /// addtext(Other cont., Geo./Indiv., F.E., None, Clustering, Cluster) append areg polyg `depvar' $giscontrols $indivcontrols, a(countryroundid) cl(clusterid) outreg2 `depvar' using table4_`depvar'_geog, $outopts /// addtext(Other cont., Geo./Indiv., F.E., Country-round, Clustering, Cluster) append areg polyg `depvar' $giscontrols $indivcontrols, a(regionid) cl(clusterid) gen sample=e(sample)==1 outreg2 `depvar' using table4_`depvar'_geog, $outopts /// addtext(Other cont., Geo./Indiv., F.E., Region, Clustering, Cluster) append areg polyg `depvar' $indivcontrols if sample==1, a(clusterid) cl(clusterid) outreg2 `depvar' using table4_`depvar'_geog, $outopts /// addtext(Other cont., Geo./Indiv., F.E., Cluster, Clustering, Cluster) append drop sample cap erase table4_`depvar'_geog.txt }