*Pillar 3 - Analysing VACS data* *Session 3.7 - Constructing and coding SRGBV* *Step by step guide of how to construct SRGBV variables* *In this guide, we will be coding an SRGBV variable using the Cote d'Ivoire VACS data. To measure SRGBV, we can look at any violence perpetrated by a schoolmate or teacher. ******************************************************************************* *Setting up your data ******************************************************************************* *Cote d'Ivoire only has one dataset for all individuals, but note that some countries have separate datasets for males and females. If they are separate, depending on the analysis you are doing, you can either analyse them separately or merge the datasets before analysing them. *Set your working directory to the file location where you would like to save all files for your project, and load the dataset into stata. *cd "..." use CotedIvoire_pubuse_031522.dta *Make all the variables lower case. This will make it easier to code as Stata is case sensitive and the VACS survey has some variables in upper and some in lower case. rename *, lower ******************************************************************************* *Surveyset your data ******************************************************************************* *Now we need to surveyset our data to account for the complex sampling strategy used in the VACS surveys. *For Cote d'Ivoire, the stratification, cluster, and sample weight variables are strata, psu, EA, and sampleweight, respectively. Note that this varies by survey and you will need to check the variables for your country survey. The data summary file that you will receive with the dataset details this. gen weight=sampleweight svyset psu [pweight=weight], strata(strata) vce(linearized) singleunit(centered) *************************************************** *Ever attended school *************************************************** *Let's create a variable for ever attending school as this will be important when thinking about experience of SRGBV. Note there are different ways you could look at education, for example highest level of schooling completed or current attendance. clonevar schattend_ever=q3 // Have you ever attended school? recode schattend_ever (2=0) (99=0) label values schattend_ever yesno tab schattend_ever tab q3 ****************************************************** *Physical violence perpetrated by classmate/schoolmate ****************************************************** *Let's first look at any violence perpetrated by a schoolmate *PV2 peers - within PV2, we can use q114 and q117 where the individual is asked about who perpetrated the peer physical violence that they experienced for their most recent and first experience of peer PV, respectively. Only people who experienced any of the four peer physical violence questions (q100, q110, q120, q132) will go onto answer q114 and/or q117. *Most recent experience *Let's first look at most recent experience of peer PV being perpetrated by a classmate/schoolmate. gen pv2_schoolmate_mr=0 // denominator is full sample replace pv2_schoolmate_mr=1 if q114==4 | q114==9 // this codes the variable as 1 if the individual has experienced peer physical violence from either a male or female classmate. You can also look at these separately if you would like to. tab pv2_schoolmate_mr q114 svy:tab pv2_schoolmate_mr, obs *First experience *Now let's look at first experience of PV being perpetrated by a classmate/schoolmate. gen pv2_schoolmate_ft=0 // denominator is full sample replace pv2_schoolmate_ft=1 if q117==4 | q117==9 // this codes the variable as 1 if the individual has experienced peer physical violence from either a male or female classmate. You can also look at these separately if you would like to. tab pv2_schoolmate_ft q117 svy:tab pv2_schoolmate_ft, obs *In the example above, the denominator is the full sample. But it could also be useful to look at the prevalence among only those who have ever attended school to understand the proportion who experienced SRBGV. svy:tab pv2_schoolmate_mr if schattend_ever==1 svy:tab pv2_schoolmate_ft if schattend_ever==1 *We can also generate a variable for the first or most recent experience of any SV being by a classmate/schoolmate gen pv2_schoolmate_mrft=0 replace pv2_schoolmate_mrft=1 if inlist(1, pv2_schoolmate_mr, pv2_schoolmate_ft) svy:tab pv2_schoolmate_mrft,obs svy:tab pv2_schoolmate_mrft if schattend_ever==1, obs ci // denominator is individuals who have ever attended school ****************************************************** *Physical violence perpetrated by teacher ****************************************************** *Now let's do the same to look at any violence perpetrated by a teacher. Teachers are listed as possible perpetrators for violence perpetrated by adults in the community or neighbourhood (PV4). *Most recent experience *Let's start with most recent experience of PV4 being perpetrated by teacher gen pv4_teacher_mr=0 replace pv4_teacher_mr=1 if q136==1 | q136==9 // We have grouped male and female teachers together but you could also look at these separately. tab pv4_teacher_mr q136 svy:tab pv4_teacher_mr,obs *First experience *Now we can look at the first experience of PV4 being perpetrated by teacher gen pv4_teacher_ft=0 replace pv4_teacher_ft=1 if q139==1 | q139==9 // We have grouped male and female teachers together but you could also look at these separately. tab pv4_teacher_ft tab pv4_teacher_ft q139 svy:tab pv4_teacher_ft,obs *We can also generate a variable for the first or most recent experience of any SV being by a classmate/schoolmate gen pv4_teacher_mrft=0 replace pv4_teacher_mrft=1 if inlist(1, pv4_teacher_mr, pv4_teacher_ft) svy:tab pv4_teacher_mrft,obs svy:tab pv4_teacher_mrft if schattend_ever==1, obs ci // denominator is individuals who have ever attended school **************************************************** *Sexual violence perpetrated by classmate/schoolmate **************************************************** *Now let's look at sexual violence. For each type of of SV1-SV4, we can create a variable for either the first and most recent time experience of that act of SV being perpetrated by a classmate/schoolmate. *SV1 - most recent gen sv1_schoolmate_mr=0 replace sv1_schoolmate_mr=1 if q605==9 | q605==26 tab sv1_schoolmate_mr q605 svy:tab sv1_schoolmate_mr,obs *SV1 - first time gen sv1_schoolmate_ft=0 replace sv1_schoolmate_ft=1 if q612==9 | q612==26 tab sv1_schoolmate_ft q612 svy:tab sv1_schoolmate_ft,obs *SV1 - first or most recent time from a classmate/schoolmate gen sv1_schoolmate_mrft=0 replace sv1_schoolmate_mrft=1 if inlist(1,sv1_schoolmate_mr, sv1_schoolmate_ft) *SV2 - most recent gen sv2_schoolmate_mr=0 replace sv2_schoolmate_mr=1 if q705==9 | q705==26 tab sv2_schoolmate_mr q705 svy:tab sv2_schoolmate_mr,obs *SV2 - first time gen sv2_schoolmate_ft=0 replace sv2_schoolmate_ft=1 if q712==9 | q712==26 tab sv2_schoolmate_ft q712 svy:tab sv2_schoolmate_ft,obs *SV2 - first or most recent time from a classmate/schoolmate gen sv2_schoolmate_mrft=0 replace sv2_schoolmate_mrft=1 if inlist(1,sv2_schoolmate_mr, sv2_schoolmate_ft) *SV3 - most recent gen sv3_schoolmate_mr=0 replace sv3_schoolmate_mr=1 if q805==9 | q805==26 tab sv3_schoolmate_mr q805 svy:tab sv3_schoolmate_mr,obs *SV3 - first time gen sv3_schoolmate_ft=0 replace sv3_schoolmate_ft=1 if q813==9 | q813==26 tab sv3_schoolmate_ft q813 svy:tab sv3_schoolmate_ft,obs *SV3 - first or most recent time from a classmate/schoolmate gen sv3_schoolmate_mrft=0 replace sv3_schoolmate_mrft=1 if inlist(1,sv3_schoolmate_mr, sv3_schoolmate_ft) *SV4 - most recent gen sv4_schoolmate_mr=0 replace sv4_schoolmate_mr=1 if q905==9 | q905==26 tab sv4_schoolmate_mr q905 svy:tab sv4_schoolmate_mr,obs *SV4 - first time gen sv4_schoolmate_ft=0 replace sv4_schoolmate_ft=1 if q912==9 | q912==26 tab sv4_schoolmate_ft q912 svy:tab sv4_schoolmate_ft,obs *SV4 - first or most recent time from a classmate/schoolmate gen sv4_schoolmate_mrft=0 replace sv4_schoolmate_mrft=1 if inlist(1,sv4_schoolmate_mr, sv4_schoolmate_ft) *Now let's tabulate each of these variables svy:tab sv1_schoolmate_mrft,obs // denominator is the full sample svy:tab sv1_schoolmate_mrft if schattend_ever==1,obs // denominator is those who have ever attended school svy:tab sv2_schoolmate_mrft,obs svy:tab sv2_schoolmate_mrft if schattend_ever==1,obs svy:tab sv3_schoolmate_mrft,obs svy:tab sv3_schoolmate_mrft if schattend_ever==1,obs svy:tab sv4_schoolmate_mrft,obs svy:tab sv4_schoolmate_mrft if schattend_ever==1,obs *Now we can generate a variable for the first or most recent experience of any SV being by a classmate/schoolmate gen sv_schoolmate_mrft=0 replace sv_schoolmate_mrft=1 if inlist(1, sv1_schoolmate_mrft, sv2_schoolmate_mrft, sv3_schoolmate_mrft, sv4_schoolmate_mrft) svy:tab sv_schoolmate_mrft,obs ci // denominator is the full sample svy:tab sv_schoolmate_mrft if schattend_ever==1,obs ci // denominator is those who have ever attended school **************************************************** *Sexual violence perpetrated by teacher **************************************************** *For each type of of SV1-SV4, we can then create a variable both first and most recent time experience of SV being perpetrated by a teacher. *SV1 - most recent gen sv1_teacher_mr=0 replace sv1_teacher_mr=1 if q605==10 | q605==27 tab sv1_teacher_mr q605 svy:tab sv1_teacher_mr,obs *SV1 - first time gen sv1_teacher_ft=0 replace sv1_teacher_ft=1 if q612==10 | q612==27 tab sv1_teacher_ft q612 svy:tab sv1_teacher_ft,obs *SV1 - first or most recent time from a teacher gen sv1_teacher_mrft=0 replace sv1_teacher_mrft=1 if inlist(1,sv1_teacher_mr, sv1_teacher_ft) *SV2 - most recent gen sv2_teacher_mr=0 replace sv2_teacher_mr=1 if q705==10 | q705==27 tab sv2_teacher_mr q705 svy:tab sv2_teacher_mr,obs *SV2 - first time gen sv2_teacher_ft=0 replace sv2_teacher_ft=1 if q712==10 | q712==27 tab sv2_teacher_ft q712 svy:tab sv2_teacher_ft,obs *SV3 - first or most recent time from a teacher gen sv2_teacher_mrft=0 replace sv2_teacher_mrft=1 if inlist(1,sv2_teacher_mr, sv2_teacher_ft) *SV3 - most recent gen sv3_teacher_mr=0 replace sv3_teacher_mr=1 if q805==10 | q805==27 tab sv3_teacher_mr q805 svy:tab sv3_teacher_mr,obs *SV3 - first time gen sv3_teacher_ft=0 replace sv3_teacher_ft=1 if q813==10 | q813==27 tab sv3_teacher_ft q813 svy:tab sv3_teacher_ft,obs *SV3 - first or most recent time from a teacher gen sv3_teacher_mrft=0 replace sv3_teacher_mrft=1 if inlist(1,sv3_teacher_mr, sv3_teacher_ft) *SV4 - most recent gen sv4_teacher_mr=0 replace sv4_teacher_mr=1 if q905==10 | q905==27 tab sv4_teacher_mr q905 svy:tab sv4_teacher_mr,obs *SV4 - first time gen sv4_teacher_ft=0 replace sv4_teacher_ft=1 if q912==10 | q912==27 tab sv4_teacher_mr q912 svy:tab sv4_teacher_ft,obs *SV4 - first or most recent time from a teacher gen sv4_teacher_mrft=0 replace sv4_teacher_mrft=1 if inlist(1,sv4_teacher_mr, sv4_teacher_ft) *Now let's tabulate each of these variables svy:tab sv1_teacher_mrft,obs // denominator is full sample svy:tab sv1_teacher_mrft if schattend_ever==1,obs ci // denominator is those who have ever attended school svy:tab sv2_teacher_mrft,obs svy:tab sv2_teacher_mrft if schattend_ever==1,obs ci svy:tab sv3_teacher_mrft,obs svy:tab sv3_teacher_mrft if schattend_ever==1,obs ci svy:tab sv4_teacher_mrft,obs svy:tab sv4_teacher_mrft if schattend_ever==1,obs ci *Now we can generate a variable for the first or most recent experience of any SV being by a teacher gen sv_teacher_mrft=0 replace sv_teacher_mrft=1 if inlist(1, sv1_teacher_mrft, sv2_teacher_mrft, sv3_teacher_mrft, sv4_teacher_mrft) svy:tab sv_teacher_mrft,obs ci // denominator is full sample svy:tab sv_teacher_mrft if schattend_ever==1,obs ci // denominator is those who have ever attended school ********************** *Any SRGBV ********************** *Now we can create a variable for the first or most recent experience of PV or SV being from classmate/schoolmate or teacher gen pv_sv_schoolmate_mrft=0 // any physical or sexual violence from a classmate/schoolmate replace pv_sv_schoolmate_mrft=1 if pv2_schoolmate_mrft==1 | sv_schoolmate_mrft==1 svy:tab pv_sv_schoolmate_mrft,obs svy:tab pv_sv_schoolmate_mrft if schattend_ever==1,obs ci gen pv_sv_teacher_mrft=0 // any physical or sexual violence from a teacher replace pv_sv_teacher_mrft=1 if pv4_teacher_mrft==1 | sv_teacher_mrft==1 svy:tab pv_sv_teacher_mrft,obs svy:tab pv_sv_teacher_mrft if schattend_ever==1,obs ci gen pv_sv_srgbv_mrft=0 // any physical or sexual violence from a classmate/schoolmate or teacher replace pv_sv_srgbv_mrft=1 if pv_sv_schoolmate_mrft==1 | pv_sv_teacher_mrft==1 svy:tab pv_sv_srgbv_mrft,obs svy:tab pv_sv_srgbv_mrft if schattend_ever==1,obs ci