70 likes | 190 Views
Multiple Indicator Cluster Surveys Data Processing Workshop. Tables in MICS5. Secondary Data Processing Flow. Export Data from CSPro. Import Data into SPSS. Recode Variables. Add Sample Weights, Wealth Index, and GPS Data. Run Tables. Before running tables. Check frequencies Run
E N D
MICS Data Processing Workshop Multiple Indicator Cluster SurveysData Processing Workshop Tables in MICS5
Secondary Data Processing Flow Export Data from CSPro Import Data into SPSS Recode Variables Add Sample Weights, Wealth Index, and GPS Data Run Tables
Before running tables • Check frequencies • Run • Make.sps • Weight syntaxes (and excel calculation) • Wealth index syntax
Tabulation Guidelines • Final Report Template • MICS5 recommended tabulations • Will be available at www.childinfo.org • Spss syntax files, • Excel table templates • Final report template for tables
Tabulation Programs • One program for each tabulation • Tables named ##.##.SPS • Topics (HH, CM, NU, CH, WS, RH, CD, ED, CP, HA, MT, SW, TA) • Check each table program carefully • If missing variables, may have to remove table • May want to modify tables to include country-specific variables • Check categories, combine if necessary • Check unweighted numbers for category totals
Tabulation Guidelines • MICS Indicator # • Millennium Development Goal Indicator # • Notes on calculations
Tabulation Programs • Prepare table templates for any additional variables included in the survey (this should ideally be prepared during the questionnaire design stage!) • Prepare syntax files programs for tables based on country- specific variables