/*combines sector level and regional foreign share in one regression*/ /*within regressions: domestic over entire sample*/ /*all sectors plus disaggregate estimation*/ /*modified july 28 to define fixed effect at 4-digit level*/ /* drop _all set maxobs 70000 set maxvar 51 width 148 use test gen mat = m9 + m10 - m13 - (n20 + n21 - n18 - n19) replace test4=6371064001 if test4==6371064005 replace x11=100 if test4==6371064001 & year==88 replace x11=84 if x11==16 & sic==3133 & year==77 replace x11=3 if sic==3822 & x11==25 replace x11=70 if sic==3829 & year==84 & l6==404 drop if sic==3829 & l6==1222 drop if sic==3111 & year==81 drop if sic==3112 & year==85 drop if sic==3523 & (year==89 | year==84) drop if sic==3118 drop if sic==3122 drop if sic==3419 drop if sic==3521 drop if sic==3833 drop if sic==3824 drop if sic==3132 drop if sic==3133 drop if sic==3219 drop if sic==3312 drop if sic==3512 drop if sic==3844 drop if sic==3849 drop if sic==3852 drop if sic==3853 drop if sic==3902 drop if sic==3903 replace x11=2 if x11==20 & year==86 & sic==3116 drop if sic==3119 & (year==81 | year==89) gen lprod=s1/l6 drop if lprod>1000000 drop lprod replace w88 = w88/1000 replace weight = w88 if year==89 save both, replace replace l6=l6*weight replace s2=s2*weight sort year sic x2 x3 collapse l6 s2, by(year sic x2 x3) sum(l6 s2) save temp2, replace drop _all use both sort year x2 x3 drop if l13==0 | l4==0 replace c2=c2*weight replace e2=e2*weight replace l4=l4*weight replace l13=l13*weight collapse c2 e2 l4 l13, by(year x2 x3) sum(c2 e2 l4 l13) rename c2 c2tot rename e2 e2tot rename l4 l4tot rename l13 l13tot save temp4, replace drop _all use both gen dfi=100-x11 replace dfi=dfi/100 replace l6=l6*weight replace s2=s2*weight gen s2b=0 gen l6b=0 replace s2b=s2 if dfi >0 & dfi ~=. replace l6b=l6 if dfi >0 & dfi ~=. replace l6=l6*dfi replace s2=s2*dfi collapse l6 s2 s2b l6b, by(year sic x2 x3) sum(l6 s2 s2b l6b) rename l6 l6f rename s2 s2f save temp3, replace use temp2 merge year sic using temp3 gen dfilax3=l6f/l6 gen dfisax3=s2f/s2 gen dfiluw=l6b/l6 gen dfisuw=s2b/s2 drop _merge rename l6f labfor rename l6 laball rename s2f salesfor rename s2 salesall label var dfilax3 "location-specific" keep year sic x2 x3 dfilax3 dfisax3 dfiluw dfisuw labfor laball salesfor salesall sort year x2 x3 merge year x2 x3 using temp4 sort year sic x2 x3 drop _merge save temp2, replace drop _all set maxvar 139 width 239 use both gen int sic2=int(sic/100) sort year sic x2 x3 merge year sic x2 x3 using temp2 drop _merge gen rwage=(l13tot-l13)/(l4tot-l4) gen elecp=(c2tot-c2)/(e2tot-e2) gen int flag=l4<1 replace l4=1 if l4<1 replace l4=log(l4) replace l5=log(l5) replace s1=log(s1) replace i91=log(i91) replace mat=log(mat) replace rwage=log(rwage) replace elecp=log(elecp) /*defining three samples*/ sort test4 year gen int flag1=x11~=100 quietly by test4:replace flag1=sum(flag1) quietly by test4:gen int flag2=flag1>0 quietly by test4:replace flag1=flag1[_N]>0 quietly by test4:replace flag1=1 if flag1>0 replace flag1=0 if flag1==1&test4==. replace flag2=0 if flag2==1&test4==. gen flag3=flag1==0&test4==. label var flag1 "once or will be foreign" label var flag2 "was once foreign" label var flag3 "unidentified" replace dfilax3=0 if dfilax3==. replace dfisax3=0 if dfisax3==. save both, replace drop _all set maxobs 70000 use caves rename dfilax3 dfisectl rename dfisax3 dfisects rename salesfor fsaless rename salesall saless rename labfor flabs rename laball labs rename dfisuw sectsuw rename dfiluw sectluw drop if test4==. keep dfisectl dfisects fsaless saless flabs labs sectsuw sectluw test4 year sort test4 year save temp1, replace use both drop if test4==. sort test4 year merge test4 year using temp1 drop _merge sort sic x2 x3 tab year, gen(y) tab sic2, gen(stwo) tab sic, gen(sfour) !erase temp1.dta !erase temp.dta !erase temp3.dta !erase temp4.dta save both, replace */ set more 1 drop _all set maxobs 70000 set matsize 250 use both keep if flag3==0 gen dfi=100-x11 replace dfi=dfi/100 gen dfisl=dfi*dfisectl gen dfiss=dfi*dfisects gen dfirl=dfi*dfilax3 gen dfirs=dfi*dfisax3 egen totl = sum(l6), by(year) gen share = l6/totl log using both1.log, replace set more 1 /*WHOLY DOMESTIC WITH 4-DIGIT DUMMIES*/ hreg s1 l4 l5 i91 dfi dfisl dfirl mat dfilax3 dfisectl y1-y14 sfour1-sfour58 [aweight=share] /* reg s1 l4 l5 i91 mat labfor laball flabs labs y1-y14 sfour1-sfour58 hreg s1 l4 l5 i91 mat labfor laball flabs labs y1-y14 sfour1-sfour58 reg s1 l4 l5 i91 mat salesfor salesall fsaless saless y1-y14 sfour1-sfour58 hreg s1 l4 l5 i91 mat salesfor salesall fsaless saless y1-y14 sfour1-sfour58 */ hreg s1 l4 l5 i91 mat dfi dfisl dfirl dfilax3 dfisectl rwage elecp y1-y14 sfour1-sfour58 [aweight=share] /* reg s1 l4 l5 i91 mat dfi dfiss dfirs dfisax3 dfisects rwage elecp y1-y14 sfour1-sfour58 hreg s1 l4 l5 i91 mat dfi dfiss dfirs dfisax3 dfisects rwage elecp y1-y14 sfour1-sfour58 reg s1 l4 l5 i91 mat labfor laball flabs labs rwage elecp y1-y14 sfour1-sfour58 hreg s1 l4 l5 i91 mat labfor laball flabs labs rwage elecp y1-y14 sfour1-sfour58 reg s1 l4 l5 i91 mat salesfor salesall fsaless saless rwage elecp y1-y14 sfour1-sfour58 hreg s1 l4 l5 i91 mat salesfor salesall fsaless saless rwage elecp y1-y14 sfour1-sfour58 */ log close