**************************** * File: LGA.do * Questionnaire type: Local Government Area Treasurer * Country: Nigeria ***************************** ** Recode error values in existing variables to unique codes. label define EDUCATION -666 `"don't know"', modify label define BUDGET -666 `"don't know"', modify label define BUDGETNEED -666 `"don't know"', modify label define SUBMITTED -666 `"don't know"', modify label define NEWWELLS -666 `"don't know"', modify label define HANDPUMPS -666 `"don't know"', modify label define TOILETS -666 `"don't know"', modify label define PUBLICTOIL -666 `"don't know"', modify label define PUBLICSCH -666 `"don't know"', modify label define PRIVATESCH -666 `"don't know"', modify label define NEWPRIMARY -666 `"don't know"', modify label define REPAIRED -666 `"don't know"', modify label define NEWROADS -666 `"don't know"', modify label define UPGRADED -666 `"don't know"', modify label define BUDGET -999 `"missing"', modify label define BUDGETNEED -999 `"missing"', modify label define SUBMITTED -999 `"missing"', modify label define EDUCATION -999 `"missing"', modify label define NEWWELLS -999 `"missing"', modify label define HANDPUMPS -999 `"missing"', modify label define TOILETS -999 `"missing"', modify label define PUBLICTOIL -999 `"missing"', modify label define PUBLICSCH -999 `"missing"', modify label define PRIVATESCH -999 `"missing"', modify label define NEWPRIMARY -999 `"missing"', modify label define REPAIRED -999 `"missing"', modify label define NEWROADS -999 `"missing"', modify label define UPGRADED -999 `"missing"', modify label define BUDGET -777 `"not applicable"', modify label define BUDGETNEED -777 `"not applicable"', modify label define SUBMITTED -777 `"not applicable"', modify label define NEWWELLS -777 `"not applicable"', modify label define HANDPUMPS -777 `"not applicable"', modify label define TOILETS -777 `"not applicable"', modify label define PUBLICTOIL -777 `"not applicable"', modify label define PUBLICSCH -777 `"not applicable"', modify label define PRIVATESCH -777 `"not applicable"', modify label define NEWPRIMARY -777 `"not applicable"', modify label define REPAIRED -777 `"not applicable"', modify label define NEWROADS -777 `"not applicable"', modify label define UPGRADED -777 `"not applicable"', modify replace education = -666 if education == 6 replace budget = -666 if budget == 8 replace budgetneed = -666 if budgetneed == 8 replace submitted = -666 if submitted == 8 replace newwells = -666 if newwells == 88 replace handpumps = -666 if handpumps == 88 replace toilets = -666 if toilets == 88 replace publictoil = -666 if publictoil == 88 replace publicsch = -666 if publicsch == 888 replace privatesch = -666 if privatesch == 888 replace newprimary = -666 if newprimary == 888 replace repaired = -666 if repaired == 888 replace newroads = -666 if newroads == 888 replace upgraded = -666 if upgraded == 888 replace budget = -999 if budget == 9 replace budgetneed = -999 if budgetneed == 9 replace submitted = -999 if submitted == 9 replace education = -999 if education == 9 replace newwells = -999 if newwells == 99 replace handpumps = -999 if handpumps == 99 replace toilets = -999 if toilets == 99 replace publictoil = -999 if publictoil == 99 replace publicsch = -999 if publicsch == 999 replace privatesch = -999 if privatesch == 999 replace newprimary = -999 if newprimary == 999 replace repaired = -999 if repaired == 999 replace newroads = -999 if newroads == 999 replace upgraded = -999 if upgraded == 999 replace budget = -777 if budget == 7 replace budgetneed = -777 if budgetneed == 7 replace submitted = -777 if submitted == 7 replace newwells = -777 if newwells == 77 replace handpumps = -777 if handpumps == 77 replace toilets = -777 if toilets == 77 replace publictoil = -777 if publictoil == 77 replace publicsch = -777 if publicsch == 777 replace privatesch = -777 if privatesch == 777 replace newprimary = -777 if newprimary == 777 replace repaired = -777 if repaired == 777 replace newroads = -777 if newroads == 777 replace upgraded = -777 if upgraded == 777 ** Add labels to variables label variable ID "Respondent Identifier" label variable questnum "Questionnaire Number" label variable statecode "State" label variable lgacode "Local Government Area Code" label variable address "Address" label variable intname "Interviewer’s Name " label variable firstintda "Month of First Interview" label variable firststime "Start Time of First Interview" label variable firstetime "End Time of First Interview" label variable firstintl "Language of First Interview" label variable firstincom "Survey Completed of First Interview" label variable secintdate "Month of Second Interview" label variable secstime "Start Time of Second Interview" label variable secetime "End Time of Second Interview" label variable secintl "Language of Second Interview" label variable secincom "Survey Completed of Second Interview" label variable supname "Supervisor’s Name" label variable surcomdate "Month of Survey Completion" label variable surinitial "Survey Complete Initials" label variable dataentdat "Month of Data Entry Completion" label variable datainitia "Data Entry Complete Initials" label variable entname "Data Entry Technician’s Name" label variable firentdate "Month of First Entry" label variable firseccomp "Sections Completed of First Entry" label variable secentdate "Month of Second Entry" label variable secseccomp "Sections Completed of Second Entry" label variable notes "Questionnaire Notes 1" label variable notes1 "Questionnaire Notes 2" label variable lgacreated "LGA Created Less Than 5 Years Ago" label variable electward "Number of Electoral Wards in This LGA" label variable lgaclass "Classification of LGA" label variable distance "Distance Between LGA Secretariat and State Capital" label variable travel "Travel Time to the LGA by Car" label variable publicsch "Number of Public Primary Schools in LGA" label variable privatesch "Number of Private Primary Schools in LGA" label variable newprimary "Number of New Primary Schools in LGA since January 2000" label variable repaired "Number of Primary Schools Repaired in LGA since January 2000" label variable newroads "Distance of New Roads Built by LGA since January 2000" label variable upgraded "Distance of Roads Upgraded by LGA since January 2000" label variable newwells "Number of New Wells Built for Drinking by LGA since January 2000" label variable handpumps "Number of Hand Pumps Repaired by LGA since January 2000" label variable toilets "Number of New Public Toilets in LGA since January 2000" label variable publictoil "Number of Public Toilets Repaired in LGA since January 2000" label variable budget "This LGA prepare its own budget" label variable budgetneed "The LGA Budget Needs to be Submitted to the State Government for Approval" label variable submitted "The 2001 LGA Budget Was Submitted to the State Government for Approval " label variable totrev99 "Total Revenues of LGA for the Year 1999" label variable totrev00 "Total Revenues of LGA for the Year 2000" label variable fedacct99 "Amount of Statutory Allocation from Federation Account Year 1999" label variable fedacct00 "Amount of Statutory Allocation from Federation Account Year 2000" label variable stacct99 "Amount of Statutory Allocation from State Government Year 1999" label variable stacct00 "Amount of Statutory Allocation from State Government Year 2000" label variable intrev99 "Amount of Internally Generated Revenues Year 1999" label variable intrev00 "Amount of Internally Generated Revenues Year 2000" label variable vatrev99 "Amount of VAT Year 1999" label variable vatrev00 "Amount of VAT Year 2000" label variable persexp99 "Health Personnel Expenditure in 1999" label variable persexp00 "Health Personnel Expenditure in 2000" label variable overexp99 "Health Overhead Expenditure in 1999" label variable overexp00 "Health Overhead Expenditure in 2000" label variable prevexp99 "Preventive Care Expenditure in 1999" label variable prevexp00 "Preventive Care Expenditure in 2000" label variable curcexp99 "Curative Care Expenditure in 1999" label variable curcexp00 "Curative Care Expenditure in 2000" label variable envsexp99 "Health Environmental Services Expenditure in 1999" label variable envsexp00 "Health Environmental Services Expenditure in 2000" label variable hcapexp99 "Health Capital Expenditure in 1999" label variable hcapexp00 "Health Capital Expenditure in 2000" label variable education "Highest Level of Education Completed by the Chairman of this LGA" * Recode missing values to Stata missing values, for tests and data inspection. quietly mvdecode _all,mv (-666 = .d \ -777 = .n \ -888 = .l \ -999 = .r) * Data edits * NO DATA EDITS * Implement Questionnaire Consistency Tests. Each of these tests resolves to 1 if there is an error. * THERE ARE NO INTERNAL COHERENCE TESTS FOR LGA *Outlier detection mvdecode distance publicsch privatesch newprimary repaired newroads upgraded newwells handpumps toilets publictoil totrev99-hcapexp00, mv(0=.z) grubbs distance publicsch privatesch newprimary repaired newroads upgraded newwells handpumps toilets publictoil totrev99-hcapexp00, level(99.99) mvencode distance publicsch privatesch newprimary repaired newroads upgraded newwells handpumps toilets publictoil totrev99-hcapexp00, mv(.z=0) 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) * Ensure all values that should be labelled are indeed labelled. inspect