Creating regression loops with different dep var

[Cansu Oymak]

Dear Statalist Users



I would like to create a regression loop for 5 dependent variables (i.e., trust_pres trust_parliament trust_rulingpty trust_opposition trust_police) for the following specifications. I have a region FE (i.e., GADM_1) and year FE (i.e., yr). I would like to have a loop such that
My control vars are as follows:

global controls age agesq education urban conflict_intensity tmp_landarea tmp_landarea_sq pre_landarea pre_landarea_sq

The table structure I would like is with six columns.

1) Column (1) - without controls: reghdfe trust_pres refugee_population_2000, absorb(yr GADM_1) cluster(GADM_1)
outreg2 using "$dir_results\AB_table1A.tex", stats(coef se) tex bdec(4) sdec(4) nor2 nocons label replace

Split by sex such that :

Column (2) eghdfe trust_pres refugee_population_2000 if sex==1, absorb(yr GADM_1) cluster(GADM_1)
outreg2 using "$dir_results\AB_table1A.tex", stats(coef se) tex bdec(4) sdec(4) nor2 nocons label append

Column (3)reghdfe trust_pres refugee_population_2000 if sex==2, absorb(yr GADM_1) cluster(GADM_1)
outreg2 using "$dir_results\AB_table1A.tex", stats(coef se) tex bdec(4) sdec(4) nor2 nocons label append


3) Column (4) - with controls and country-year FE : reghdfe trust_pres refugee_population_2000 $controls, absorb(yr GADM_1 country_year_FE) cluster(GADM_1)
outreg2 using "$dir_results\AB_table1A.tex", stats(coef se) tex bdec(4) sdec(4) nor2 nocons label append

Split by sex such that :

Column (5) reghdfe trust_pres refugee_population_2000 if sex==1, absorb(yr GADM_1) cluster(GADM_1)
outreg2 using "$dir_results\AB_table1A.tex", stats(coef se) tex bdec(4) sdec(4) nor2 nocons label append

Column (6)reghdfe trust_pres refugee_population_2000 if sex==2, absorb(yr GADM_1) cluster(GADM_1)
outreg2 using "$dir_results\AB_table1A.tex", stats(coef se) tex bdec(4) sdec(4) nor2 nocons label append



However, I would like to do it for every dependent variable I have. Thank you very much for your help!

* Example generated by -dataex-. To install: ssc install dataex
clear
input float(trust_pres trust_parliament trust_rulingpty trust_opposition trust_police) str26 GADM_1 float(country_year_FE refugee_population_2000 age urban agesq education conflict_intensity tmp_landarea tmp_landarea_sq pre_landarea pre_landarea_sq)
0 . 0 0 1 "Alibori" 1 0 50 0 2500 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 43 1 1849 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 45 0 2025 . 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 34 0 1156 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 26 0  676 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 50 0 2500 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 60 0 3600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 0 0 0 "Alibori" 1 0 49 0 2401 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 0 0 1 "Alibori" 1 0 25 0  625 3 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 0 0 . "Alibori" 1 0 36 0 1296 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 28 1  784 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 20 0  400 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . . "Alibori" 1 0 21 0  441 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 52 0 2704 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 0 0 1 "Alibori" 1 0 37 1 1369 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 28 1  784 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 27 1  729 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 43 1 1849 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 50 0 2500 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 67 0 4489 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . 1 "Alibori" 1 0 45 0 2025 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 50 0 2500 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 40 0 1600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 51 0 2601 2 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 30 1  900 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 0 0 1 "Alibori" 1 0 28 0  784 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 19 0  361 3 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . . "Alibori" 1 0 20 0  400 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 55 0 3025 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 0 0 0 0 "Alibori" 1 0 35 1 1225 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 46 0 2116 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 68 0 4624 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . . "Alibori" 1 0 60 0 3600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 70 0 4900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 39 0 1521 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 56 0 3136 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 51 1 2601 2 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 25 0  625 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 47 1 2209 1 0  .001081103 1.1687837e-06 .035415772 .001254277
0 0 0 0 1 "Alibori" 1 0 35 1 1225 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 30 0  900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 0 0 1 "Alibori" 1 0 54 1 2916 . 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 37 1 1369 3 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 25 0  625 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 0 1 0 1 "Alibori" 1 0 45 0 2025 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 0 0 1 "Alibori" 1 0 35 0 1225 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 48 1 2304 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 . 1 "Alibori" 1 0 27 0  729 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 25 0  625 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 25 1  625 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 60 1 3600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 25 0  625 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 . 1 "Alibori" 1 0 30 0  900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 0 0 0 1 "Alibori" 1 0 27 1  729 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 30 0  900 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 0 0 1 "Alibori" 1 0 21 0  441 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 45 1 2025 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 28 1  784 3 0  .001081103 1.1687837e-06 .035415772 .001254277
1 0 1 0 1 "Alibori" 1 0 50 0 2500 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. 1 . . . "Alibori" 1 0 47 0 2209 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 40 0 1600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 28 1  784 3 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 50 0 2500 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 30 0  900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 70 0 4900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 . 1 "Alibori" 1 0 30 0  900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 30 0  900 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 19 0  361 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 72 1 5184 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 0 "Alibori" 1 0 48 0 2304 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 39 0 1521 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 25 1  625 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 40 0 1600 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 40 1 1600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . . "Alibori" 1 0 20 0  400 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . 1 "Alibori" 1 0 65 0 4225 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 32 0 1024 1 0  .001081103 1.1687837e-06 .035415772 .001254277
0 1 1 1 1 "Alibori" 1 0 32 0 1024 2 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 40 0 1600 1 0  .001081103 1.1687837e-06 .035415772 .001254277
0 0 1 1 1 "Alibori" 1 0 55 0 3025 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 44 0 1936 1 0  .001081103 1.1687837e-06 .035415772 .001254277
. . . . . "Alibori" 1 0 22 0  484 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 1 1 "Alibori" 1 0 20 0  400 1 0  .001081103 1.1687837e-06 .035415772 .001254277
0 0 0 1 1 "Alibori" 1 0 29 0  841 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 53 0 2809 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . 1 "Alibori" 1 0 43 1 1849 1 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . 1 1 1 "Alibori" 1 0 33 0 1089 2 0  .001081103 1.1687837e-06 .035415772 .001254277
1 1 1 0 1 "Alibori" 1 0 35 0 1225 3 0  .001081103 1.1687837e-06 .035415772 .001254277
1 . . . 1 "Atacora" 1 0 42 1 1764 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 . . 0 1 "Atacora" 1 0 63 1 3969 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
. . . . . "Atacora" 1 0 54 0 2916 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 1 1 1 1 "Atacora" 1 0 38 1 1444 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 1 1 1 1 "Atacora" 1 0 40 1 1600 3 0 .0013892616 1.9300478e-06  .05024647 .002524708
. . . . . "Atacora" 1 0 25 0  625 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 . . . . "Atacora" 1 0 25 0  625 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 0 1 1 1 "Atacora" 1 0 40 1 1600 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 1 1 1 1 "Atacora" 1 0 18 0  324 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 1 1 0 1 "Atacora" 1 0 26 0  676 2 0 .0013892616 1.9300478e-06  .05024647 .002524708
1 1 1 1 1 "Atacora" 1 0 34 0 1156 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
. . . . . "Atacora" 1 0 80 1 6400 1 0 .0013892616 1.9300478e-06  .05024647 .002524708
end
label values trust_pres trust_pres
label def trust_pres 0 "do not trust", modify
label def trust_pres 1 "trust", modify
label values trust_parliament trust_parliament
label def trust_parliament 0 "do not trust", modify
label def trust_parliament 1 "trust", modify
label values trust_rulingpty trust_rulingpty
label def trust_rulingpty 0 "do not trust", modify
label def trust_rulingpty 1 "trust", modify
label values trust_opposition trust_opposition
label def trust_opposition 0 "do not trust", modify
label def trust_opposition 1 "trust", modify
label values trust_police trust_police
label def trust_police 0 "do not trust", modify
label def trust_police 1 "trust", modify
label values urban urban
label def urban 0 "rural", modify
label def urban 1 "urban", modify
label values education education
label def education 1 "no school", modify
label def education 2 "primary school", modify
label def education 3 "secondary school", modify

[George Ford]

sysuse auto, clear

local i = 1
foreach dv in mpg price weight {
    eststo e`i': qui reg `dv' displacement foreign
    local i = `i' + 1
}
esttab e1 e2 e3