multiple indicator cluster surveys data processing workshop
Skip this Video
Download Presentation
Multiple Indicator Cluster Surveys Data Processing Workshop

Loading in 2 Seconds...

play fullscreen
1 / 20

Multiple Indicator Cluster Surveys Data Processing Workshop - PowerPoint PPT Presentation

  • Uploaded on

Multiple Indicator Cluster Surveys Data Processing Workshop. Creating Analysis Files: Description of Preparation Steps. Secondary Data Processing Flow. Export Data from CSPRO. Import Data into SPSS. Recode Variables. Add Sample Weights, Wealth Index and GPS Data. Run Tables.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about ' Multiple Indicator Cluster Surveys Data Processing Workshop' - janna-ryan

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
secondary data processing flow
Secondary Data Processing Flow

Export Data from CSPRO

Import Data into SPSS

Recode Variables

Add Sample Weights, Wealth Index and GPS Data

Run Tables

importing data to spss
Importing Data to SPSS
  • Executing syntax files created by CSPRO
  • In SPSS, run all my*.spsfiles (one by one)
    • The my*.spsfiles will import the data into SPSS and create SPSS-format data files (system files - *.sav), with variable labels, value labels etc.
  • At the end of each run, save your work in data files as hh.sav, hl.sav, wm.sav, mn.sav, ch.savtn.sav, fg.sav, bh.sav, mm.sav
saving the data file
Saving the Data File
  • It is helpful to have the syntax file automatically save the data file that it creates
  • To do so, add the following line to the end of the syntax file:

save outfile = \'hh.sav\'.

run frequency distributions
Run frequency distributions
  • Open SPSS and run frequency distributions for all of the variables in all .sav files
  • Detect any unexpected codes or inconsistencies, and if necessary, return to CSPro and make corrections.
next steps
Next Steps
  • Recoding variables
    • Creating new variables by recoding existing variables
    • Adding variables to different levels
      • Mother’s education
      • Father’s education
customize make sps
Customize make*.sps
  • Customize the make*.sps syntax files, in accordance with the contents of your questionnaires
  • Take out any variables and associated syntax which are not included in your questionnaire, or modify the variables according to your response categories
run make sps
Run make.sps
  • Run make.sps to recode all additional variables needed for the tabulations
  • make.sps is provided as a batch file which calls and runs each of the make*.spsfiles in turn
  • All *.savvariables will be replaced!
  • Backup before you proceed to this stage
next steps1
Next Steps
  • Adding sample weights
    • Sample weights are added from weights spreadsheet
calculate weights
Calculate weights
  • Obtain distribution of interview results by the unit based on which you intend to calculate unique sample weights:

- using the weights_table.sps syntax file, if calculation at cluster level

- using the weights_table_alt.sps syntax file, if calculation at stratum level, e.g. regions and area

calculate weights cont
Calculate weights cont.
  • Calculate final sample weights
  • using weights.xls, if calculations are carried out at the cluster level
  • weights_alt.xls, if calculations are carried out at stratum level
calculate weights cont1
Calculate weights cont.
  • Once calculations in weights.xls or weights_alt.xls have been completed, save the “Output” workbook
    • c:\mics5\weights\weights.xls
append sample weights
Append sample weights
  • Append sample weights to the exported SPSS files hh.sav, hl.sav, wm.sav, ch.sav (tn.sav, fg.sav, bh.sav and mm.sav if relevant modules included), by using the SPSS weights_merge.sps or weights_merge_alt.sps syntax file
    • Need customization if ITN, Birth History modules or Men questionnaire included
next steps2
Next Steps
  • Adding wealth index
    • Wealth index calculated then added to files
customize wealth sps
Customize wealth.sps
  • Customize the wealth.sps syntax file that calculates wealth index values, together with the survey coordinator/technical manager, according to the items included in your questionnaire
run and append wealth
Run and append wealth
  • Run the customized SPSS syntax wealth.sps to calculate and append wealth index values to all of the exported data files
next steps3
Next Steps
  • Tabulation
    • Tables are generated from the *.sav files
customize each syntax
Customize each syntax
  • Customize all tabulation syntax files in accordance with the contents of your survey
  • Delete the syntax files which are used to obtain tables on topics which are not included in your survey
run all tables sps
Run all_tables.sps
  • Once all tabulation syntax files are customized and free of errors, customize all_tables.sps
  • all_tables.sps calls and runs all tabulation syntax files, and produces an output which includes all tables
  • If any of the tabulation syntax files have errors, the program will stop and you will have to correct the tabulation syntax file. Then re-run all_tables.sps