****************************
* File: primschool.do 
* Questionnaire type: School Head Teacher Questionnaire 2002
* Country: Uganda
*****************************

version 10.0
cd "Source/Uganda 2002 P E/Data/4.1. Data"
capture clear
capture log close
clear
set mem 700m
set more off
use "primschool.dta"

**************************************************
***  Ensure all variables are present and labeled
**************************************************

drop districtn region testscore testscorem testscoref stud7 stud7m stud7f shfundsch cons9500due

label variable	 	q1scode	 	"	1. Sample code	"
label variable	 	q5rururb	 	"	5. Rural or Urban	"
label variable	 	q6daybo	 	"	6. Day or boarding	"
label variable	 	q7boyg	 	"	7. Boys or girls	"
label variable	 	q8posit	 	"	8. RespondentŐs position	"
label variable	 	q11stud	 	"	11. Total number of students at the  beginning of 2001	"
label variable	 	q12p13	 	"	12. of which P1-P3	"
label variable	 	q13p47	 	"	13. of which P4-P7	"
label variable	 	q14p7	 	"	14. of which P7	"
label variable	 	q15girls	 	"	15. of which girls (P1-P7)	"
label variable	 	q16tot01	 	"	16. Total number of students at the end of  2001	"
label variable	 	q17p13	 	"	17. of which P1-P3	"
label variable	 	q18p47	 	"	18. of which P4-P7	"
label variable	 	q19p7	 	"	19. of which P7	"
label variable	 	q20girls	 	"	20. of which girls (P1-P7)	"
label variable	 	q21orph	 	"	21. Total number of orphans in P1-P7 in  2001	"
label variable	 	q22ple	 	"	22. Total number of students participating  in primary leaving exam 2001	"
label variable	 	q23pass	 	"	23. of which received Grade 1, 2 or 3	"
label variable	 	q24teac	 	"	24. Total number of teachers in 2001	"
label variable	 	q25qual	 	"	25. of which qualified teachers	"
label variable	 	q26class	 	"	26. Total number of classrooms	"
label variable	 	q27year	 	"	27. Year headteacher (HT) started at the  school	"
label variable	 	q28year	 	"	28. Year deputy HT started at the school	"
label variable	 	q29dist	 	"	29. Distance to nearest place to buy a  newspaper	"
label variable	 	q30dist	 	"	30. Distance to nearest bank branch	"
label variable	 	q31dist	 	"	31. Distance to district headquarters	"
label variable	 	q32ptel	 	"	32. Access to personal telephone	"
label variable	 	q33stel	 	"	33. Access to telephone in school	"
label variable	 	q34tel	 	"	34. If yes, telephone number	"
label variable	 	q35srad	 	"	35. Access to radio in school	"
label variable	 	q36prad	 	"	36. Personal access to radio	"
label variable	 	q37spap	 	"	37. Access to newspaper in school	"
label variable	 	q38ppap	 	"	38. Personal access to newspaper	"
label variable	 	q39nvis	 	"	39. Access to The New Vision	"
label variable	 	q40mon	 	"	40 Access to The Monitor	"
label variable	 	q41aoth	 	"	41. a. Access to other (specify)	"

label variable	 	q42days	 	"	42. Days per week read The New Vision	"
label variable	 	q43days	 	"	43. Days per week read The Monitor	"
label variable	 	q44days	 	"	44. Days per week read other	"
label variable	 	q45hour	 	"	45. Hours per week listen to the radio	"
label variable	 	q46are	 	"	46. Are there any other primary schools  that students in your school could  attend instead?	"

label variable	 	q47balt	 	"	b. First alternative school owned by	"
label variable	 	q47ctim	 	"	c. Time to walk from this school to  first alternative school	"

label variable	 	q48balt	 	"	b. Second alternative school owned by	"
label variable	 	q48ctim	 	"	c. Time to walk from this school to  second alternative school	"

label variable	 	q49balt	 	"	b. Third alternative school owned by	"
label variable	 	q49ctim	 	"	c. Time to walk from this school to  third alternative school	"
label variable	 	q50smc	 	"	50. School Management Committee  (SMC)	"
label variable	 	q51pta	 	"	51. Parent Teacher Association (PTA)	"
label variable	 	q52alo	 	"	a. Local council (LC)	"
label variable	 	q52bdeo	 	"	b. DEOŐs office	"
label variable	 	q52cpar	 	"	c. Parents	"

label variable	 	q52dpta	 	"	d. PTA	"
label variable	 	q52eht	 	"	e Headteacher	"
label variable	 	q52ftea	 	"	f. Teachers	"
label variable	 	q52goth	 	"	g. Other (specify)	"

label variable	 	q53apar	 	"	a. Parents	"
label variable	 	q53bht	 	"	b. Headteacher	"
label variable	 	q53ctea	 	"	c. Teachers	"
label variable	 	q53doth	 	"	d. Other (specify)	"
label variable	 	q54smc	 	"	54. Number of SMC meetings in 2001	"
label variable	 	q55pta	 	"	55. Number of PTA meetings in 2001	"

label variable	 	q56abuht	 	"	Budget approved by	"
label variable	 	q56abusm	 	"	Budget approved by	"
label variable	 	q56abupt	 	"	Budget approved by	"
label variable	 	q56abuot	 	"	Budget approved by	"
label variable	 	q56bchht	 	"	b. Cheques signed by	"
label variable	 	q56bchsm	 	"	b. Cheques signed by	"
label variable	 	q56bchpt	 	"	b. Cheques signed by	"
label variable	 	q56bcho	 	"	b. Cheques signed by	"
label variable	 	q57upe	 	"	57. School entitled to UPE capitation grant  in 2001	"
label variable	 	q58p13	 	"	q58p13	"
label variable	 	q58p47	 	"	q58p47	"
label variable	 	q59anp	 	"	59. a. Where did you get the information  on the UPE entitlement from	"
label variable	 	q59arad	 	"	59. a. Where did you get the information  on the UPE entitlement from	"
label variable	 	q59adeo	 	"	59. a. Where did you get the information  on the UPE entitlement from	"
label variable	 	q59aoth	 	"	59. a. Where did you get the information  on the UPE entitlement from	"
label variable	 	q60times	 	"	60. Do you know how often you are  supposed to receive UPE grants per  year	"
label variable	 	q61acce	 	"	61. Access to written guidelines on UPE  funding	"
label variable	 	q62year	 	"	62. If yes, when did you receive latest  guidelines on UPE funding	"
label variable	 	q63know	 	"	63. Do you know when the district  receives funds for UPE from the  Ministry of Finance	"
label variable	 	q64anp	 	"	64. a. If yes, where did you get this  information	"
label variable	 	q64arad	 	"	64. a. If yes, where did you get this  information	"
label variable	 	q64adeo	 	"	64. a. If yes, where did you get this  information	"
label variable	 	q64aoth	 	"	64. a. If yes, where did you get this  information	"

label variable	 	q66upe	 	"	66. In 2001, did you receive all	"
label variable	 	q67aper	 	"	how much received as share of total  entitlement	"
label variable	 	q67bcomp	 	"	did you complain or protest in order to  increase funding?	"
label variable	 	q67cdeo	 	"	c. if yes, to whom did you  complain?	"
label variable	 	q67ccao	 	"	c. if yes, to whom did you  complain?	"
label variable	 	q67clc	 	"	c. if yes, to whom did you  complain?	"
label variable	 	q67coth	 	"	c. if yes, to whom did you  complain?	"
label variable	 	q68amat	 	"	a. Scholastic materials	"
label variable	 	q68bmgt	 	"	b. School Management	"
label variable	 	q69adm	 	"	How much are you entitled to spend on  administration	"
label variable	 	q70upe	 	"	70. Did you submit UPE expenditure reports in 2001	"
label variable	 	q71rpts	 	"	71. If yes, how many reports  submitted in 2001	"
label variable	 	q73awhy	 	"	73 a. If no, why did you not submit UPE- reports in 2001	"
label variable	 	q74aval	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q74bcom	 	"	b. Compliance with guidelines	"
label variable	 	q74cfin	 	"	c. Financial accountability	"
label variable	 	q75adeo	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75acao	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75adis	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75asco	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75alc	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75amoe	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75aoth	 	"	a. Value for Money (if the money was  properly spent)	"
label variable	 	q75bdeo	 	"	b. Compliance with guidelines	"
label variable	 	q75bcao	 	"	b. Compliance with guidelines	"
label variable	 	q75bdis	 	"	b. Compliance with guidelines	"
label variable	 	q75bsco	 	"	b. Compliance with guidelines	"
label variable	 	q75blc	 	"	b. Compliance with guidelines	"
label variable	 	q75bmoe	 	"	b. Compliance with guidelines	"
label variable	 	q75both	 	"	b. Compliance with guidelines	"
label variable	 	q75cdeo	 	"	c. Financial accountability	"
label variable	 	q75ccao	 	"	c. Financial accountability	"
label variable	 	q75cdis	 	"	c. Financial accountability	"
label variable	 	q75csco	 	"	c. Financial accountability	"
label variable	 	q75clc	 	"	c. Financial accountability	"
label variable	 	q75cmoe	 	"	c. Financial accountability	"
label variable	 	q75coth	 	"	c. Financial accountability	"
label variable	 	q76aatt	 	"	a. daily attendance	"
label variable	 	q76bsal	 	"	b. total teachersŐ salaries  received from district	"
label variable	 	q76cupe	 	"	c. UPE capitation grant  received	"
label variable	 	q76dbud	 	"	d. school budget and  expenditures	"
label variable	 	q76epta	 	"	additional charges (PTA fees,  government fees)	"
label variable	 	q76fcopy	 	"	copy of school quarterly report to DEO	"
label variable	 	q77aatt1	 	"	a. daily attendance	"
label variable	 	q77aatt2	 	"	a. daily attendance	"
label variable	 	q77aatt3	 	"	a. daily attendance	"
label variable	 	q77aatt4	 	"	a. daily attendance	"
label variable	 	q77btea1	 	"	b. total teachersŐ salaries  received from district	"
label variable	 	q77btea2	 	"	b. total teachersŐ salaries  received from district	"
label variable	 	q77btea3	 	"	b. total teachersŐ salaries  received from district	"
label variable	 	q77btea4	 	"	b. total teachersŐ salaries  received from district	"
label variable	 	q77cupe1	 	"	c. UPE capitation grant  received	"
label variable	 	q77cupe2	 	"	c. UPE capitation grant  received	"
label variable	 	q77cupe3	 	"	c. UPE capitation grant  received	"
label variable	 	q77cupe4	 	"	c. UPE capitation grant  received	"
label variable	 	q77dbud1	 	"	d. school budget and  expenditures	"
label variable	 	q77dbud2	 	"	d. school budget and  expenditures	"
label variable	 	q77dbud3	 	"	d. school budget and  expenditures	"
label variable	 	q77dbud4	 	"	d. school budget and  expenditures	"
label variable	 	q77epta1	 	"	additional charges (PTA fees,  government fees)	"
label variable	 	q77epta2	 	"	additional charges (PTA fees,  government fees)	"
label variable	 	q77epta3	 	"	additional charges (PTA fees,  government fees)	"
label variable	 	q77epta4	 	"	additional charges (PTA fees,  government fees)	"
label variable	 	q77fcop1	 	"	f. copy of school quarterly report to  DEO	"
label variable	 	q77fcop2	 	"	f. copy of school quarterly report to  DEO	"
label variable	 	q77fcop3	 	"	f. copy of school quarterly report to  DEO	"
label variable	 	q77fcop4	 	"	f. copy of school quarterly report to  DEO	"
label variable	 	q78recor	 	"	78. Do you keep records on funding and  expenditures	"
label variable	 	q79acco	 	"	79. School has a bank account	"
label variable	 	q80prbud	 	"	80. Prepared budget for income and  expenditures in 2001	"
label variable	 	q81adon	 	"	a. donors	"
label variable	 	q81bngo	 	"	b. NGOs	"
label variable	 	q81coth	 	"	c. other benefactors	"

label variable	 	q82agov	 	"	a. government	"
label variable	 	q82bdon	 	"	b. donors	"
label variable	 	q82cngo	 	"	c. NGOs	"
label variable	 	q82doth	 	"	d. other benefactors	"

label variable	 	q84agra	 	"	a. Total UPE capitation grants	"
label variable	 	q84bsal	 	"	b. Total teachersŐ salaries (incl. HT)  from the government	"
label variable	 	q84cfee	 	"	c. Total government fees	"
label variable	 	q84dpta	 	"	d. Total PTA fees	"
label variable	 	q84eoth	 	"	e. Other (specify below)	"
label variable	 	q85agov	 	"	a. Government	"
label variable	 	q85bngo	 	"	b. NGO	"
label variable	 	q85cdon	 	"	c. Donors	"
label variable	 	q86funr	 	"	86. Fund raisers	"
label variable	 	q87ajan	 	"	a. January 2001	"
label variable	 	q87bfeb	 	"	b. February 2001	"
label variable	 	q87cmar	 	"	c. March 2001	"
label variable	 	q87dapr	 	"	d. April 2001	"
label variable	 	q87emay	 	"	e. May 2001	"
label variable	 	q87fjun	 	"	f. June 2001	"
label variable	 	q87gjul	 	"	g. July 2001	"
label variable	 	q87haug	 	"	h. August 2001	"
label variable	 	q87isep	 	"	i. September 2001	"
label variable	 	q87joct	 	"	j. October 2001	"
label variable	 	q87knov	 	"	k. November 2001	"
label variable	 	q87ldec	 	"	l. December 2001	"
label variable	 	q87mjan	 	"	m. January 2002	"
label variable	 	q87nfeb	 	"	n. February 2002	"
label variable	 	q87omar	 	"	o. March 2002	"
label variable	 	q88ajan	 	"	a. January 2001	"
label variable	 	q88bfeb	 	"	b. February 2001	"
label variable	 	q88cmar	 	"	c. March 2001	"
label variable	 	q88dapr	 	"	d. April 2001	"
label variable	 	q88emay	 	"	e. May 2001	"
label variable	 	q88fjun	 	"	f. June 2001	"
label variable	 	q88gjul	 	"	g. July 2001	"
label variable	 	q88haug	 	"	h. August 2001	"
label variable	 	q88isep	 	"	i. September 2001	"
label variable	 	q88joct	 	"	j. October 2001	"
label variable	 	q88knov	 	"	k. November 2001	"
label variable	 	q88ldec	 	"	l. December 2001	"
label variable	 	q88mjan	 	"	m. January 2002	"
label variable	 	q88nfeb	 	"	n. February 2002	"
label variable	 	q88omar	 	"	o. March 2002	"


label variable	 	q90adeo	 	"	a. District Education Officer	"
label variable	 	q90bcao	 	"	b. Chief Administrative Officer	"
label variable	 	q90clc5	 	"	c. LC 5 Chairman	"
label variable	 	q90dlc3	 	"	d. LC 3 Chairman	"
label variable	 	q90eeduc	 	"	e. Minister of Education	"
label variable	 	q90ffina	 	"	f. Minister of Finance	"
label variable	 	q90gpm	 	"	g. Prime Minister	"
label variable	 	q91awin	 	"	a. Winnie Byanyima	"
label variable	 	q91bthab	 	"	b. Thabo Mbeki	"
label variable	 	q91cbon	 	"	c. Bono	"
label variable	 	q91dbush	 	"	d. George W. Bush	"
label variable	 	q91echar	 	"	e. Charles Onyango-Obbo	"
label variable	 	q91fmp	 	"	f. Your representative in Parliament	"
label variable	 	q92coff	 	"	92. Coffee prices increased or fell during  2001	"
label variable	 	q93alarg	 	"	a. Largest newspaper in	"
label variable	 	q93bloc	 	"	b. Location of East African  Parliament	"
label variable	 	q93cmtn	 	"	c. MTN	"
label variable	 	q93dmon	 	"	d. Month when governmentŐs budget presented to  Parliament	"
label variable	 	q93edist	 	"	e. Number of districts in   Uganda	"
label variable	 	q93fmps	 	"	f. Number of members in  Parliament (i.e., MPs)	"

label variable	 	q94aeng	 	"	94. a. Price per unit of the English  textbooks	"
label variable	 	q94aengv	 	"	94. a. Value of the total amount of English  textbooks	"

label variable	 	q111how	 	"	111. How many times did you visit this  school in order to collect all necessary  information	"
label variable	 	q112astu	 	"	a. students	"
label variable	 	q112bupe	 	"	b. UPE grants	"
label variable	 	q113whe	 	"	113. Where you able to obtain information  on enrollment and UPE from the  school records	"
label variable	 	q114cond	 	"	114. Condition of school	"
label variable	 	q116aatt	 	"	a. daily attendance	"
label variable	 	q116bsal	 	"	b. total teachers salaries	"
label variable	 	q116cgra	 	"	c. UPE capitation grant received	"
label variable	 	q116dbud	 	"	d. school budget and expenditures	"
label variable	 	q116eadd	 	"	e. additional charges	"
label variable	 	q116fcop	 	"	f. copy of school report to DEO	"
label variable	 	q118per	 	"	118. Period for which information is posted	"

label variable 	q100aeng		"	q100aeng	"
label variable 	q100aengnr		"	q100aengnr	"
label variable 	q100aengv		"	q100aengv	"
label variable 	q100bsc		"	q100bsc	"
label variable 	q100bscnr		"	q100bscnr	"
label variable 	q100bscv		"	q100bscv	"
label variable 	q100css		"	q100css	"
label variable 	q100cssnr		"	q100cssnr	"
label variable 	q100cssv		"	q100cssv	"
label variable 	q100dmat		"	q100dmat	"
label variable 	q100dmatnr		"	q100dmatnr	"
label variable 	q100dmatv		"	q100dmatv	"
label variable 	q101apen		"	q101apen	"
label variable 	q101apennr		"	q101apennr	"
label variable 	q101apenv		"	q101apenv	"
label variable 	q101bch		"	q101bch	"
label variable 	q101bchnr		"	q101bchnr	"
label variable 	q101bchv		"	q101bchv	"
label variable 	q101cnb		"	q101cnb	"
label variable 	q101cnbknr		"	q101cnbknr	"
label variable 	q101cnbv		"	q101cnbv	"
label variable 	q101duni		"	q101duni	"
label variable 	q101duninr		"	q101duninr	"
label variable 	q101duniv		"	q101duniv	"
label variable 	q101eoth		"	q101eoth	"
label variable 	q101eothnr		"	q101eothnr	"
label variable 	q101eothv		"	q101eothv	"
label variable 	q102totva		"	q102totva	"
label variable 	q103aeng		"	q103aeng	"
label variable 	q103aengnr		"	q103aengnr	"
label variable 	q103aengv		"	q103aengv	"
label variable 	q103bsc		"	q103bsc	"
label variable 	q103bscnr		"	q103bscnr	"
label variable 	q103bscv		"	q103bscv	"
label variable 	q103css		"	q103css	"
label variable 	q103cssnr		"	q103cssnr	"
label variable 	q103cssv		"	q103cssv	"
label variable 	q103dmat		"	q103dmat	"
label variable 	q103dmatnr		"	q103dmatnr	"
label variable 	q103dmatv		"	q103dmatv	"
label variable 	q104apen		"	q104apen	"
label variable 	q104apennr		"	q104apennr	"
label variable 	q104apenv		"	q104apenv	"
label variable 	q104bch		"	q104bch	"
label variable 	q104bchnr		"	q104bchnr	"
label variable 	q104bchv		"	q104bchv	"
label variable 	q104cnb		"	q104cnb	"
label variable 	q104cnbknr		"	q104cnbknr	"
label variable 	q104cnbv		"	q104cnbv	"
label variable 	q104duni		"	q104duni	"
label variable 	q95apenv		"	q95apenv	"
label variable 	q95bch		"	q95bch	"
label variable 	q95bchnr		"	q95bchnr	"
label variable 	q95bchv		"	q95bchv	"
label variable 	q95cnb		"	q95cnb	"
label variable 	q95cnbk		"	q95cnbk	"
label variable 	q95cnbv		"	q95cnbv	"

label variable 	q94bscv		"	q94bscv	"
label variable 	q94css		"	q94css	"
label variable 	q94cssnr		"	q94cssnr	"
label variable 	q94cssv		"	q94cssv	"
label variable 	q94dmat		"	q94dmat	"
label variable 	q94dmatnr		"	q94dmatnr	"
label variable 	q94dmatv		"	q94dmatv	"
label variable 	q95apen		"	q95apen	"
label variable 	q95apennr		"	q95apennr	"
label variable 	q95apenv		"	q95apenv	"
label variable 	q95bch		"	q95bch	"
label variable 	q95bchnr		"	q95bchnr	"
label variable 	q95bchv		"	q95bchv	"
label variable 	q95cnb		"	q95cnb	"
label variable 	q95cnbk		"	q95cnbk	"
label variable 	q95cnbv		"	q95cnbv	"
	
label variable 	q95duni		"	q95duni	"
label variable 	q95duninr		"	q95duninr	"
label variable 	q95duniv		"	q95duniv	"
label variable 	q95eoth		"	q95eoth	"
label variable 	q95eothnr		"	q95eothnr	"
label variable 	q95eothv		"	q95eothv	"
label variable 	q96totva		"	q96totva	"
label variable 	q97aeng		"	q97aeng	"
label variable 	q97aengnr		"	q97aengnr	"
label variable 	q97aengv		"	q97aengv	"
label variable 	q97bsc		"	q97bsc	"
label variable 	q97bscnr		"	q97bscnr	"
label variable 	q97bscv		"	q97bscv	"
label variable 	q97css		"	q97css	"
label variable 	q97cssnr		"	q97cssnr	"
label variable 	q97cssv		"	q97cssv	"
label variable 	q97dmat		"	q97dmat	"
label variable 	q97dmatnr		"	q97dmatnr	"
label variable 	q97dmatv		"	q97dmatv	"
label variable 	q98apen		"	q98apen	"
label variable 	q98apennr		"	q98apennr	"
label variable 	q98apenv		"	q98apenv	"
label variable 	q98bch		"	q98bch	"
label variable 	q98bchnr		"	q98bchnr	"
label variable 	q98bchv		"	q98bchv	"
label variable 	q98cnb		"	q98cnb	"
label variable 	q98cnbknr		"	q98cnbknr	"
label variable 	q98cnbv		"	q98cnbv	"
label variable 	q98duni		"	q98duni	"
label variable 	q98duninr		"	q98duninr	"
label variable 	q98duniv		"	q98duniv	"
label variable 	q98eoth		"	q98eoth	"
label variable 	q98eothnr		"	q98eothnr	"
label variable 	q98eothv		"	q98eothv	"
label variable 	q99totva  		"	q99totva  	"

label variable 	q104duninr		"	q104duninr	"
label variable 	q104duniv		"	q104duniv	"
label variable 	q104eoth		"	q104eoth	"
label variable 	q104eothnr		"	q104eothnr	"
label variable 	q104eothv		"	q104eothv	"
label variable 	q105totva		"	q105totva	"
label variable 	q1063bscnr		"	q1063bscnr	"
label variable 	q106aeng		"	q106aeng	"
label variable 	q106aengnr		"	q106aengnr	"
label variable 	q106aengv		"	q106aengv	"
label variable 	q106bsc		"	q106bsc	"
label variable 	q106bscv		"	q106bscv	"
label variable 	q106css		"	q106css	"
label variable 	q106cssnr		"	q106cssnr	"
label variable 	q106cssv		"	q106cssv	"
label variable 	q106dmat		"	q106dmat	"
label variable 	q106dmatnr		"	q106dmatnr	"
label variable 	q106dmatv		"	q106dmatv	"
label variable 	q107apen		"	q107apen	"
label variable 	q107apennr		"	q107apennr	"
label variable 	q107apenv		"	q107apenv	"
label variable 	q107bch		"	q107bch	"
label variable 	q107bchnr		"	q107bchnr	"
label variable 	q107bchv		"	q107bchv	"
label variable 	q107cnb		"	q107cnb	"
label variable 	q107cnbknr		"	q107cnbknr	"
label variable 	q107cnbv		"	q107cnbv	"
label variable 	q107duni		"	q107duni	"
label variable 	q107duninr		"	q107duninr	"
label variable 	q107duniv		"	q107duniv	"
label variable 	q107eoth		"	q107eoth	"
label variable 	q107eothnr		"	q107eothnr	"
label variable 	q107eothv		"	q107eothv	"
label variable 	q108totva		"	q108totva	"
**************************************************
***  Add value labels
**************************************************
label define rurur 1 "rural"
label define rurur 2 "urban", add
label define dayboa 1 "day"
label define dayboa 2 "boarding", add
label define dayboa 3 "mixed", add
label define boygirl 1 "boys"
label define boygirl 2 "girls", add
label define boygirl 3 "mixed", add
label define position 1 "headteacher"
label define position 2 "deputy headteacher", add
label define yesno 1 "yes"
label define yesno 2 "no", add
label define ownedby 1 "government"
label define ownedby 2 "private", add
label define ownedby 3 "community", add
label define whynotsub 1 "did not know about them"
label define whynotsub 2 "not required to submit", add
label define whynotsub 3 "no UPE grants received", add
label define whynotsub 4 "records missing", add
label define whynotsub 5 "other", add
label define accurate 1 "yes"
label define accurate 2 "reported numbers overstated", add
label define accurate 3 "reported numbers understated", add
label define cond 1 "clean, good state of repair"
label define cond 2 "dirty, poor state of repair", add

label values  q5rururb rurur
label values  q6daybo dayboa
label values  q7boyg boygirl
label values  q8posit position
label values 	q70upe	 	yesno
label values 	 q36prad		yesno
label values 	q37spap		yesno
label values 	 q38ppap		yesno
label values 	 q39nvis		yesno
label values 	 q40mon		yesno
label values 	q41aoth		yesno
label values 	 q46are		yesno
label values 	  q50smc		yesno
label values 	q51pta		yesno
label values 	 q52alo		yesno
label values 	q52bdeo		yesno
label values 	q52cpar		yesno
label values 	q52dpta		yesno
label values 	 q52eht		yesno
label values 	q52ftea  		yesno
label values 	q57upe		yesno
label values 	q61acce		yesno
label values 	q63know  		yesno
label values 	q78recor		yesno
label values 	q79acco  		yesno
label values 	q87ajan		yesno
label values 	q87bfeb		yesno
label values 	q87cmar		yesno
label values 	q87dapr		yesno
label values 	 q87emay		yesno
label values 	q87fjun		yesno
label values 	q87gjul		yesno
label values 	 q87haug		yesno
label values 	q87isep		yesno
label values 	q87joct		yesno
label values 	q87knov		yesno
label values 	q87ldec		yesno
label values 	q87mjan		yesno
label values 	q87nfeb		yesno
label values 	q87omar		yesno
label values 	 q80prbud		yesno
label values 	 q81adon		yesno
label values 	 q81bngo		yesno
label values 	 q81coth		yesno
label values 	q82agov		yesno
label values 	 q82bdon		yesno
label values 	q82cngo		yesno
label values 	q82doth		yesno
label values 	q83yfund		yesno
label values 	q52goth		yesno
label values 	 q53apar		yesno
label values 	q53bht		yesno
label values 	 q53ctea		yesno
label values 	q53doth		yesno

label values  q73awhy whynotsub
label values q112astu accurate
label values q112bupe accurate
label values  q114cond cond


**************************************************
*** Recode missing values
***************************************************

*    DECODE MISSING VALUES
# d ;
qui mvdecode _all, mv(
999999999=.l\99999999=.l\9999999=.l\999999=.l\99999=.l\9999=.l\999=.l\
888888888=.d\88888888=.d\8888888=.d\888888=.d\88888=.d\8888=.d\888=.d\
777777777=.n\77777777=.n\7777777=.n\777777=.n\77777=.n\7777=.n\777=.n\
666666666=.r\66666666=.r\6666666=.r\666666=.r\66666=.r\6666=.r\666=.r\);

qui mvdecode _all, mv(
99999.9=.l\9999.9=.l\999.9=.l\99.9=.l\
88888.8=.d\8888.8=.d\888.8=.d\88.8=.d \
77777.7=.n\7777.7=.n\777.7=.n\77.7=.n \
66666.6=.r\6666.6=.r\666.6=.r\66.6=.r);

qui mvdecode  q100aeng	q100aengnr	q100aengv	q100bsc	q100bscnr	q100bscv	q100css	q100cssnr	q100cssv	q100dmat	q100dmatnr	q100dmatv	q101apen	q101apennr	q101apenv	q101bch	q101bchnr	q101bchv	q101cnb	q101cnbknr	q101cnbv	q101duni	q101duninr	q101duniv	q101eoth	q101eothnr	q101eothv	q102totva	q103aeng	q103aengnr	q103aengv	q103bsc	q103bscnr	q103bscv	q103css	q103cssnr	q103cssv	q103dmat	q103dmatnr	q103dmatv	q104apen	q104apennr	q104apenv	q104bch	q104bchnr	q104bchv	q104cnb	q104cnbknr	q104cnbv	q104duni	q104duninr	q104duniv	q104eoth	q104eothnr	q104eothv	q105totva	q1063bscnr	q106aeng	q106aengnr	q106aengv	q106bsc	q106bscv	q106css	q106cssnr	q106cssv	q106dmat	q106dmatnr	q106dmatv	q107apen	q107apennr	q107apenv	q107bch	q107bchnr	q107bchv	q107cnb	q107cnbknr	q107cnbv	q107duni	q107duninr	q107duniv	q107eoth	q107eothnr	q107eothv	q108totva	q111how	q112astu	q112bupe	q113whe	q114cond	q116aatt	q116bsal	q116cgra	q116dbud	q116eadd	q116fcop	q118per	q32ptel	q33stel	q35srad	q36prad	q37spap	q38ppap	q39nvis	q40mon	q41aoth	q46are	q48balt	q48ctim	q50smc	q51pta	q52alo	q52bdeo	q52cpar	q52dpta	q52eht	q52ftea	q52goth	q53apar	q53bht	q53ctea	q53doth	q56abuht	q56abuot	q56abupt	q56abusm	q56bchht	q56bcho	q56bchpt	q56bchsm	q57upe	q59adeo	q59anp	q59aoth	q59arad	q5rururb	q61acce	q63know	q64adeo	q64anp	q64aoth	q64arad	q66upe	q67aper	q67bcomp	q67ccao	q67cdeo	q67clc	q67coth	q70upe	q73awhy	q74aval	q74bcom	q74cfin	q75acao	q75adeo	q75adis	q75alc	q75amoe	q75aoth	q75asco	q75bcao	q75bdeo	q75bdis	q75blc	q75bmoe	q75both	q75bsco	q75ccao	q75cdeo	q75cdis	q75clc	q75cmoe	q75coth	q75csco	q76aatt	q76bsal	q76cupe	q76dbud	q76epta	q76fcopy	q77aatt1	q77aatt2	q77aatt3	q77aatt4	q77btea1	q77btea2	q77btea3	q77btea4	q77cupe1	q77cupe2	q77cupe3	q77cupe4	q77dbud1	q77dbud2	q77dbud3	q77dbud4	q77epta1	q77epta2	q77epta3	q77epta4	q77fcop1	q77fcop2	q77fcop3	q77fcop4	q78recor	q79acco	q7boyg	q80prbud	q81adon	q81bngo	q81coth	q82agov	q82bdon	q82cngo	q82doth	q83yfund	q87ajan	q87bfeb	q87cmar	q87dapr	q87emay	q87fjun	q87gjul	q87haug	q87isep	q87joct	q87knov	q87ldec	q87mjan	q87nfeb	q87omar, mv(
9=.l\
8=.d \
7=.n \
6=.r);


# d cr;

**************************************************
***  Identify skip patterns
**************************************************

* Recode missing values to Stata missing values, for tests and data inspection.
quietly mvdecode _all,mv (-666 = .d \ -777 = .n \ -888 = .l \ -999 = .r) 

**************************************************
***  Identify outliers
**************************************************

mvdecode q100aeng	q100aengnr	q100aengv	q100bsc	q100bscnr	q100bscv	q100css	q100cssnr	q100cssv	q100dmat	q100dmatnr	q100dmatv	q101apen	q101apennr	q101apenv	q101bch	q101bchnr	q101bchv	q101cnb	q101cnbknr	q101cnbv	q101duni	q101duninr	q101duniv	q101eoth	q101eothnr	q101eothv	q102totva	q103aeng	q103aengnr	q103aengv	q103bsc	q103bscnr	q103bscv	q103css	q103cssnr	q103cssv	q103dmat	q103dmatnr	q103dmatv	q104apen	q104apennr	q104apenv	q104bch	q104bchnr	q104bchv	q104cnb	q104cnbknr	q104cnbv	q104duni	q104duninr	q104duniv	q104eoth	q104eothnr	q104eothv	q105totva	q1063bscnr	q106aeng	q106aengnr	q106aengv	q106bsc	q106bscv	q106css	q106cssnr	q106cssv	q106dmat	q106dmatnr	q106dmatv	q107apen	q107apennr	q107apenv	q107bch	q107bchnr	q107bchv	q107cnb	q107cnbknr	q107cnbv	q107duni	q107duninr	q107duniv	q107eoth	q107eothnr	q107eothv	q108totva	q111how	q112astu	q112bupe	q113whe	q114cond	q116aatt	q116bsal	q116cgra	q116dbud	q116eadd	q116fcop	q118per	q32ptel	q33stel	q35srad	q36prad	q37spap	q38ppap	q39nvis	q40mon	q41aoth	q46are	q48balt	q48ctim	q50smc	q51pta	q52alo	q52bdeo	q52cpar	q52dpta	q52eht	q52ftea	q52goth	q53apar	q53bht	q53ctea	q53doth	q56abuht	q56abuot	q56abupt	q56abusm	q56bchht	q56bcho	q56bchpt	q56bchsm	q57upe	q59adeo	q59anp	q59aoth	q59arad	q5rururb	q61acce	q63know	q64adeo	q64anp	q64aoth	q64arad	q66upe	q67aper	q67bcomp	q67ccao	q67cdeo	q67clc	q67coth	q70upe	q73awhy	q74aval	q74bcom	q74cfin	q75acao	q75adeo	q75adis	q75alc	q75amoe	q75aoth	q75asco	q75bcao	q75bdeo	q75bdis	q75blc	q75bmoe	q75both	q75bsco	q75ccao	q75cdeo	q75cdis	q75clc	q75cmoe	q75coth	q75csco	q76aatt	q76bsal	q76cupe	q76dbud	q76epta	q76fcopy	q77aatt1	q77aatt2	q77aatt3	q77aatt4	q77btea1	q77btea2	q77btea3	q77btea4	q77cupe1	q77cupe2	q77cupe3	q77cupe4	q77dbud1	q77dbud2	q77dbud3	q77dbud4	q77epta1	q77epta2	q77epta3	q77epta4	q77fcop1	q77fcop2	q77fcop3	q77fcop4	q78recor	q79acco	q7boyg	q80prbud	q81adon	q81bngo	q81coth	q82agov	q82bdon	q82cngo	q82doth	q83yfund	q87ajan	q87bfeb	q87cmar	q87dapr	q87emay	q87fjun	q87gjul	q87haug	q87isep	q87joct	q87knov	q87ldec	q87mjan	q87nfeb	q87omar , mv(0 = .z)
grubbs q100aeng	q100aengnr	q100aengv	q100bsc	q100bscnr	q100bscv	q100css	q100cssnr	q100cssv	q100dmat	q100dmatnr	q100dmatv	q101apen	q101apennr	q101apenv	q101bch	q101bchnr	q101bchv	q101cnb	q101cnbknr	q101cnbv	q101duni	q101duninr	q101duniv	q101eoth	q101eothnr	q101eothv	q102totva	q103aeng	q103aengnr	q103aengv	q103bsc	q103bscnr	q103bscv	q103css	q103cssnr	q103cssv	q103dmat	q103dmatnr	q103dmatv	q104apen	q104apennr	q104apenv	q104bch	q104bchnr	q104bchv	q104cnb	q104cnbknr	q104cnbv	q104duni	q104duninr	q104duniv	q104eoth	q104eothnr	q104eothv	q105totva	q1063bscnr	q106aeng	q106aengnr	q106aengv	q106bsc	q106bscv	q106css	q106cssnr	q106cssv	q106dmat	q106dmatnr	q106dmatv	q107apen	q107apennr	q107apenv	q107bch	q107bchnr	q107bchv	q107cnb	q107cnbknr	q107cnbv	q107duni	q107duninr	q107duniv	q107eoth	q107eothnr	q107eothv	q108totva	q111how	q112astu	q112bupe	q113whe	q114cond	q116aatt	q116bsal	q116cgra	q116dbud	q116eadd	q116fcop	q118per	q32ptel	q33stel	q35srad	q36prad	q37spap	q38ppap	q39nvis	q40mon	q41aoth	q46are	q48balt	q48ctim	q50smc	q51pta	q52alo	q52bdeo	q52cpar	q52dpta	q52eht	q52ftea	q52goth	q53apar	q53bht	q53ctea	q53doth	q56abuht	q56abuot	q56abupt	q56abusm	q56bchht	q56bcho	q56bchpt	q56bchsm	q57upe	q59adeo	q59anp	q59aoth	q59arad	q5rururb	q61acce	q63know	q64adeo	q64anp	q64aoth	q64arad	q66upe	q67aper	q67bcomp	q67ccao	q67cdeo	q67clc	q67coth	q70upe	q73awhy	q74aval	q74bcom	q74cfin	q75acao	q75adeo	q75adis	q75alc	q75amoe	q75aoth	q75asco	q75bcao	q75bdeo	q75bdis	q75blc	q75bmoe	q75both	q75bsco	q75ccao	q75cdeo	q75cdis	q75clc	q75cmoe	q75coth	q75csco	q76aatt	q76bsal	q76cupe	q76dbud	q76epta	q76fcopy	q77aatt1	q77aatt2	q77aatt3	q77aatt4	q77btea1	q77btea2	q77btea3	q77btea4	q77cupe1	q77cupe2	q77cupe3	q77cupe4	q77dbud1	q77dbud2	q77dbud3	q77dbud4	q77epta1	q77epta2	q77epta3	q77epta4	q77fcop1	q77fcop2	q77fcop3	q77fcop4	q78recor	q79acco	q7boyg	q80prbud	q81adon	q81bngo	q81coth	q82agov	q82bdon	q82cngo	q82doth	q83yfund	q87ajan	q87bfeb	q87cmar	q87dapr	q87emay	q87fjun	q87gjul	q87haug	q87isep	q87joct	q87knov	q87ldec	q87mjan	q87nfeb	q87omar , level(99.99)
mvencode q100aeng	q100aengnr	q100aengv	q100bsc	q100bscnr	q100bscv	q100css	q100cssnr	q100cssv	q100dmat	q100dmatnr	q100dmatv	q101apen	q101apennr	q101apenv	q101bch	q101bchnr	q101bchv	q101cnb	q101cnbknr	q101cnbv	q101duni	q101duninr	q101duniv	q101eoth	q101eothnr	q101eothv	q102totva	q103aeng	q103aengnr	q103aengv	q103bsc	q103bscnr	q103bscv	q103css	q103cssnr	q103cssv	q103dmat	q103dmatnr	q103dmatv	q104apen	q104apennr	q104apenv	q104bch	q104bchnr	q104bchv	q104cnb	q104cnbknr	q104cnbv	q104duni	q104duninr	q104duniv	q104eoth	q104eothnr	q104eothv	q105totva	q1063bscnr	q106aeng	q106aengnr	q106aengv	q106bsc	q106bscv	q106css	q106cssnr	q106cssv	q106dmat	q106dmatnr	q106dmatv	q107apen	q107apennr	q107apenv	q107bch	q107bchnr	q107bchv	q107cnb	q107cnbknr	q107cnbv	q107duni	q107duninr	q107duniv	q107eoth	q107eothnr	q107eothv	q108totva	q111how	q112astu	q112bupe	q113whe	q114cond	q116aatt	q116bsal	q116cgra	q116dbud	q116eadd	q116fcop	q118per	q32ptel	q33stel	q35srad	q36prad	q37spap	q38ppap	q39nvis	q40mon	q41aoth	q46are	q48balt	q48ctim	q50smc	q51pta	q52alo	q52bdeo	q52cpar	q52dpta	q52eht	q52ftea	q52goth	q53apar	q53bht	q53ctea	q53doth	q56abuht	q56abuot	q56abupt	q56abusm	q56bchht	q56bcho	q56bchpt	q56bchsm	q57upe	q59adeo	q59anp	q59aoth	q59arad	q5rururb	q61acce	q63know	q64adeo	q64anp	q64aoth	q64arad	q66upe	q67aper	q67bcomp	q67ccao	q67cdeo	q67clc	q67coth	q70upe	q73awhy	q74aval	q74bcom	q74cfin	q75acao	q75adeo	q75adis	q75alc	q75amoe	q75aoth	q75asco	q75bcao	q75bdeo	q75bdis	q75blc	q75bmoe	q75both	q75bsco	q75ccao	q75cdeo	q75cdis	q75clc	q75cmoe	q75coth	q75csco	q76aatt	q76bsal	q76cupe	q76dbud	q76epta	q76fcopy	q77aatt1	q77aatt2	q77aatt3	q77aatt4	q77btea1	q77btea2	q77btea3	q77btea4	q77cupe1	q77cupe2	q77cupe3	q77cupe4	q77dbud1	q77dbud2	q77dbud3	q77dbud4	q77epta1	q77epta2	q77epta3	q77epta4	q77fcop1	q77fcop2	q77fcop3	q77fcop4	q78recor	q79acco	q7boyg	q80prbud	q81adon	q81bngo	q81coth	q82agov	q82bdon	q82cngo	q82doth	q83yfund	q87ajan	q87bfeb	q87cmar	q87dapr	q87emay	q87fjun	q87gjul	q87haug	q87isep	q87joct	q87knov	q87ldec	q87mjan	q87nfeb	q87omar, mv(.z = 0)

**************************************************
*** Identify errors to be reviewed
**************************************************
cd "Source/Uganda 2002 P E/Data/4.3. Clean Data/4.3.3. Data Code Book"

log using "primschool codebook errors ", replace
codebook grubbs_*, compact
log close
drop grubbs* 

* Encode missing STATA values back to missing value codes, in case data users want to convert file to other statistical software.
quietly mvencode _all,mv (.d = -666 \ .n = -777 \ .l = -888 \ .r = -999)