**************************** * File: indoschoolsurvey.do * Questionnaire type: School Survey 2003 * Country: Indonesia ***************************** version 10.0 cd "Source/Indonesia 2003 A/Data/4.1. Data" capture clear capture log close clear set mem 700m set more off use "indoschoolsurvey.dta" ************************************************** *** Ensure unique id *************************************************** gen uid = _n ************************************************** *** Ensure all variables are present and labeled ************************************************** label drop _all label define impissue 1 `"Salaries"', modify label define impissue 2 `"Work conditions"', modify label define impissue 3 `"Regularizing contract teachers"', modify label define impissue 4 `"Reduce non-teaching duties"', modify label define impissue 5 `"Training"', modify label define impissue 6 `"Transfers/Promotions"', modify label define impissue 7 `"Reduce harassment by officials"', modify label define impissue 8 `"Others"', modify label define impissue 9 `"Don't know/Don't care"', modify label define impissue 77 `"Not Applicable"', modify label define aside 1 `"Teaching in another public school"', modify label define aside 2 `"Teaching in another private school"', modify label define aside 3 `"Providing private tuitions"', modify label define aside 4 `"Agriculture and livestock"', modify label define aside 5 `"Business"', modify label define aside 6 `"Politics and/or trade union work"', modify label define aside 7 `"Social work"', modify label define aside 8 `"Other income earning activities"', modify label define aside 77 `"Not applicable"', modify label define reason18 1 `"Public Transport often gets delayed/had to leave early to catch the public transport"', modify label define reason18 2 `"Had to go and see a doctor"', modify label define reason18 3 `"Attending a wedding"', modify label define reason18 4 `"Attending a funeral"', modify label define reason18 5 `"Taking care of a sick relative"', modify label define reason18 6 `"Other personal reasons"', modify label define reason18 9 `"Don't Know"', modify label define VISIT 1 `"Visit Round 1"', modify label define VISIT 2 `"Visit Round 2"', modify label define parenteduc 1 `"Did not complete primary school (6th grade)"', modify label define parenteduc 2 `"Completed primary school (6th grade)"', modify label define parenteduc 3 `"Completed junior secondary school (9th grade)"', modify label define parenteduc 4 `"Completed higher secondary school (12th grade)"', modify label define parenteduc 5 `"Completed college degree or above"', modify label define parenteduc 6 `"Don't Know"', modify label define timeref 1 `"This month"', modify label define timeref 2 `"In the past 2-6 months"', modify label define timeref 3 `"In the past 6-12 months"', modify label define timeref 4 `"More than a year ago"', modify label define timeref 5 `"Never"', modify label define timeref 9 `"Don't Know"', modify label define correct 0 `"did not attempt question"', modify label define correct 1 `"correct"', modify label define correct 2 `"incorrect"', modify label define weekday 1 `"Monday"', modify label define weekday 2 `"Tuesday"', modify label define weekday 3 `"Wednesday"', modify label define weekday 4 `"Thursday"', modify label define weekday 5 `"Friday"', modify label define weekday 6 `"Saturday"', modify label define weekday 7 `"Sunday"', modify label define ynanswer2 1 `"Yes"', modify label define ynanswer2 2 `"No"', modify label define outdoor 1 `"Organized sport/physical education period"', modify label define outdoor 2 `"Scheduled time for break"', modify label define outdoor 3 `"Unsupervised outdoor play, but not during a scheduled recess"', modify label define jobtitle 1 `"Principal/Head Teacher"', modify label define jobtitle 2 `"Deputy/Asst.Principal/Head Teacher"', modify label define jobtitle 3 `"Acting Principal/Head Teacher"', modify label define jobtitle 4 `"Teacher/Asst. Teacher"', modify label define jobtitle 5 `"Temporary/Probationary Teacher"', modify label define jobtitle 6 `"Volunteer Teacher"', modify label define jobtitle 7 `"Other"', modify label define schooltype 1 `"Government run regular school"', modify label define schooltype 2 `"Government run alternate/non-formal school"', modify label define schooltype 3 `"Private,but government aided"', modify label define schooltype 4 `"Private, recognized but not aided"', modify label define schooltype 5 `"Private, unrecognized"', modify label define schooltype 6 `"Run by a religious group/NGO, but aided"', modify label define schooltype 7 `"Run by a religious group/NGO,but not aided"', modify label define schooltype 8 `"Other"', modify label define examtype 1 `"National test"', modify label define examtype 2 `"Regional Test"', modify label define examtype 3 `"School Test"', modify label define examtype 4 `"Others"', modify label define paidsalary 1 `"Check is mailed to them"', modify label define paidsalary 2 `"Direct deposit into bank"', modify label define paidsalary 3 `"They pick up a check from the DEO"', modify label define paidsalary 4 `"They pick up cash from the DEO"', modify label define paidsalary 5 `"Other"', modify label define distance 1 `"Within the school boundaries"', modify label define distance 2 `"less than 100 metres"', modify label define distance 3 `"less than 1 km"', modify label define distance 4 `"between 1 and 5 km"', modify label define distance 5 `"between 5 and 15 km"', modify label define distance 6 `"between 15 and 25 km"', modify label define distance 7 `"between 25 and 100 km"', modify label define distance 8 `"more than 100 km"', modify label define distance 9 `"Don't know"', modify label define visitdate 1 `"this month"', modify label define visitdate 2 `"last month"', modify label define visitdate 3 `"in the last six months"', modify label define visitdate 4 `"in the last year"', modify label define visitdate 5 `"more than one year ago"', modify label define visitdate 6 `"Never"', modify label define visitdate 9 `"Don't know"', modify label define visittime 1 `"less than 30 minutes"', modify label define visittime 2 `"30 minutes-1 hour"', modify label define visittime 3 `"1-3 hours"', modify label define visittime 4 `"more than 3 hours"', modify label define visittime 5 `"Inspector never has come"', modify label define visittime 9 `"Don't know"', modify label define nervous 1 `"Very nervous"', modify label define nervous 2 `"Slightly nervous"', modify label define nervous 3 `"Not really nervous"', modify label define nervous 4 `"Don't feel nervous at all"', modify label define nervous 9 `"Don't know"', modify label define ynanswer5 1 `"Yes, have received some funds"', modify label define ynanswer5 2 `"Yes, but have not received any funds"', modify label define ynanswer5 3 `"No"', modify label define ynanswer5 9 `"Don't know"', modify label define spend 1 `"Repairing school building"', modify label define spend 2 `"Buying furnishing items"', modify label define spend 3 `"Buying teaching aids"', modify label define spend 4 `"Buying textbooks/notebooks for children"', modify label define spend 5 `"Providing scholarships/assistance to needy children"', modify label define spend 6 `"Others"', modify label define spend 9 `"Don't know"', modify label define termfee 1 `"Month"', modify label define termfee 2 `"3 months"', modify label define termfee 3 `"6 months (term)"', modify label define termfee 4 `"Year"', modify label define termfee 5 `"One time"', modify label define termfee 6 `"4 months"', modify label define action 1 `"Repeated late coming/early leaving"', modify label define action 2 `"Repeated absence"', modify label define action 3 `"Inability to control the class and/or teach properly"', modify label define action 4 `"Beating of students"', modify label define action 5 `"Improper behavior"', modify label define action 6 `"Cheating"', modify label define action 7 `"Financial impropriety"', modify label define action 8 `"Sexual/Physical abuse of students"', modify label define action 9 `"Others"', modify label define action 99 `"Don't know"', modify label define helpful9 1 `"Helpful"', modify label define helpful9 2 `"Unhelpful"', modify label define helpful9 3 `"No Difference"', modify label define helpful9 9 `"Don't know"', modify label define ynanswer49 1 `"Yes"', modify label define ynanswer49 2 `"No"', modify label define ynanswer49 3 `"Sometimes"', modify label define ynanswer49 9 `"Don't know"', modify label define award9 1 `"Yes, received an official award"', modify label define award9 2 `"Yes, received community recognition at an event"', modify label define award9 3 `"No"', modify label define award9 9 `"Don't know"', modify label define answer9 9 `"Don't know"', modify label define termfee9 1 `"Month"', modify label define termfee9 2 `"3 months"', modify label define termfee9 3 `"6 months (term)"', modify label define termfee9 4 `"Year"', modify label define termfee9 5 `"One time"', modify label define termfee9 6 `"4 months"', modify label define termfee9 9 `"Don't know"', modify label define actteacher 1 `"In the classroom teaching"', modify label define actteacher 2 `"In the classroom, but not teaching"', modify label define actteacher 3 `"Out of class, on a scheduled break"', modify label define actteacher 4 `"Out of class, but in school"', modify label define actteacher 5 `"Doing administrative work"', modify label define actteacher 6 `"Can't find the teacher/absent"', modify label define actteacher 7 `"Accompanying surveyor"', modify label define actteacher 8 `"In school, after school hour"', modify label define actteacher 9 `"Outside school, after school hour"', modify label define actteacher 10 `"Outside school in school hour"', modify label define actteacher 11 `"Others (specify)"', modify label define ynanswer 1 `"Yes"', modify label define ynanswer 2 `"No"', modify label define ynanswer 9 `"Don't know"', modify label define whoanswer 1 `"teacher (him/herself)"', modify label define whoanswer 2 `"Head of School"', modify label define whoanswer 3 `"Other school staff"', modify label define whoanswer 4 `"Others"', modify label define satisfy 1 `"Very Satisfied"', modify label define satisfy 2 `"Satisfied"', modify label define satisfy 3 `"Indifferent"', modify label define satisfy 4 `"Dissatisfied"', modify label define satisfy 5 `"Very dissatisfied"', modify label define satisfy 9 `"Don't know"', modify label define union 1 `"Yes, national union"', modify label define union 2 `"Yes, state union"', modify label define union 3 `"Yes, local union"', modify label define union 4 `"No"', modify label define union 9 `"Don't Know"', modify label define perform 1 `"Voter registration/Election monitoring"', modify label define perform 2 `"Census"', modify label define perform 3 `"Health program related"', modify label define perform 4 `"Disaster management"', modify label define perform 5 `"Other"', modify label define perform 9 `"Don't know"', modify label define problem 1 `"Inadequate salaries"', modify label define problem 2 `"Poor school infrastructure"', modify label define problem 3 `"Inadequate teaching supplies"', modify label define problem 4 `"Lack of interest/co-operation from parents"', modify label define problem 5 `"Shortage of teachers"', modify label define problem 6 `"Too much time spent on non-teaching duties"', modify label define problem 7 `"Irregular/unreliable salary payments"', modify label define problem 8 `"Long commute to the school"', modify label define problem 9 `"Don't Know"', modify label define problem 10 `"Harassment by officials/authorities"', modify label define problem 11 `"Other"', modify label define married 1 `"Single"', modify label define married 2 `"Married"', modify label define married 3 `"Separated"', modify label define married 4 `"Divorced"', modify label define married 5 `"Other"', modify label define transport 1 `"Walk"', modify label define transport 2 `"Bicycle"', modify label define transport 3 `"Bus/Group Public Transport"', modify label define transport 4 `"Taxi/Individual Public Transport"', modify label define transport 5 `"Motorcycle"', modify label define transport 6 `"Personal automobile"', modify label define transport 7 `"official vechicle"', modify label define transport 8 `"Other"', modify label define transport 9 `"Don't know"', modify label define speak 1 `"Native fluency (mother tongue)"', modify label define speak 2 `"Fluent"', modify label define speak 3 `"Very good"', modify label define speak 4 `"Good"', modify label define speak 5 `"Functional"', modify label define speak 6 `"Minimal"', modify label define speak 7 `"Not able to"', modify label define speak 9 `"Don't know"', modify label define wherelive 1 `"In this village/city"', modify label define wherelive 2 `"In this subdistrict"', modify label define wherelive 3 `"In this district"', modify label define wherelive 4 `"In the neighboring district"', modify label define wherelive 5 `"Elsewhere in this state"', modify label define wherelive 6 `"Some other state"', modify label define wherelive 7 `"Another country"', modify label define wherelive 9 `"Don't know"', modify label define ancenthome 1 `"This village/city"', modify label define ancenthome 2 `"This sub-district"', modify label define ancenthome 3 `"This district"', modify label define ancenthome 4 `"This state"', modify label define ancenthome 5 `"Neighboring state"', modify label define ancenthome 6 `"Some other state"', modify label define ancenthome 7 `"Another country"', modify label define ancenthome 9 `"Don't know"', modify label define prdtrain 1 `"At a time when the school was supposed to be running"', modify label define prdtrain 2 `"During a school vacation"', modify label define prdtrain 3 `"On school days, but after school hours"', modify label define prdtrain 9 `"Don't know"', modify label define traintime 1 `"Last 6 months"', modify label define traintime 2 `"Last 12 months"', modify label define traintime 3 `"Last 1-3 Years"', modify label define traintime 4 `"Last 3-5 Years"', modify label define traintime 5 `"Last 5-10 Years"', modify label define traintime 6 `"Over 10 years ago"', modify label define traintime 7 `"Never"', modify label define traintime 9 `"Don't Know"', modify label define educ 1 `"None"', modify label define educ 2 `"Teacher training school (high school level)"', modify label define educ 3 `"Dip. Ed./BTC"', modify label define educ 4 `"B.Ed."', modify label define educ 5 `"M.Ed."', modify label define educ 9 `"Don't know"', modify label define reasontrans 1 `"Routine application of posting and transfer rules"', modify label define reasontrans 2 `"Political interference/pressure"', modify label define reasontrans 3 `"Personal request"', modify label define reasontrans 4 `"Punishment"', modify label define reasontrans 5 `"Strained personal relations at previous school"', modify label define reasontrans 6 `"Other"', modify label define reasontrans 9 `"Don't know"', modify label define sex 1 `"Male"', modify label define sex 2 `"Female"', modify label define formapp 1 `"No documentation available"', modify label define formapp 2 `"Documents claimed to exist, but not verifiable"', modify label define formapp 3 `"Documents verified by investigator"', modify label define leavereq 1 `"Vacation"', modify label define leavereq 2 `"Attending a wedding"', modify label define leavereq 3 `"Attending a funeral"', modify label define leavereq 4 `"Taking care of a sick relative"', modify label define leavereq 5 `"Casual leave"', modify label define leavereq 6 `"Other personal reasons"', modify label define leavereq 9 `"Don't know"', modify label define dayname 1 `"Monday"', modify label define dayname 2 `"Tuesday"', modify label define dayname 3 `"Wednesday"', modify label define dayname 4 `"Thursday"', modify label define dayname 5 `"Friday"', modify label define dayname 6 `"Saturday"', modify label define dayname 7 `"Sunday"', modify label define ynanswer3 1 `"Yes"', modify label define ynanswer3 2 `"No"', modify label define ynanswer3 3 `"Don't know"', modify label define reason3 1 `"Voter registration/Election monitoring"', modify label define reason3 2 `"Census (human, cattle, etc.)"', modify label define reason3 3 `"Health program related"', modify label define reason3 4 `"Disaster management"', modify label define reason3 5 `"Other"', modify label define reason3 9 `"Don't know"', modify label define reason2 1 `"Attending a meeting"', modify label define reason2 2 `"Attending training"', modify label define reason2 3 `"Attending a conference"', modify label define reason2 4 `"Collecting teaching supplies"', modify label define reason2 5 `"Other"', modify label define reason2 9 `"Don't know"', modify label define offreason 1 `"Official teaching related duty"', modify label define offreason 2 `"Official non-teaching duty"', modify label define offreason 3 `"Assigned elsewhere/transferred"', modify label define offreason 4 `"Sick"', modify label define offreason 5 `"Works in a different shift"', modify label define offreason 6 `"Authorized leave"', modify label define offreason 7 `"Expected to arrive later/Not arrived yet"', modify label define offreason 8 `"Left early"', modify label define offreason 9 `"Don't know"', modify label define offreason 10 `"Unauthorized absence"', modify label define offreason 11 `"Suspended"', modify label define offreason 12 `"Other"', modify label define logreg 1 `"Yes"', modify label define logreg 2 `"No"', modify label define logreg 3 `"No attendance register exists"', modify label define logreg 9 `"Don't know"', modify label define ynanswer9 1 `"Yes"', modify label define ynanswer9 2 `"No"', modify label define ynanswer9 9 `"Don't Know"', modify label define timework 1 `"Full-time"', modify label define timework 2 `"Part-time"', modify label define timework 3 `"Other"', modify label define timework 9 `"Don't Know"', modify label define position 1 `"Head Teacher"', modify label define position 2 `"Deputy/Asst.Head Teacher"', modify label define position 3 `"Permanent Teacher"', modify label define position 4 `"Contract Teacher"', modify label define position 5 `"Temporary/Probationary Teacher"', modify label define position 6 `"Volunteer Teacher"', modify label define position 7 `"Honorer Teacher"', modify label define position 8 `"Other"', modify label define position 9 `"Don't Know"', modify label define graduate 1 `"below SSC"', modify label define graduate 2 `"SSC completed"', modify label define graduate 3 `"HSC completed"', modify label define graduate 4 `"Some college"', modify label define graduate 5 `"College graduate"', modify label define graduate 6 `"Some post graduate"', modify label define graduate 7 `"Post graduate"', modify label define graduate 9 `"Don't know"', modify label define dayname01 1 `"Monday"', modify label define dayname01 2 `"Tuesday"', modify label define dayname01 3 `"Wednesday"', modify label define dayname01 4 `"Thursday"', modify label define dayname01 5 `"Friday"', modify label define dayname01 6 `"Saturday"', modify label define dayname01 7 `"Sunday"', modify label define dayname01 99 `"Don't know"', modify label define schoolid2 1 `"147101001"', modify label define schoolid2 2 `"147101002"', modify label define schoolid2 3 `"147101003"', modify label define schoolid2 4 `"147102001"', modify label define schoolid2 5 `"147102002"', modify label define schoolid2 6 `"147102003"', modify label define schoolid2 7 `"147102004"', modify label define schoolid2 8 `"147102005"', modify label define schoolid2 9 `"147103001"', modify label define schoolid2 10 `"147105001"', modify label define schoolid2 11 `"147106001"', modify label define schoolid2 12 `"147106002"', modify label define schoolid2 13 `"147107001"', modify label define schoolid2 14 `"170201001"', modify label define schoolid2 15 `"170201002"', modify label define schoolid2 16 `"170201003"', modify label define schoolid2 17 `"170201004"', modify label define schoolid2 18 `"170203001"', modify label define schoolid2 19 `"170204001"', modify label define schoolid2 20 `"170204002"', modify label define schoolid2 21 `"170204003"', modify label define schoolid2 22 `"170204004"', modify label define schoolid2 23 `"170204005"', modify label define schoolid2 24 `"170204006"', modify label define schoolid2 25 `"170206001"', modify label define schoolid2 26 `"327301001"', modify label define schoolid2 27 `"327301002"', modify label define schoolid2 28 `"327305001"', modify label define schoolid2 29 `"327307001"', modify label define schoolid2 30 `"327311001"', modify label define schoolid2 31 `"327311002"', modify label define schoolid2 32 `"327312001"', modify label define schoolid2 33 `"327318001"', modify label define schoolid2 34 `"327321001"', modify label define schoolid2 35 `"327321002"', modify label define schoolid2 36 `"327321003"', modify label define schoolid2 37 `"327324001"', modify label define schoolid2 38 `"330805001"', modify label define schoolid2 39 `"330805002"', modify label define schoolid2 40 `"330808001"', modify label define schoolid2 41 `"330812001"', modify label define schoolid2 42 `"330812002"', modify label define schoolid2 43 `"330813001"', modify label define schoolid2 44 `"330818001"', modify label define schoolid2 45 `"330818002"', modify label define schoolid2 46 `"330818003"', modify label define schoolid2 47 `"330818004"', modify label define schoolid2 48 `"330819001"', modify label define schoolid2 49 `"330820001"', modify label define schoolid2 50 `"330820002"', modify label define schoolid2 51 `"337201001"', modify label define schoolid2 52 `"337201002"', modify label define schoolid2 53 `"337201003"', modify label define schoolid2 54 `"337203001"', modify label define schoolid2 55 `"337203002"', modify label define schoolid2 56 `"337204001"', modify label define schoolid2 57 `"337204002"', modify label define schoolid2 58 `"337204003"', modify label define schoolid2 59 `"337205001"', modify label define schoolid2 60 `"337205002"', modify label define schoolid2 61 `"337205003"', modify label define schoolid2 62 `"337205004"', modify label define schoolid2 63 `"337205005"', modify label define schoolid2 64 `"352305001"', modify label define schoolid2 65 `"352306001"', modify label define schoolid2 66 `"352307001"', modify label define schoolid2 67 `"352310001"', modify label define schoolid2 68 `"352310002"', modify label define schoolid2 69 `"352312001"', modify label define schoolid2 70 `"352312002"', modify label define schoolid2 71 `"352312003"', modify label define schoolid2 72 `"352313001"', modify label define schoolid2 73 `"352313002"', modify label define schoolid2 74 `"352314001"', modify label define schoolid2 75 `"352315001"', modify label define schoolid2 76 `"352315002"', modify label define schoolid2 77 `"357501001"', modify label define schoolid2 78 `"357501002"', modify label define schoolid2 79 `"357501003"', modify label define schoolid2 80 `"357501004"', modify label define schoolid2 81 `"357501005"', modify label define schoolid2 82 `"357501006"', modify label define schoolid2 83 `"357501007"', modify label define schoolid2 84 `"357502001"', modify label define schoolid2 85 `"357502002"', modify label define schoolid2 86 `"357502003"', modify label define schoolid2 87 `"357502004"', modify label define schoolid2 88 `"357502005"', modify label define schoolid2 89 `"357502006"', modify label define schoolid2 90 `"357502007"', modify label define schoolid2 91 `"357502008"', modify label define schoolid2 92 `"357502009"', modify label define schoolid2 93 `"357503001"', modify label define schoolid2 94 `"357503002"', modify label define schoolid2 95 `"357503003"', modify label define schoolid2 96 `"357503004"', modify label define schoolid2 97 `"357503005"', modify label define schoolid2 98 `"367601001"', modify label define schoolid2 99 `"367601002"', modify label define schoolid2 100 `"367601003"', modify label define schoolid2 101 `"367601004"', modify label define schoolid2 102 `"367601005"', modify label define schoolid2 103 `"367601006"', modify label define schoolid2 104 `"367602001"', modify label define schoolid2 105 `"367602002"', modify label define schoolid2 106 `"367602003"', modify label define schoolid2 107 `"367602004"', modify label define schoolid2 108 `"367602005"', modify label define schoolid2 109 `"367602006"', modify label define schoolid2 110 `"367602007"', modify label define schoolid2 111 `"367602008"', modify label define schoolid2 112 `"367602009"', modify label define schoolid2 113 `"367602010"', modify label define schoolid2 114 `"367603001"', modify label define schoolid2 115 `"367603002"', modify label define schoolid2 116 `"367604001"', modify label define schoolid2 117 `"367604002"', modify label define schoolid2 118 `"367604003"', modify label define schoolid2 119 `"367604004"', modify label define schoolid2 120 `"520201001"', modify label define schoolid2 121 `"520201002"', modify label define schoolid2 122 `"520203001"', modify label define schoolid2 123 `"520204001"', modify label define schoolid2 124 `"520204002"', modify label define schoolid2 125 `"520204003"', modify label define schoolid2 126 `"520204004"', modify label define schoolid2 127 `"520206001"', modify label define schoolid2 128 `"520206002"', modify label define schoolid2 129 `"520206003"', modify label define schoolid2 130 `"520207001"', modify label define schoolid2 131 `"520207002"', modify label define schoolid2 132 `"520209001"', modify label define schoolid2 133 `"520209002"', modify label define schoolid2 134 `"520209003"', modify label define schoolid2 135 `"730601001"', modify label define schoolid2 136 `"730601002"', modify label define schoolid2 137 `"730601003"', modify label define schoolid2 138 `"730602001"', modify label define schoolid2 139 `"730602002"', modify label define schoolid2 140 `"730602003"', modify label define schoolid2 141 `"730604001"', modify label define schoolid2 142 `"730604002"', modify label define schoolid2 143 `"730604003"', modify label define schoolid2 144 `"730604004"', modify label define schoolid2 145 `"730607001"', modify label define schoolid2 146 `"730608001"', modify label define schoolid2 147 `"730609001"', modify label define B1C3 1 `"Official teaching related duty"', modify label define B1C3 2 `"Official non-teaching duty"', modify label define B1C3 3 `"Assigned elsewhere/transferred"', modify label define B1C3 4 `"Works in a different shift"', modify label define B1C3 5 `" Authorized time-off"', modify label define B1C3 6 `"Expected to arrive later/Not here yet"', modify label define B1C3 7 `"Left early"', modify label define B1C3 8 `"Sick"', modify label define B1C3 9 `"Don't Know"', modify label define B1C3 10 `"Suspended"', modify label define B1C3 11 `"Post of head teacher is vacant"', modify label define B1C3 12 `"Other"', modify label define B1C3 88 `"NA"', modify label define b4bk14q3 1 `"Yes"', modify label define b4bk14q3 4 `"NA"', modify label define b4bk14q3 2 `"No"', modify label define b4bk14q3 9 `"Don't Know"', modify drop section numstudent num_testta~s no_random1 childname1 presence1 mtime_start1 mtime_end1 ltime_start1 ltime_end1 quest_id1 c2aq11 c2aq31 c2aq41 dadread1 dadeduc1 momread1 momeduc1 c2aq91 checkname1 totalmath1 correctmath1 totalwords1 correctword1 scoremath1 scoreword1 no_random2 childname2 presence2 mtime_start2 mtime_end2 ltime_start2 ltime_end2 quest_id2 c2aq12 c2aq32 c2aq42 dadread2 dadeduc2 momread2 momeduc2 c2aq92 checkname2 totalmath2 correctmath2 totalwords2 correctword2 scoremath2 scoreword2 no_random3 childname3 presence3 mtime_start3 mtime_end3 ltime_start3 ltime_end3 quest_id3 c2aq13 c2aq33 c2aq43 dadread3 dadeduc3 momread3 momeduc3 c2aq93 checkname3 totalmath3 correctmath3 totalwords3 correctword3 scoremath3 scoreword3 no_random4 childname4 presence4 mtime_start4 mtime_end4 ltime_start4 ltime_end4 quest_id4 c2aq14 c2aq34 c2aq44 dadread4 dadeduc4 momread4 momeduc4 c2aq94 checkname4 totalmath4 correctmath4 totalwords4 correctword4 scoremath4 scoreword4 no_random5 childname5 presence5 mtime_start5 mtime_end5 ltime_start5 ltime_end5 quest_id5 c2aq15 c2aq35 c2aq45 dadread5 dadeduc5 momread5 momeduc5 c2aq95 checkname5 totalmath5 correctmath5 totalwords5 correctword5 scoremath5 scoreword5 no_random6 childname6 presence6 mtime_start6 mtime_end6 ltime_start6 ltime_end6 quest_id6 c2aq16 c2aq36 c2aq46 dadread6 dadeduc6 momread6 momeduc6 c2aq96 checkname6 totalmath6 correctmath6 totalwords6 correctword6 scoremath6 scoreword6 no_random7 childname7 presence7 mtime_start7 mtime_end7 ltime_start7 ltime_end7 quest_id7 c2aq17 c2aq37 c2aq47 dadread7 dadeduc7 momread7 momeduc7 c2aq97 checkname7 totalmath7 correctmath7 totalwords7 correctword7 scoremath7 scoreword7 no_random8 childname8 presence8 mtime_start8 mtime_end8 ltime_start8 ltime_end8 quest_id8 c2aq18 c2aq38 c2aq48 dadread8 dadeduc8 momread8 momeduc6 c2aq96 checkname6 totalmath6 correctmath6 totalwords6 correctword6 scoremath6 scoreword6 no_random7 childname7 presence7 mtime_start7 mtime_end7 ltime_start7 ltime_end7 quest_id7 c2aq17 c2aq37 c2aq47 dadread7 dadeduc7 momread7 momeduc7 c2aq97 checkname7 totalmath7 correctmath7 totalwords7 correctword7 scoremath7 scoreword7 no_random8 childname8 presence8 mtime_start8 mtime_end8 ltime_start8 ltime_end8 quest_id8 c2aq18 c2aq38 c2aq48 dadread8 dadeduc8 momread8 momeduc8 c2aq98 checkname8 totalmath8 correctmath8 totalwords8 correctword8 scoremath8 scoreword8 no_random9 childname9 presence9 mtime_start9 mtime_end9 ltime_start9 ltime_end9 quest_id9 c2aq19 c2aq39 c2aq49 dadread9 dadeduc9 momread9 momeduc9 c2aq99 checkname9 totalmath9 correctmath9 totalwords9 correctword9 scoremath9 scoreword9 no_random10 childname10 presence10 mtime_sta~10 mtime_end10 ltime_sta~10 ltime_end10 quest_id10 c2aq110 c2aq310 c2aq410 dadread10 dadeduc10 momread10 momeduc10 c2aq910 checkname10 totalmath10 correctma~10 totalwords10 correctwo~10 scoremath10 scoreword10 drop b6k4q2 b6k5q2 b1dq4 ************************************************** *** Recode missing values *************************************************** **Correcting incorrect coding from 9 to 6 for "don't know" qui mvdecode b1c3 b3bq9 b3bq9d b4bk1q4 b4bk14q3 b4bk1q5 b4bk2q1 b1gq3a, mv(9=.d) * DECODE MISSING VALUES /* DON�T KNOW (-666):.d NOT APPLICABLE (-777):.n LACK OF RECORDS (-888):.l REFUSED TO ANSWER (-999):.r */ # 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 address b1a1 b1a2 b1a3 b1a4 b1a4d b1a5 b1a5d b1a6 b1a6d b1a7 b1a7d b1a8y b1a9 b1aq4 b1b5 b1b6 b1bq2 b1bq3 b1c5 b1c6 b1c7 b1c8 b1cq1 b1cq6 b1cq7 b1dq9 b1eq2 b1fq2 b1fq2d b1fq2lama b1fq5b b1fq5c b1gq1 b1gq2 b1gq4 b1gq5 b1gq6 b1gq7 b2as11q1 b2as11q2 b2as11q3 b2as12q2 b2as12q3 b2as13q2 b2as13q3 b2as14q2 b2as14q3 b2as15q2 b2as15q3 b2as16q2 b2as16q3 b2as21q2 b2as21q3 b2as22q2 b2as22q3 b2as23q2 b2as23q3 b2as24q2 b2as24q3 b2as25q2 b2as25q3 b2as26q2 b2as26q3 b2bk1_1 b2bk1_2 b2bk1_3 b2bk10 b2bk11_1 b2bk11_2 b2bk11_3 b2bk11_4 b2bk11_5 b2bk11_6 b2bk4 b2bk4d b2bk6_1 b2bk6_2 b2bk6_3 b2bk9 b2bk9d b3aq3 b3aq6 b3aq7 b3aq8 b3bq10 b3bq10d b3bq11 b3bq11d b3bq13 b3bq14 b3cq17 b3cq19 b3cq20 b4bk10q1 b4bk10q4 b4bk10q5 b4bk11q1 b4bk11q4 b4bk11q5 b4bk12q1 b4bk12q4 b4bk12q5 b4bk13q1 b4bk13q4 b4bk13q5 b4bk14q1 b4bk14q4 b4bk14q5 b4bk15q1 b4bk15q4 b4bk15q5 b4bk16q1 b4bk16q4 b4bk16q5 b4bk17q1 b4bk17q4 b4bk17q5 b4bk18q1 b4bk18q4 b4bk18q5 b4bk1q1 b4bk1q2 b4bk1q3 b4bk1q4 b4bk1q5 b4bk2q1 b4bk3q1 b4bk3q4 b4bk3q5 b4bk4q1 b4bk4q4 b4bk4q5 b4bk5q1 b4bk5q4 b4bk5q5 b4bk6q1 b4bk6q4 b4bk6q5 b4bk7q1 b4bk7q4 b4bk7q5 b4bk8q1 b4bk8q4 b4bk8q5 b4bk9q1 b4bk9q4 b4bk9q5 b5ak13 b5ak14 b5ak15 b5ak16 b5ak17 b5ak19 b5ak1d b5ak2 b5ak20 b5ak21 b5ak22 b5ak23 b5ak24 b5ak25 b5ak27 b5ak28 b5ak4 b5ak8 b5bk1 b5bk1d b5bk2 b5bk2d b5bk3 b5bk3d b5bk4 b5bk4d b5bk5 b6k1q1 b6k1q2 b6k1q4 b6k2q1 b6k2q2 b6k2q3 b6k2q4 b6k2q5 b6k3q1 b6k3q2 b6k3q3 b6k3q4 b6k3q5 b6k4q1 b6k4q3 b6k4q4 b6k4q5 b6k5q1 b6k5q3 b6k5q4 b6k5q5 b6k6q1 b6k6q2 b6k6q3 b6k6q4 b6k6q5 b6k7q1 b6k7q2 b6k7q3 b6k7q4 b6k7q5 b6k8d b6k8q1 b6k8q2 b6k8q3 b6k8q4 b6k8q5 b7k1q1 b7k1q3 b7k1q4 b7k1q4d b7k2q1 b7k2q2 b7k2q2d b7k2q3 b7k3q1 b7k3q3 b7k4q1 b7k4q3 b7k5q1 b7k5q3 b7k6q1 b7k6q3 hp jum1_per jum3_per name percent1 percent2 percent2_1 percent2_2 percent2_3 percent2_4 percent2_5 percent2_6 percent3 percent4 percent5 percent6 phone ps_per2_1 ps_per2_2 ps_per2_3 ps_per2_4 ps_per2_5 ps_per2_6 ps1 ps1_per ps2 ps2_1 ps2_2 ps2_3 ps2_4 ps2_5 ps2_6 ps2_per ps3 ps3_per ps4 ps4_per ps5 ps5_per ps6 ps6_per respondent schoolid time_end time_start visit, mv( 9=.l\ 8=.d \ 7=.n \ 6=.r); qui mvdecode b1bq5 b1bq5d b5ak10 b5ak11 b5ak11d b5ak12 b5ak12d b5ak18 b5ak26_1 b5ak26_2 b5ak26_3 b5ak26_4 b5ak26d b5ak29_1 b5ak29_2 b5ak29_3 b5ak29_4 b5ak29d b5ak3 b5ak30 b5ak3d b5ak5 b5ak5d b5ak6 b5ak6d b5ak7 b5ak7d b5ak9 b6k1q3, mv( 9=.l\ 8=.d \ 7=.n ); qui mvdecode b1c9 b1dq8 b1fq4 b1fq4d b2as12q1 b2as13q1 b2as14q1 b2as15q1 b2as16q1 b2as21q1 b2as22q1 b2as23q1 b2as24q1 b2as25q1 b2as26q1, mv( 9=.l); qui mvdecode b1c2 b1c2d b1dq1 b1dq2 b1dq3 b1dq5, mv( 9=.l\ 8=.d ); # d cr; qui mvdecode _all, mv(77=.n\88=.d\99=.l) ************************************************** *** Correcting errors ************************************************** foreach vvv of varlist b3bq14 b3cq15n_1 b3cq15n_2 b3cq15n_3 b3cq15n_4 b3cq15n_5 b3cq15n_6 b3cq16 b3cq17{ replace `vvv' =. if uid== 24 replace `vvv' =. if uid== 25 replace `vvv' =. if uid== 36 replace `vvv' =. if uid== 115 replace `vvv' =. if uid== 134 replace `vvv' =. if uid== 141 replace `vvv' =. if uid== 186 replace `vvv' =. if uid== 213 replace `vvv' =. if uid== 223 replace `vvv' =. if uid== 267 replace `vvv' =. if uid== 397 replace `vvv' =. if uid== 559 replace `vvv' =. if uid== 575 replace `vvv' =. if uid== 585 replace `vvv' =. if uid== 683 replace `vvv' =. if uid== 684 replace `vvv' =. if uid== 836 replace `vvv' =. if uid== 925 replace `vvv' =. if uid== 1010 replace `vvv' =. if uid== 1130 replace `vvv' =. if uid== 1230 replace `vvv' =. if uid== 1232 replace `vvv' =. if uid== 1264 replace `vvv' =. if uid== 1317 replace `vvv' =. if uid== 1393 replace `vvv' =. if uid== 1318 replace `vvv' =. if uid== 1457 replace `vvv' =. if uid== 1459 replace `vvv' =. if uid== 1504 replace `vvv' =. if uid== 1570 replace `vvv' =. if uid== 1581 replace `vvv' =. if uid== 1589 replace `vvv' =. if uid== 1693 replace `vvv' =. if uid== 1774 replace `vvv' =. if uid== 1819 replace `vvv' =. if uid== 1855 replace `vvv' =. if uid== 1903 replace `vvv' =. if uid== 1917 replace `vvv' =. if uid== 2018 replace `vvv' =. if uid== 2067 replace `vvv' =. if uid== 2117 replace `vvv' =. if uid== 2118 replace `vvv' =. if uid== 2179 replace `vvv' =. if uid== 2198 replace `vvv' =. if uid== 2320 replace `vvv' =. if uid== 2339 replace `vvv' =. if uid== 2410 replace `vvv' =. if uid== 2441 replace `vvv' =. if uid== 2445 replace `vvv' =. if uid== 2488 replace `vvv' =. if uid== 2485 replace `vvv' =. if uid== 2588 replace `vvv' =. if uid== 2586 replace `vvv' =. if uid== 2589 replace `vvv' =. if uid== 2627 replace `vvv' =. if uid== 2636 replace `vvv' =. if uid== 2644 replace `vvv' =. if uid== 2670 replace `vvv' =. if uid== 2673 replace `vvv' =. if uid== 2678 replace `vvv' =. if uid== 2686 replace `vvv' =. if uid== 2716 replace `vvv' =. if uid== 2842 replace `vvv' =. if uid== 2852 replace `vvv' =. if uid== 2865 } foreach vvv of varlist b5ak9 { replace `vvv' =. if uid== 1393 replace `vvv' =. if uid== 1694 replace `vvv' =. if uid== 1696 replace `vvv' =. if uid== 1680 replace `vvv' =. if uid== 1682 replace `vvv' =. if uid== 1684 replace `vvv' =. if uid== 1686 replace `vvv' =. if uid== 1688 replace `vvv' =. if uid== 1690 replace `vvv' =. if uid== 1692 replace `vvv' =. if uid== 1694 replace `vvv' =. if uid== 1696 replace `vvv' =. if uid== 1744 replace `vvv' =. if uid== 1746 replace `vvv' =. if uid== 1748 replace `vvv' =. if uid== 1750 replace `vvv' =. if uid== 1752 replace `vvv' =. if uid== 1754 replace `vvv' =. if uid== 1756 replace `vvv' =. if uid== 1758 replace `vvv' =. if uid== 1760 replace `vvv' =. if uid== 1932 replace `vvv' =. if uid== 1934 replace `vvv' =. if uid== 1936 replace `vvv' =. if uid== 1938 replace `vvv' =. if uid== 1940 replace `vvv' =. if uid== 1942 replace `vvv' =. if uid== 1944 replace `vvv' =. if uid== 1946 replace `vvv' =. if uid== 1948 replace `vvv' =. if uid== 1950 replace `vvv' =. if uid== 1952 replace `vvv' =. if uid== 1954 replace `vvv' =. if uid== 1956 replace `vvv' =. if uid== 1958 } ************************************************** *** 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) * Implement Questionnaire Consistency Tests. Each of these tests resolves to 1 if there is an error. gen error01 = (b3bq9 == 1 & (b3bq11 < . | b3bq12 < . | b3bq13 < . | b3bq14 < . | b3cq15n_1 < . | b3cq15n_2 < . | b3cq15n_2 < . | b3cq15n_3 < . | b3cq15n_4 < . | b3cq15n_5 < . | b3cq15n_6 < . | b3cq16 < . | b3cq17 < . )) gen error02 = (b3bq9 == 2 & (b3bq12 < . | b3bq13 < . | b3bq14 < . | b3cq15n_1 < . | b3cq15n_2 < . | b3cq15n_2 < . | b3cq15n_3 < . | b3cq15n_4 < . | b3cq15n_5 < . | b3cq15n_6 < . | b3cq16 < . | b3cq17 < . )) gen error03 = (b3bq9 == 3 & (b3bq13 < . | b3bq14 < . | b3cq15n_1 < . | b3cq15n_2 < . | b3cq15n_3 < . | b3cq15n_4 < . | b3cq15n_5 < . | b3cq15n_6 < . | b3cq16 < . | b3cq17 < . )) gen error04 = (b3bq9 == 4 & (b3bq14 < . | b3cq15n_1 < . | b3cq15n_2 < . | b3cq15n_2 < . | b3cq15n_3 < . | b3cq15n_4 < . | b3cq17 < . )) gen error05 = (b3bq9 == 5 & (b3cq16 < . | b3cq17 < . )) gen error06 = (b5ak8 == 2 & (b5ak9 < . )) * 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) ************************************************** *** Identify outliers ************************************************** mvdecode address b1a1 b1a2 b1a3 b1a4 b1a4d b1a5 b1a5d b1a6 b1a6d b1a7 b1a7d b1a8y b1a9 b1aq4 b1b5 b1b6 b1bq2 b1bq3 b1c5 b1c6 b1c7 b1c8 b1cq1 b1cq6 b1cq7 b1dq9 b1eq2 b1fq2 b1fq2d b1fq2lama b1fq5b b1fq5c b1gq1 b1gq2 b1gq4 b1gq5 b1gq6 b1gq7 b2as11q1 b2as11q2 b2as11q3 b2as12q2 b2as12q3 b2as13q2 b2as13q3 b2as14q2 b2as14q3 b2as15q2 b2as15q3 b2as16q2 b2as16q3 b2as21q2 b2as21q3 b2as22q2 b2as22q3 b2as23q2 b2as23q3 b2as24q2 b2as24q3 b2as25q2 b2as25q3 b2as26q2 b2as26q3 b2bk1_1 b2bk1_2 b2bk1_3 b2bk10 b2bk11_1 b2bk11_2 b2bk11_3 b2bk11_4 b2bk11_5 b2bk11_6 b2bk4 b2bk4d b2bk6_1 b2bk6_2 b2bk6_3 b2bk9 b2bk9d b3aq3 b3aq6 b3aq7 b3aq8 b3bq10 b3bq10d b3bq11 b3bq11d b3bq13 b3bq14 b3cq17 b3cq19 b3cq20 b4bk10q1 b4bk10q4 b4bk10q5 b4bk11q1 b4bk11q4 b4bk11q5 b4bk12q1 b4bk12q4 b4bk12q5 b4bk13q1 b4bk13q4 b4bk13q5 b4bk14q1 b4bk14q4 b4bk14q5 b4bk15q1 b4bk15q4 b4bk15q5 b4bk16q1 b4bk16q4 b4bk16q5 b4bk17q1 b4bk17q4 b4bk17q5 b4bk18q1 b4bk18q4 b4bk18q5 b4bk1q1 b4bk1q2 b4bk1q3 b4bk1q4 b4bk1q5 b4bk2q1 b4bk3q1 b4bk3q4 b4bk3q5 b4bk4q1 b4bk4q4 b4bk4q5 b4bk5q1 b4bk5q4 b4bk5q5 b4bk6q1 b4bk6q4 b4bk6q5 b4bk7q1 b4bk7q4 b4bk7q5 b4bk8q1 b4bk8q4 b4bk8q5 b4bk9q1 b4bk9q4 b4bk9q5 b5ak13 b5ak14 b5ak15 b5ak16 b5ak17 b5ak19 b5ak1d b5ak2 b5ak20 b5ak21 b5ak22 b5ak23 b5ak24 b5ak25 b5ak27 b5ak28 b5ak4 b5ak8 b5bk1 b5bk1d b5bk2 b5bk2d b5bk3 b5bk3d b5bk4 b5bk4d b5bk5 b6k1q1 b6k1q2 b6k1q4 b6k2q1 b6k2q2 b6k2q3 b6k2q4 b6k2q5 b6k3q1 b6k3q2 b6k3q3 b6k3q4 b6k3q5 b6k4q1 b6k4q3 b6k4q4 b6k4q5 b6k5q1 b6k5q3 b6k5q4 b6k5q5 b6k6q1 b6k6q2 b6k6q3 b6k6q4 b6k6q5 b6k7q1 b6k7q2 b6k7q3 b6k7q4 b6k7q5 b6k8d b6k8q1 b6k8q2 b6k8q3 b6k8q4 b6k8q5 b7k1q1 b7k1q3 b7k1q4 b7k1q4d b7k2q1 b7k2q2 b7k2q2d b7k2q3 b7k3q1 b7k3q3 b7k4q1 b7k4q3 b7k5q1 b7k5q3 b7k6q1 b7k6q3 hp jum1_per jum3_per name percent1 percent2 percent2_1 percent2_2 percent2_3 percent2_4 percent2_5 percent2_6 percent3 percent4 percent5 percent6 phone ps_b2bk5 ps_per2_1 ps_per2_2 ps_per2_3 ps_per2_4 ps_per2_5 ps_per2_6 ps1 ps1_per ps2 ps2_1 ps2_2 ps2_3 ps2_4 ps2_5 ps2_6 ps2_per ps3 ps3_per ps4 ps4_per ps5 ps5_per ps6 ps6_per respondent schoolid time_end time_start visit , mv(0 = .z) grubbs b1a8y b1a9 b1aq4 b1b5 b1b6 b1bq2 b1bq3 b1c5 b1c6 b1c8 b1cq1 b1cq6 b1cq7 b1dq9 b1eq2 b1fq2 b1fq2lama b1fq5b b1fq5c b1gq1 b1gq2 b1gq4 b1gq5 b1gq6 b1gq7 b2as11q1 b2bk10 b2bk11_1 b2bk11_2 b2bk11_3 b2bk11_4 b2bk11_5 b2bk11_6 b2bk4 b2bk6_1 b2bk6_2 b2bk6_3 b2bk9 b3aq6 b3aq7 b3aq8 b3bq10 b3bq11 b3bq13 b3bq14 b3cq17 b3cq19 b3cq20 b4bk10q1 b4bk10q4 b4bk10q5 b4bk11q1 b4bk11q4 b4bk11q5 b4bk12q1 b4bk12q4 b4bk12q5 b4bk13q1 b4bk13q4 b4bk13q5 b4bk14q1 b4bk14q4 b4bk14q5 b4bk15q1 b4bk15q4 b4bk15q5 b4bk16q1 b4bk16q4 b4bk16q5 b4bk17q1 b4bk17q4 b4bk17q5 b4bk18q1 b4bk18q4 b4bk18q5 b4bk1q1 b4bk1q2 b4bk1q3 b4bk1q4 b4bk1q5 b4bk2q1 b4bk3q1 b4bk3q4 b4bk3q5 b4bk4q1 b4bk4q4 b4bk4q5 b4bk5q1 b4bk5q4 b4bk5q5 b4bk6q1 b4bk6q4 b4bk6q5 b4bk7q1 b4bk7q4 b4bk7q5 b4bk8q1 b4bk8q4 b4bk8q5 b4bk9q1 b4bk9q4 b4bk9q5 b5ak13 b5ak14 b5ak15 b5ak16 b5ak17 b5ak19 b5ak2 b5ak20 b5ak21 b5ak22 b5ak23 b5ak24 b5ak25 b5ak27 b5ak28 b5ak4 b5ak8 b5bk1 b5bk1d b5bk2 b5bk2d b5bk3 b5bk3d b5bk4 b5bk4d b5bk5 b6k1q1 b6k1q2 b6k1q4 b6k2q1 b6k2q2 b6k2q3 b6k2q4 b6k2q5 b6k3q1 b6k3q2 b6k3q3 b6k3q4 b6k3q5 b6k4q1 b6k4q3 b6k4q4 b6k4q5 b6k5q1 b6k5q3 b6k5q4 b6k5q5 b6k6q1 b6k6q2 b6k6q3 b6k6q4 b6k6q5 b6k7q1 b6k7q2 b6k7q3 b6k7q4 b6k7q5 b6k8q1 b6k8q2 b6k8q3 b6k8q4 b6k8q5 b7k1q1 b7k1q3 b7k1q4 b7k2q2 b7k2q3 b7k3q1 b7k3q3 b7k4q1 b7k4q3 b7k5q1 b7k5q3 b7k6q1 b7k6q3 jum1_per jum3_per percent1 percent2 percent2_1 percent2_2 percent2_3 percent2_4 percent2_5 percent2_6 percent3 percent4 percent5 percent6 visit, level(99.99) mvencode b1a1 b1a2 b1a3 b1a4 b1a4d b1a5 b1a5d b1a6 b1a6d b1a7 b1a7d b1a8y b1a9 b1aq4 b1b5 b1b6 b1bq2 b1bq3 b1c5 b1c6 b1c7 b1c8 b1cq1 b1cq6 b1cq7 b1dq9 b1eq2 b1fq2 b1fq2d b1fq2lama b1fq5b b1fq5c b1gq1 b1gq2 b1gq4 b1gq5 b1gq6 b1gq7 b2as11q1 b2as11q2 b2as11q3 b2as12q2 b2as12q3 b2as13q2 b2as13q3 b2as14q2 b2as14q3 b2as15q2 b2as15q3 b2as16q2 b2as16q3 b2as21q2 b2as21q3 b2as22q2 b2as22q3 b2as23q2 b2as23q3 b2as24q2 b2as24q3 b2as25q2 b2as25q3 b2as26q2 b2as26q3 b2bk1_1 b2bk1_2 b2bk1_3 b2bk10 b2bk11_1 b2bk11_2 b2bk11_3 b2bk11_4 b2bk11_5 b2bk11_6 b2bk4 b2bk4d b2bk6_1 b2bk6_2 b2bk6_3 b2bk9 b2bk9d b3aq3 b3aq6 b3aq7 b3aq8 b3bq10 b3bq10d b3bq11 b3bq11d b3bq13 b3bq14 b3cq17 b3cq19 b3cq20 b4bk10q1 b4bk10q4 b4bk10q5 b4bk11q1 b4bk11q4 b4bk11q5 b4bk12q1 b4bk12q4 b4bk12q5 b4bk13q1 b4bk13q4 b4bk13q5 b4bk14q1 b4bk14q4 b4bk14q5 b4bk15q1 b4bk15q4 b4bk15q5 b4bk16q1 b4bk16q4 b4bk16q5 b4bk17q1 b4bk17q4 b4bk17q5 b4bk18q1 b4bk18q4 b4bk18q5 b4bk1q1 b4bk1q2 b4bk1q3 b4bk1q4 b4bk1q5 b4bk2q1 b4bk3q1 b4bk3q4 b4bk3q5 b4bk4q1 b4bk4q4 b4bk4q5 b4bk5q1 b4bk5q4 b4bk5q5 b4bk6q1 b4bk6q4 b4bk6q5 b4bk7q1 b4bk7q4 b4bk7q5 b4bk8q1 b4bk8q4 b4bk8q5 b4bk9q1 b4bk9q4 b4bk9q5 b5ak13 b5ak14 b5ak15 b5ak16 b5ak17 b5ak19 b5ak1d b5ak2 b5ak20 b5ak21 b5ak22 b5ak23 b5ak24 b5ak25 b5ak27 b5ak28 b5ak4 b5ak8 b5bk1 b5bk1d b5bk2 b5bk2d b5bk3 b5bk3d b5bk4 b5bk4d b5bk5 b6k1q1 b6k1q2 b6k1q4 b6k2q1 b6k2q2 b6k2q3 b6k2q4 b6k2q5 b6k3q1 b6k3q2 b6k3q3 b6k3q4 b6k3q5 b6k4q1 b6k4q3 b6k4q4 b6k4q5 b6k5q1 b6k5q3 b6k5q4 b6k5q5 b6k6q1 b6k6q2 b6k6q3 b6k6q4 b6k6q5 b6k7q1 b6k7q2 b6k7q3 b6k7q4 b6k7q5 b6k8d b6k8q1 b6k8q2 b6k8q3 b6k8q4 b6k8q5 b7k1q1 b7k1q3 b7k1q4 b7k1q4d b7k2q1 b7k2q2 b7k2q2d b7k2q3 b7k3q1 b7k3q3 b7k4q1 b7k4q3 b7k5q1 b7k5q3 b7k6q1 b7k6q3 jum1_per jum3_per percent1 percent2 percent2_1 percent2_2 percent2_3 percent2_4 percent2_5 percent2_6 percent3 percent4 percent5 percent6 phone ps_b2bk5 ps_per2_1 ps_per2_2 ps_per2_3 ps_per2_4 ps_per2_5 ps_per2_6 ps1 ps1_per ps2 ps2_1 ps2_2 ps2_3 ps2_4 ps2_5 ps2_6 ps2_per ps3 ps3_per ps4 ps4_per ps5 ps5_per ps6 ps6_per respondent schoolid time_end time_start visit, mv(.z = 0) ************************************************** *** Identify errors to be reviewed ************************************************** cd "Source/Indonesia 2003 A/Data/4.3. Clean Data/4.3.3. Data Code Book" log using "indoschoolsurvey codebook errors ", replace codebook grubbs_* error*, compact log close drop grubbs* drop error*