MICS Data Processing Workshop

1. MICS Data Processing Workshop The Data Dictionary and Forms

2. Questionnaire Types • There are three types of questionnaire • Household • Women • Children • Each type has core, additional and optional modules

3. Identification Variables

4. Module Naming Conventions • Each module corresponds to a record • A record’s name is MODXX • where XX is the module’s code • For example, the child mortality module is named MODCM • Two exceptions: • Household listing stored in MODHL and MODTO • Orphaned children stored in MODOV and MODOR

5. Repeating Modules • There are 6 repeating modules • Household listing • Education • Orphaned and vulnerable children • Child labour • Disability • Maternal mortality • Stored as repeating records

6. Variable Naming Conventions • Variables are named for • Their module • Their number • Question 5 in the HL module is named • HL5 • Next slide describes the only exceptions to this rule

7. Source and Response Variables • A few questions have two parts • 1st part is the source of the response • 2nd part is the response • Questions stored in two variables • Source has letter A as a postfix • Question 2 of the AN module • AN2A – lying or standing up • AN2 – height

8. Subitems • CSPRO allows one to define subitems • A subitem is a portion of a variable (or item) • Both the item and the subitem can be referred to in an application • We make extensive use of subitems • The situations in which we use them are described in the next four slides

9. Multiple Response Questions • There are many multiple response questions • Interviewer can circle more than one code • e.g. question 2 of MN module • These variables are stored as alphanumeric variables whose width is the number of responses • For each response there is a subitem whose name is the variables name plus the response’s code • For example, response A to MN2 is stored in subitem MN2A

10. Date Variables • Date variables with several parts (e.g., month and year) are stored in a single variable • The single variable has a subitem for each part of the date • The subitems are named using the module, question number and D, M or Y • e.g., the day of household interview is stored in subitem HH5D

11. Unit and Number Variables • A few questions have two parts where the • 1st part is the form of the response (i.e., the units) • 2nd part is the response (i.e., the number) • These variables are stored in a single variable with subitems • subitems have U and N prefixes in their names • Example: question 13 of the MN module • MN13U - hours or days • MN13N - number of hours or days

12. Level and Grade Variables • In the ED module, 3 questions record level and grade • Stored in single variable with subitems • Level subitem has A prefix • Grade subitem has B prefix • Example: question 3 of ED module • ED3A - highest level • ED3B - highest grade at that level

13. Coding Conventions

14. Dictionary and Form Modifications • Work in CSPRO on Form File! • Add/remove modules and variables to dict. • Modify variable characteristics if necessary • e.g., lengths, ranges and variable and value labels • Update forms to reflect dictionary changes • Reorder form’s flow (if variables added)