*Download the ascii files of the Barro-Lee data set specified below in your hard disk. *Change the directory according to the one in your pc, before running this do-file. version 6 capture log close cd c:\documents\ellison log using crgrowth.log,replace *This do-file creates the data set growth.dta (used by the do-file growth.do) *starting from the ascii files contained in the Barro-Lee data set (see NBER web site). *Notice that we do not have to create a dictionary, since the data set is not hierarchical. set more off clear set memory 50m infile a1 a2 a3 latin a4 safrica a5 using codes.prn drop a1-a3 a4 a5 gen country=_n sum sort country save tmp1.dta,replace clear infile gdp50 a1 gdp60 a2 a3 a4 a5 a6 grow1 grow2 grow3 grow4 grow5 a7 a8 a9 a10 a11 using gdpsh4.prn drop a1 a2-a6 a7-a11 gen country=_n sum sort country save tmp2.dta,replace clear infile pri1 pri2 pri3 pri4 pri5 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 using pri.prn drop a1-a13 gen country=_n sum sort country save tmp3.dta,replace clear infile sec1 sec2 sec3 sec4 sec5 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 using sec.prn drop a1-a13 gen country=_n sum sort country save tmp4.dta,replace clear infile high1 high2 high3 high4 high5 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 using high.prn drop a1-a13 gen country=_n sum sort country save tmp5.dta,replace clear infile hum1 hum2 hum3 hum4 hum5 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 using human.prn drop a1-a13 gen country=_n sum sort country save tmp6.dta,replace clear infile teapri50 a1 teapri60 a2 a3 a4 a5 teasec50 a6 teasec60 a7 a8 a9 a10 a11 a12 a13 using teacher.prn drop a1 a2-a5 a6 a7-a13 gen country=_n sum sort country save tmp7.dta,replace clear infile gov1 gov2 gov3 gov4 gov5 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 a14 a15 a16 using gvxdxe.prn drop a1-a16 gen country=_n sum sort country save tmp8.dta,replace clear infile edu1 edu2 edu3 edu4 edu5 a1 a2 a3 a4 a5 def1 def2 def3 def4 def5 using geegde.prn drop a1-a5 gen country=_n sum sort country save tmp9.dta,replace clear infile invpub1 invpub2 invpub3 invpub4 invpub5 a1 a2 a3 a4 a5 using invpub.prn drop a1-a5 gen country=_n sum sort country save tmp10.dta,replace clear infile ass1 ass2 ass3 ass4 ass5 coup1 coup2 coup3 coup4 coup5 rev1 rev2 rev3 rev4 rev5 a1 revcoup using politics.prn drop a1 gen country=_n sum sort country save tmp11.dta,replace clear infile a1 a2 a3 a4 a5 war a6 rights3 rights4 rights5 a7 a8 civlib3 civlib4 civlib5 a9 a10 using pinstab.prn drop a1-a5 a6 a7 a8 a9 a10 gen country=_n sum sort country save tmp12.dta,replace clear infile ex1 ex2 ex3 ex4 ex5 im1 im2 im3 im4 im5 a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 using trade.prn drop a1-a11 gen country=_n sum sort country save tmp13.dta,replace clear infile a1 a2 a3 a4 a5 a6 a7 a8 a9 a10 a11 a12 a13 a14 a15 a16 open barr a17 a18 a19 a20 a21 a22 using bmp.prn drop a1-a16 a17-a22 gen country=_n sum sort country joinby country using tmp1.dta joinby country using tmp2.dta joinby country using tmp3.dta joinby country using tmp4.dta joinby country using tmp5.dta joinby country using tmp6.dta joinby country using tmp7.dta joinby country using tmp8.dta joinby country using tmp9.dta joinby country using tmp10.dta joinby country using tmp11.dta joinby country using tmp12.dta joinby country using tmp13.dta sum label var country "SH5 country code" label var open "free trade openness" label var barr "tariff restriction" label var latin "dummy for Latin America" label var safrica "dummy for Sub-Saharan Africa" label var gdp50 "gdp p.c. 1950" label var gdp60 "gdp p.c. 1960" label var grow1 "gdp growth 1960-65" label var grow2 "gdp growth 1965-70" label var grow3 "gdp growth 1970-75" label var grow4 "gdp growth 1975-80" label var grow5 "gdp growth 1980-85" label var pri1 "average years primary 1960" label var pri2 "average years primary 1965" label var pri3 "average years primary 1970" label var pri4 "average years primary 1975" label var pri5 "average years primary 1980" label var sec1 "average years secondary 1960" label var sec2 "average years secondary 1965" label var sec3 "average years secondary 1970" label var sec4 "average years secondary 1975" label var sec5 "average years secondary 1980" label var high1 "average years higher 1960" label var high2 "average years higher 1965" label var high3 "average years higher 1970" label var high4 "average years higher 1975" label var high5 "average years higher 1980" label var hum1 "average years schooling 1960" label var hum2 "average years schooling 1965" label var hum3 "average years schooling 1970" label var hum4 "average years schooling 1975" label var hum5 "average years schooling 1980" label var teapri50 "pupil/teacher primary 1950" label var teapri60 "pupil/teacher primary 1960" label var teasec50 "pupil/teacher secondary 1950" label var teasec60 "pupil/teacher secondary 1960" label var gov1 "ratio of gov. consumption 1960-65" label var gov2 "ratio of gov. consumption 1965-70" label var gov3 "ratio of gov. consumption 1970-75" label var gov4 "ratio of gov. consumption 1975-80" label var gov5 "ratio of gov. consumption 1980-85" label var edu1 "ratio gov. exp. education 1960-65" label var edu2 "ratio gov. exp. education 1965-70" label var edu3 "ratio gov. exp. education 1970-75" label var edu4 "ratio gov. exp. education 1975-80" label var edu5 "ratio gov. exp. education 1980-85" label var def1 "ratio gov. exp. defense 1960-65" label var def2 "ratio gov. exp. defense 1965-70" label var def3 "ratio gov. exp. defense 1970-75" label var def4 "ratio gov. exp. defense 1975-80" label var def5 "ratio gov. exp. defense 1980-85" label var invpub1 "ratio of gov. investment 1960-65" label var invpub2 "ratio of gov. investment 1965-70" label var invpub3 "ratio of gov. investment 1970-75" label var invpub4 "ratio of gov. investment 1975-80" label var invpub5 "ratio of gov. investment 1980-85" label var ex1 "ratio export 1960-65" label var ex2 "ratio export 1965-70" label var ex3 "ratio export 1970-75" label var ex4 "ratio export 1975-80" label var ex5 "ratio export 1980-85" label var im1 "ratio import 1960-65" label var im2 "ratio import 1965-70" label var im3 "ratio import 1970-75" label var im4 "ratio import 1975-80" label var im5 "ratio import 1980-85" label var ass1 "assassinations per million pop. 1960-65" label var ass2 "assassinations per million pop. 1965-70" label var ass3 "assassinations per million pop. 1970-75" label var ass4 "assassinations per million pop. 1975-80" label var ass5 "assassinations per million pop. 1980-85" label var coup1 "coups per year 1960-65" label var coup2 "coups per year 1965-70" label var coup3 "coups per year 1970-75" label var coup4 "coups per year 1975-80" label var coup5 "coups per year 1980-85" label var rev1 "revolutions per year 1960-65" label var rev2 "revolutions per year 1965-70" label var rev3 "revolutions per year 1970-75" label var rev4 "revolutions per year 1975-80" label var rev5 "revolutions per year 1980-85" label var revcoup "revolutions+coups per year 1960-85" label var war "time external war 1960-85" save growth.dta,replace *Suggestion: remember to remove the tmp* files from your hard disk. log close