* For further details see http://jutze.com/research/2016-schult-sparfeldt-pirls-timss * MC vs CR project * data mangement * create timss2007.dta * written by Johannes Schult j.schult@mx.uni-saarland.de * last updated 2014-01-30 * note to self: M031223 and M031002 are empty; the items are not used in scaling * see respective.xls file in http://timss.bc.edu/TIMSS2007/PDF/T07_Items.zip version 13.1 set more off clear use timss2007 keep if IDBOOK == 1 keep if mM031045 != . & mM041006 != . * A (2mc, 8 1) local Amc = "mM031045 mM031335" order `Amc' export delimited `Amc' using data1Amc.csv, delimiter(tab) novarnames replace local Acr = "mM031068 mM031106 mM031134 mM031227 mM031271 mM031286 mM031299 mM031301 mM031282" order `Acr' export delimited `Acr' using data1Acr.csv, delimiter(tab) novarnames replace * B (6mc, 8 0) local Bmc = "mM041006 mM041014 mM041039 mM041094 mM041173 mM041330" order `Bmc' export delimited `Bmc' using data1Bmc.csv, delimiter(tab) novarnames replace local Bcr = "mM041203 mM041250 mM041274 mM041278 mM041300A mM041300B mM041300C mM041300D" order `Bcr' export delimited `Bcr' using data1Bcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id1, replace restore clear use timss2007 keep if IDBOOK == 2 keep if mM041006 != . & mM031050 != . * B (6mc, 8 0) local Bmc = "mM041006 mM041014 mM041039 mM041094 mM041173 mM041330" order `Bmc' export delimited `Bmc' using data2Bmc.csv, delimiter(tab) novarnames replace local Bcr = "mM041203 mM041250 mM041274 mM041278 mM041300A mM041300B mM041300C mM041300D" order `Bcr' export delimited `Bcr' using data2Bcr.csv, delimiter(tab) novarnames replace * C (3mc, 9 0) local Cmc = "mM031050 mM031255 mM031334" order `Cmc' export delimited `Cmc' using data2Cmc.csv, delimiter(tab) novarnames replace local Ccr = "mM031041 mM031235 mM031240 mM031258 mM031274 mM031285 mM031350A mM031350B mM031350C" order `Ccr' export delimited `Ccr' using data2Ccr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id2, replace restore clear use timss2007 keep if IDBOOK == 3 keep if mM031050 != . & mM041052 != . * C (3mc, 9 0) local Cmc = "mM031050 mM031255 mM031334" order `Cmc' export delimited `Cmc' using data3Cmc.csv, delimiter(tab) novarnames replace local Ccr = "mM031041 mM031235 mM031240 mM031258 mM031274 mM031285 mM031350A mM031350B mM031350C" order `Ccr' export delimited `Ccr' using data3Ccr.csv, delimiter(tab) novarnames replace * D (8mc, 5 1) local Dmc = "mM041052 mM041069 mM041131 mM041152 mM041164 mM041186 mM041281 mM041336" order `Dmc' export delimited `Dmc' using data3Dmc.csv, delimiter(tab) novarnames replace local Dcr = "mM041056 mM041076 mM041146 mM041258A mM041258B mM041275" order `Dcr' export delimited `Dcr' using data3Dcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id3, replace restore clear use timss2007 keep if IDBOOK == 4 keep if mM041052 != . & mM031085 != . * D (8mc, 5 1) local Dmc = "mM041052 mM041069 mM041131 mM041152 mM041164 mM041186 mM041281 mM041336" order `Dmc' export delimited `Dmc' using data4Dmc.csv, delimiter(tab) novarnames replace local Dcr = "mM041056 mM041076 mM041146 mM041258A mM041258B mM041275" order `Dcr' export delimited `Dcr' using data4Dcr.csv, delimiter(tab) novarnames replace * E (7mc, 3 1) local Emc = "mM031085 mM031172 mM031173 mM031219 mM031242C mM031245 mM031303" order `Emc' export delimited `Emc' using data4Emc.csv, delimiter(tab) novarnames replace local Ecr = "mM031242A mM031242B mM031309 mM031247" order `Ecr' export delimited `Ecr' using data4Ecr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id4, replace restore clear use timss2007 keep if IDBOOK == 5 keep if mM031085 != . & mM041010 != . * E (7mc, 3 1) local Emc = "mM031085 mM031172 mM031173 mM031219 mM031242C mM031245 mM031303" order `Emc' export delimited `Emc' using data5Emc.csv, delimiter(tab) novarnames replace local Ecr = "mM031242A mM031242B mM031309 mM031247" order `Ecr' export delimited `Ecr' using data5Ecr.csv, delimiter(tab) novarnames replace * H (7mc, 5 2) local Hmc = "mM041010 mM041098 mM041155 mM041158 mM041184 mM041329 mM041335" order `Hmc' export delimited `Hmc' using data5Hmc.csv, delimiter(tab) novarnames replace local Hcr = "mM041003 mM041064 mM041104 mM041299 mM041328 mM041143 mM041284" order `Hcr' export delimited `Hcr' using data5Hcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id5, replace restore clear use timss2007 keep if IDBOOK == 6 keep if mM041010 != . & mM031006 != . * H (7mc, 5 2) local Hmc = "mM041010 mM041098 mM041155 mM041158 mM041184 mM041329 mM041335" order `Hmc' export delimited `Hmc' using data6Hmc.csv, delimiter(tab) novarnames replace local Hcr = "mM041003 mM041064 mM041104 mM041299 mM041328 mM041143 mM041284" order `Hcr' export delimited `Hcr' using data6Hcr.csv, delimiter(tab) novarnames replace * F (10mc, 2 0) local Fmc = "mM031006 mM031029 mM031038 mM031064 mM031098 mM031135 mM031254 mM031276 mM031332 mM031351" order `Fmc' export delimited `Fmc' using data6Fmc.csv, delimiter(tab) novarnames replace local Fcr = "mM031030 mM031330" order `Fcr' export delimited `Fcr' using data6Fcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id6, replace restore clear use timss2007 keep if IDBOOK == 7 keep if mM031006 != . & mM041065A != . * F (10mc, 2 0) local Fmc = "mM031006 mM031029 mM031038 mM031064 mM031098 mM031135 mM031254 mM031276 mM031332 mM031351" order `Fmc' export delimited `Fmc' using data7Fmc.csv, delimiter(tab) novarnames replace local Fcr = "mM031030 mM031330" order `Fcr' export delimited `Fcr' using data7Fcr.csv, delimiter(tab) novarnames replace * L (9mc, 4 1) local Lmc = "mM041065A mM041068 mM041096 mM041125 mM041135 mM041151 mM041264 mM041268 mM041289" order `Lmc' export delimited `Lmc' using data7Lmc.csv, delimiter(tab) novarnames replace local Lcr = "mM041065B mM041182 mM041257 mM041291 mM041200" order `Lcr' export delimited `Lcr' using data7Lcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id7, replace restore clear use timss2007 keep if IDBOOK == 8 keep if mM041065A != . & mM031109 != . * L (9mc, 4 1) local Lmc = "mM041065A mM041068 mM041096 mM041125 mM041135 mM041151 mM041264 mM041268 mM041289" order `Lmc' export delimited `Lmc' using data8Lmc.csv, delimiter(tab) novarnames replace local Lcr = "mM041065B mM041182 mM041257 mM041291 mM041200" order `Lcr' export delimited `Lcr' using data8Lcr.csv, delimiter(tab) novarnames replace * I (6mc, 4 1) local Imc = "mM031109 mM031159 mM031187 mM031218 mM031251 mM031294" order `Imc' export delimited `Imc' using data8Imc.csv, delimiter(tab) novarnames replace local Icr = "mM031016 mM031128 mM031133 mM031297 mM031183" order `Icr' export delimited `Icr' using data8Icr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id8, replace restore clear use timss2007 keep if IDBOOK == 9 keep if mM031109 != . & mM041011 != . * I (6mc, 4 1) local Imc = "mM031109 mM031159 mM031187 mM031218 mM031251 mM031294" order `Imc' export delimited `Imc' using data9Imc.csv, delimiter(tab) novarnames replace local Icr = "mM031016 mM031128 mM031133 mM031297 mM031183" order `Icr' export delimited `Icr' using data9Icr.csv, delimiter(tab) novarnames replace * J (7mc, 5 2) local Jmc = "mM041011 mM041041 mM041107 mM041175 mM041199 mM041265 mM041320" order `Jmc' export delimited `Jmc' using data9Jmc.csv, delimiter(tab) novarnames replace local Jcr = "mM041115A mM041115B mM041160A mM041160B mM041327 mM041122 mM041148" order `Jcr' export delimited `Jcr' using data9Jcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id9, replace restore clear use timss2007 keep if IDBOOK == 10 keep if mM041011 != . & mM031004 != . * J (7mc, 5 2) local Jmc = "mM041011 mM041041 mM041107 mM041175 mM041199 mM041265 mM041320" order `Jmc' export delimited `Jmc' using data10Jmc.csv, delimiter(tab) novarnames replace local Jcr = "mM041115A mM041115B mM041160A mM041160B mM041327 mM041122 mM041148" order `Jcr' export delimited `Jcr' using data10Jcr.csv, delimiter(tab) novarnames replace * K (8mc, 5 0) local Kmc = "mM031004 mM031043 mM031088 mM031093 mM031155 mM031210 mM031252 mM031317" order `Kmc' export delimited `Kmc' using data10Kmc.csv, delimiter(tab) novarnames replace local Kcr = "mM031009 mM031079B mM031079C mM031316 mM031325" order `Kcr' export delimited `Kcr' using data10Kcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id10, replace restore clear use timss2007 keep if IDBOOK == 11 keep if mM031004 != . & mM041007 != . * K (8mc, 5 0) local Kmc = "mM031004 mM031043 mM031088 mM031093 mM031155 mM031210 mM031252 mM031317" order `Kmc' export delimited `Kmc' using data11Kmc.csv, delimiter(tab) novarnames replace local Kcr = "mM031009 mM031079B mM031079C mM031316 mM031325" order `Kcr' export delimited `Kcr' using data11Kcr.csv, delimiter(tab) novarnames replace * M (10mc, 4 0) local Mmc = "mM041007 mM041046 mM041048 mM041169 mM041177 mM041262 mM041271 mM041280 mM041298 mM041333" order `Mmc' export delimited `Mmc' using data11Mmc.csv, delimiter(tab) novarnames replace local Mcr = "mM041059 mM041267 mM041276A mM041276B" order `Mcr' export delimited `Mcr' using data11Mcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id11, replace restore clear use timss2007 keep if IDBOOK == 12 keep if mM041007 != . & mM031071 != . * M (10mc, 4 0) local Mmc = "mM041007 mM041046 mM041048 mM041169 mM041177 mM041262 mM041271 mM041280 mM041298 mM041333" order `Mmc' export delimited `Mmc' using data12Mmc.csv, delimiter(tab) novarnames replace local Mcr = "mM041059 mM041267 mM041276A mM041276B" order `Mcr' export delimited `Mcr' using data12Mcr.csv, delimiter(tab) novarnames replace * G (3mc, 5 1) local Gmc = "mM031071 mM031083 mM031185" order `Gmc' export delimited `Gmc' using data12Gmc.csv, delimiter(tab) novarnames replace local Gcr = "mM031313 mM031346A mM031346B mM031379 mM031380 mM031346C" order `Gcr' export delimited `Gcr' using data12Gcr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id12, replace restore clear use timss2007 keep if IDBOOK == 13 keep if mM041004 != . & mM031071 != . * G (3mc, 5 1) local Gmc = "mM031071 mM031083 mM031185" order `Gmc' export delimited `Gmc' using data13Gmc.csv, delimiter(tab) novarnames replace local Gcr = "mM031313 mM031346A mM031346B mM031379 mM031380 mM031346C" order `Gcr' export delimited `Gcr' using data13Gcr.csv, delimiter(tab) novarnames replace * N (8mc, 5 1) local Nmc = "mM041004 mM041023 mM041034 mM041132 mM041153 mM041191 mM041254 mM041302A" order `Nmc' export delimited `Nmc' using data13Nmc.csv, delimiter(tab) novarnames replace local Ncr = "mM041087 mM041124 mM041174 mM041302B mM041302C mM041165" order `Ncr' export delimited `Ncr' using data13Ncr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id13, replace restore clear use timss2007 keep if IDBOOK == 14 keep if mM041004 != . & mM031045 != . * N (8mc, 5 1) local Nmc = "mM041004 mM041023 mM041034 mM041132 mM041153 mM041191 mM041254 mM041302A" order `Nmc' export delimited `Nmc' using data14Nmc.csv, delimiter(tab) novarnames replace local Ncr = "mM041087 mM041124 mM041174 mM041302B mM041302C mM041165" order `Ncr' export delimited `Ncr' using data14Ncr.csv, delimiter(tab) novarnames replace * A (2mc, 8 1) local Amc = "mM031045 mM031335" order `Amc' export delimited `Amc' using data14Amc.csv, delimiter(tab) novarnames replace local Acr = "mM031068 mM031106 mM031134 mM031227 mM031271 mM031286 mM031299 mM031301 mM031282" order `Acr' export delimited `Acr' using data14Acr.csv, delimiter(tab) novarnames replace preserve keep IDSTUD save id14, replace restore clear exit * have a nice day