/* Table 5 */ clear cd "" //Directory where data is located **** load the new file with all the variables use PSS_data.dta, clear ************CREATE THE RATE OF CHANGES************************ ** RATE of change of STEM immigrants as % of 1980-based labor force, different definitions sort metarea year *STEM O*NET 4% gen delta_imm_stemO4=(imm_stemO4-imm_stemO4[_n-1])/labforce[_n-1] if year>=1980 *STEM O*NET 8% gen delta_imm_stemO8=(imm_stemO8-imm_stemO8[_n-1])/labforce[_n-1] if year>=1980 *STEM MAJOR 4% gen delta_imm_stemM4=(imm_stemM4-imm_stemM4[_n-1])/labforce[_n-1] if year>=1980 *STEM O*NET 8% gen delta_imm_stemM8=(imm_stemM8-imm_stemM8[_n-1])/labforce[_n-1] if year>=1980 *** RATE OF CHANGE OF TOTAL STEM AS % OF 1980 LABOR FORCE, different definitions *STEM O*NET 4% gen delta_tot_stemO4=(tot_stemO4-tot_stemO4[_n-1])/labforce[_n-1] if year>=1990 *STEM O*NET 8% gen delta_tot_stemO8=(tot_stemO8-tot_stemO8[_n-1])/labforce[_n-1] if year>=1990 *STEM MAJOR 4% gen delta_tot_stemM4=(tot_stemM4-tot_stemM4[_n-1])/labforce[_n-1] if year>=1990 *STEM O*NET 8% gen delta_tot_stemM8=(tot_stemM8-tot_stemM8[_n-1])/labforce[_n-1] if year>=1990 *** H1B imputed rate of change of STEM, used as IV, different definition, 1980 base year *STEM O*NET 4% gen delta_imm_stemO4_H1B_hat80=(imm_stemO4_H1B_hat80-imm_stemO4_H1B_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 *STEM O*NET 8% gen delta_imm_stemO8_H1B_hat80=(imm_stemO8_H1B_hat80-imm_stemO8_H1B_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 *STEM MAJOR 4% gen delta_imm_stemM4_H1B_hat80=(imm_stemM4_H1B_hat80-imm_stemM4_H1B_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 *STEM O*NET 8% gen delta_imm_stemM8_H1B_hat80=(imm_stemM8_H1B_hat80-imm_stemM8_H1B_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 ********************************************* /* construct controls for native stem */ gen native_STEM_O4_share=nat_stemO4_emp/ labforce if year>=1980 gen native_STEM_M4_share=nat_stemM4_emp/ labforce if year>=1980 * variable that repeats each year the 1980 native stem share gen native_STEM_O4_share_1980=native_STEM_O4_share replace native_STEM_O4_share_1980=native_STEM_O4_share_1980[_n-1] if year==1990 replace native_STEM_O4_share_1980=native_STEM_O4_share_1980[_n-1] if year==2000 replace native_STEM_O4_share_1980=native_STEM_O4_share_1980[_n-1] if year==2005 replace native_STEM_O4_share_1980=native_STEM_O4_share_1980[_n-1] if year==2010 gen native_STEM_M4_share_1980=native_STEM_M4_share replace native_STEM_M4_share_1980=native_STEM_M4_share_1980[_n-1] if year==1990 replace native_STEM_M4_share_1980=native_STEM_M4_share_1980[_n-1] if year==2000 replace native_STEM_M4_share_1980=native_STEM_M4_share_1980[_n-1] if year==2005 replace native_STEM_M4_share_1980=native_STEM_M4_share_1980[_n-1] if year==2010 ***** construct the changes in dependent variables, definition O4 and M4, M8 ** wages of college and no-college gen delta_native_coll_wkwage=(nat_coll_wkwage-nat_coll_wkwage[_n-1])/nat_coll_wkwage[_n-1] if year>=1980 gen delta_native_nocoll_wkwage=(nat_nocoll_wkwage-nat_nocoll_wkwage[_n-1])/nat_nocoll_wkwage[_n-1] if year>=1980 gen delta_native_hs_wkwage=(nat_hs_wkwage-nat_hs_wkwage[_n-1])/nat_hs_wkwage[_n-1] if year>=1980 gen delta_native_nohs_wkwage=(nat_nohs_wkwage-nat_nohs_wkwage[_n-1])/nat_nohs_wkwage[_n-1] if year>=1980 * wages of stem and non-stem college gen delta_native_stemO4_wkwage=(nat_stemO4_wkwage-nat_stemO4_wkwage[_n-1])/nat_stemO4_wkwage[_n-1] if year>=1980 gen delta_native_coll_stemO4_wkwage=(nat_coll_stemO4_wkwage-nat_coll_stemO4_wkwage[_n-1])/nat_coll_stemO4_wkwage[_n-1] if year>=1980 gen delta_native_coll_nstemO4_wkwage=(nat_coll_nonstemO4_wkwage-nat_coll_nonstemO4_wkwage[_n-1])/nat_coll_nonstemO4_wkwage[_n-1] if year>=1980 gen delta_native_stemM4_wkwage=(nat_stemM4_wkwage-nat_stemM4_wkwage[_n-1])/nat_stemM4_wkwage[_n-1] if year>=1980 gen delta_native_coll_stemM4_wkwage=(nat_coll_stemM4_wkwage-nat_coll_stemM4_wkwage[_n-1])/nat_coll_stemM4_wkwage[_n-1] if year>=1980 gen delta_native_coll_nstemM4_wkwage=(nat_coll_nonstemM4_wkwage-nat_coll_nonstemM4_wkwage[_n-1])/nat_coll_nonstemM4_wkwage[_n-1] if year>=1980 gen delta_native_stemM8_wkwage=(nat_stemM8_wkwage-nat_stemM8_wkwage[_n-1])/nat_stemM8_wkwage[_n-1] if year>=1980 gen delta_native_coll_stemM8_wkwage=(nat_coll_stemM8_wkwage-nat_coll_stemM8_wkwage[_n-1])/nat_coll_stemM8_wkwage[_n-1] if year>=1980 gen delta_native_coll_nstemM8_wkwage=(nat_coll_nonstemM8_wkwage-nat_coll_nonstemM8_wkwage[_n-1])/nat_coll_nonstemM8_wkwage[_n-1] if year>=1980 gen delta_native_stemO8_wkwage=(nat_stemO8_wkwage-nat_stemO8_wkwage[_n-1])/nat_stemO8_wkwage[_n-1] if year>=1980 gen delta_native_coll_stemO8_wkwage=(nat_coll_stemO8_wkwage-nat_coll_stemO8_wkwage[_n-1])/nat_coll_stemO8_wkwage[_n-1] if year>=1980 gen delta_native_coll_nstemO8_wkwage=(nat_coll_nonstemO8_wkwage-nat_coll_nonstemO8_wkwage[_n-1])/nat_coll_nonstemO8_wkwage[_n-1] if year>=1980 ** employment of college and no-college. growth relative to total employment gen delta_native_coll_emp=(nat_coll_emp-nat_coll_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_nocoll_emp=(nat_nocoll_emp-nat_nocoll_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_hs_emp=(nat_hs_emp-nat_hs_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_nohs_emp=(nat_nohs_emp-nat_nohs_emp[_n-1])/labforce[_n-1] if year>=1980 * employment of stem and non-stem college (O4) gen delta_native_stemO4_emp=(nat_stemO4_emp-nat_stemO4_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_stemO4_emp=(nat_coll_stemO4_emp-nat_coll_stemO4_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_nonstemO4_emp=(nat_coll_nonstemO4_emp-nat_coll_nonstemO4_emp[_n-1])/labforce[_n-1] if year>=1980 *def, M4 gen delta_native_stemM4_emp=(nat_stemM4_emp-nat_stemM4_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_stemM4_emp=(nat_coll_stemM4_emp-nat_coll_stemM4_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_nonstemM4_emp=(nat_coll_nonstemM4_emp-nat_coll_nonstemM4_emp[_n-1])/labforce[_n-1] if year>=1980 *def M8 gen delta_native_stemM8_emp=(nat_stemM8_emp-nat_stemM8_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_stemM8_emp=(nat_coll_stemM8_emp-nat_coll_stemM8_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_nonstemM8_emp=(nat_coll_nonstemM8_emp-nat_coll_nonstemM8_emp[_n-1])/labforce[_n-1] if year>=1980 **def O8 gen delta_native_stemO8_emp=(nat_stemO8_emp-nat_stemO8_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_stemO8_emp=(nat_coll_stemO8_emp-nat_coll_stemO8_emp[_n-1])/labforce[_n-1] if year>=1980 gen delta_native_coll_nstemO8_emp=(nat_coll_nonstemO8_emp-nat_coll_nonstemO8_emp[_n-1])/labforce[_n-1] if year>=1980 *** defines top 5 STEM cities *** gen top5=0 replace top5=1 if metarea==560 /* New York */ replace top5=1 if metarea==448 /* Los Angeles */ replace top5=1 if metarea==160 /* Chicago */ replace top5=1 if metarea==736 /* San Francisco */ replace top5=1 if metarea==740 /* San Jose */ ** without indians *STEM O*NET 4% gen delta_imm_stemO4_noi_H1B_hat80=(imm_stemO4_noi_H1B_hat80-imm_stemO4_noi_H1B_hat80[_n-1])/labforce_noi_hat80[_n-1] if year>=1990 *STEM MAJOR 4% gen delta_imm_stemM4_noi_H1B_hat80=(imm_stemM4_noi_H1B_hat80-imm_stemM4_noi_H1B_hat80[_n-1])/labforce_noi_hat80[_n-1] if year>=1990 *STEM O*NET 8% gen delta_imm_stemO8_noi_H1B_hat80=(imm_stemO8_noi_H1B_hat80-imm_stemO8_noi_H1B_hat80[_n-1])/labforce_noi_hat80[_n-1] if year>=1990 **** aggregate flows for H1b *STEM O*NET 4% gen delta_imm_stemO4_H1Bagg_hat80=(imm_stemO4_H1Bagg_hat80-imm_stemO4_H1Bagg_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 *STEM MAJOR 4% gen delta_imm_stemM4_H1Bagg_hat80=(imm_stemM4_H1Bagg_hat80-imm_stemM4_H1Bagg_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 *STEM O*NET 8% gen delta_imm_stemO8_H1Bagg_hat80=(imm_stemO8_H1Bagg_hat80-imm_stemO8_H1Bagg_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 *** bartik predictors sort metarea year gen bartik_coll_wage=(pred_coll_wkwage-pred_coll_wkwage[_n-1])/pred_coll_wkwage[_n-1] if year>1990 gen bartik_nocoll_wage=(pred_nocoll_wkwage-pred_nocoll_wkwage[_n-1])/pred_nocoll_wkwage[_n-1] if year>1990 gen bartik_coll_emp=(pred_coll_emp-pred_coll_emp[_n-1])/pred_emp[_n-1] if year>1990 gen bartik_nocoll_emp=(pred_nocoll_emp-pred_nocoll_emp[_n-1])/pred_emp[_n-1] if year>1990 ** college share gen nat_coll_share=nat_coll_emp/(nat_coll_emp+nat_nocoll_emp) sum nat_coll_share **** Table 5 *Table 5, row (a) * explanatory is STEM O*net definition 4%, coefficients (1)-(6) in order xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) test delta_imm_stemO4==8.03 xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) *Table 5, row (b) *explanatory is STEM Major definition 4%; coefficients (1)-(6) in order xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemM4 = delta_imm_stemM4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemM4 = delta_imm_stemM4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemM4 = delta_imm_stemM4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemM4 = delta_imm_stemM4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemM4 = delta_imm_stemM4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemM4 = delta_imm_stemM4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) *Table 5, row (c) *explanatory is STEM O*net definition 8% xi: ivreg2 delta_native_stemO8_wkwage (delta_imm_stemO8 = delta_imm_stemO8_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO8 = delta_imm_stemO8_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO8 = delta_imm_stemO8_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO8_emp (delta_imm_stemO8 = delta_imm_stemO8_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO8 = delta_imm_stemO8_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO8 = delta_imm_stemO8_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) ** Table 5, row (d) *no top 5 cities, O*NET 4% definition xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1 & top5==0, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1 & top5==0, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1 & top5==0, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1 & top5==0, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea if year>1990 & panel1980==1 & top5==0, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea if year>1990 & panel1980==1 & top5==0, robust cluster(metarea) ** Table 5, row (e) *controlling for imputed less educated immigrants in order to eliminate complementarieties gen delta_imm_nocoll_hat80=(imm_nocoll_hat80-imm_nocoll_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) ** Table 5, row(f) *omit metro areas smaller than 400,000. this eliminates the cities with 0 foreign STEM and 0 imputed foreign STEM xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1 & popwt>400000, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1 & popwt>400000, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1 & popwt>400000, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1 & popwt>400000, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1 & popwt>400000, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1 & popwt>400000, robust cluster(metarea) ** Table 5, row (g) *No indians IV, O4 and control for less educated xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_noi_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea delta_imm_nocoll_hat80 if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_noi_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea delta_imm_nocoll_hat80 if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_noi_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year delta_imm_nocoll_hat80 i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_noi_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea delta_imm_nocoll_hat80 if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_noi_H1B_hat80) bartik_coll_wage bartik_coll_emp i.year i.metarea delta_imm_nocoll_hat80 if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_noi_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp i.year i.metarea delta_imm_nocoll_hat80 if year>1990 & panel1980==1, robust cluster(metarea) ** Table 5, row (h) *aggregate H1B flow for IV xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1Bagg_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1Bagg_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1Bagg_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_H1Bagg_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1Bagg_hat80) bartik_coll_wage bartik_coll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1Bagg_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) ** Table 5, row (i) *controlling for imputed highly educated natives gen delta_nat_coll_hat80=(nat_coll_hat80-nat_coll_hat80[_n-1])/labforce_hat80[_n-1] if year>=1990 xi: ivreg2 delta_native_stemO4_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_nat_coll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_nat_coll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_wkwage (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_nat_coll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_stemO4_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_nat_coll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_coll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_coll_wage bartik_coll_emp delta_nat_coll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) xi: ivreg2 delta_native_nocoll_emp (delta_imm_stemO4 = delta_imm_stemO4_H1B_hat80) bartik_nocoll_wage bartik_nocoll_emp delta_nat_coll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) ** Table 5, row (j) **OLS reg delta_native_stemO4_wkwage delta_imm_stemO4 bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) reg delta_native_coll_wkwage delta_imm_stemO4 bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) reg delta_native_nocoll_wkwage delta_imm_stemO4 bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) reg delta_native_stemO4_emp delta_imm_stemO4 bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) reg delta_native_coll_emp delta_imm_stemO4 bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) reg delta_native_nocoll_emp delta_imm_stemO4 bartik_nocoll_wage bartik_nocoll_emp delta_imm_nocoll_hat80 i.year i.metarea if year>1990 & panel1980==1, robust cluster(metarea) ********* *COLUMN 4, TABLE 4 **** ** Column 4 of Table 5,test of pre-trend correlations ** predicts growth of native college wages in 1990's and 2000's sort metarea year gen delta_native_coll_wkwage_l2=delta_native_coll_wkwage[_n-2] if year==2000 & panel1970==1 gen delta_native_coll_wkwage_l3=delta_native_coll_wkwage[_n-3] if year==2005 & panel1970==1 ** pre-1980 wage trends: are they correlated with instruments? reg delta_native_coll_wkwage_l2 delta_imm_stemO4_H1B_hat80 i.statefip if year==2000 & panel1980==1, robust cluster(metarea) test delta_imm_stemO4_H1B_hat80 reg delta_native_coll_wkwage_l2 delta_imm_stemM4_H1B_hat80 i.statefip if year==2000 & panel1980==1, robust cluster(metarea) test delta_imm_stemM4_H1B_hat80 ****end*****