1 / 19

Multiple Indicator Cluster Surveys Data Processing Workshop

Multiple Indicator Cluster Surveys Data Processing Workshop. Exporting data from CSPro to SPSS. Secondary Data Processing Flow. Export Data from CSPro. Import Data into SPSS. Recode Variables. Add Sample Weights, Wealth Index, and GPS Data. Run Tables. MICS Data Processing Workshop.

wells
Download Presentation

Multiple Indicator Cluster Surveys Data Processing Workshop

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MICS Data Processing Workshop Multiple Indicator Cluster SurveysData Processing Workshop Exporting data from CSPro to SPSS

  2. Secondary Data Processing Flow Export Data from CSPro Import Data into SPSS Recode Variables Add Sample Weights, Wealth Index, and GPS Data Run Tables MICS Data Processing Workshop

  3. Secondary Data Processing • Exporting data from CSPro • Create SPSS data file and syntax file from CSPRO data file and dictionary • Importing data to SPSS • Executing syntax file created by CSPro • Recoding variables • Creating new variables and recoding old variables MICS Data Processing Workshop

  4. Secondary Data Processing • Adding sample weights • Sample weights are added from weights spreadsheet • Adding wealth index • Wealth index calculated then added to files • Adding GPS data • Geographic location data added to files • Tabulation • Tables are generated from the analysis files MICS Data Processing Workshop

  5. The Export Application • A batch application • uses export tocommand • Creates SPSS data and description files for nine types of cases: MICS Data Processing Workshop

  6. The Household (HH) Export • Syntax: export to myHH HH1, HH2, { ID vars } MODHH, MODSL, MODCL, MODCD, MODHC, MODIR, MODWS, MODHW, MODSI, HHSex; • Creates • c:\mics5\spss\myHH.sps • c:\mics5\spss\myHH.dat MICS Data Processing Workshop

  7. The Household (HH) Export • HHSex: recoded variable that was created using information from the Household Listing: HHSex = notappl; if HH9 = 1 then HHSex = HL4(1); endif; MICS Data Processing Workshop

  8. Exporting a Household Member • Household members data stored in rosters • Must export correct data from each roster for each household member • For each: • export data using occurrence numbers MICS Data Processing Workshop

  9. The Household Member (HL) Export export to myHL HH1, HH2, MODHL(hloccur), MODED(edoccur), MODTN(tnoccur), HH5D, HH5M, HH5Y, HH6, HH7, mline, fline; MICS Data Processing Workshop

  10. The Insecticide Nets (TN) Export • Syntax: for i in MODTN_EDT do export to myTN HH1, HH2, { ID vars } MODTN, TN2, HH6, HH7; enddo; • Creates • c:\mics5\spss\myTN.sps • c:\mics5\spss\myTN.dat MICS Data Processing Workshop

  11. The Woman (WM) Export • Syntax: if HL7(LN) > 0then export to myWM HH1, HH2, LN, { ID vars} MODWM, MODWB, MODMT, MODCM, MODDB, MODMN, MODPN, MODIS, MODCP, MODUN, MODFG, MODDV, MODMA, MODSB, MODHA, MODTA, MODLS, MODTN(tnoccur), HH6, HH7, wdob, wdom, wagem, wdobfc, wdoblc, mstatus, ceb, csurv, cdead; { Recoded variables } endif; • Creates • c:\mics5\spss\myWM.sps • c:\mics5\spss\myWM.dat MICS Data Processing Workshop

  12. The Female Genital Cutting(FC) Export • Syntax: if WM7 = 1 then for i in MODFC_EDT do export to myFC HH1, HH2, LN, { ID vars } FG1, FG3, FG9, MODFC (i), HH6, HH7 enddo; endif; • Creates • c:\mics5\spss\myFC.sps • c:\mics5\spss\myFC.dat MICS Data Processing Workshop

  13. The Birth History (BH) Export • Syntax: for i in MODBH_EDT do export to myBH HH1, HH2, LN, { ID vars } MODBH(i), wdoi, wdob; { Recoded variables } enddo; • Creates • c:\mics5\spss\myBH.sps • c:\mics5\spss\myBH.dat MICS Data Processing Workshop

  14. Maternal Mortality (MM) Export • Syntax: for i in MODMM_EDT do export to myMM HH1, HH2, LN { ID vars } MM1, MM3, MMLN (i), HH6, HH7; enddo; • Creates • c:\mics5\spss\myMM.sps • c:\mics5\spss\myMM.dat MICS Data Processing Workshop

  15. The Man (MN) Export • Syntax: if HL7A(LN) > 0then export to myMN HH1, HH2, LN, { ID vars } MODMWM, MODMWB, MODMMT, MODMCM, MODMDV, MODMMA, MODMSB, MODMHA, MODMMC, MODMTA, MODMLS, MODTN(tnoccur), HH6, HH7, mndoi, mndob, mnage, mndom, mnagem, mndoblc, mmstatus, mceb, mcsurv, mcdead;{ Recoded variables } endif; • Creates • c:\mics5\spss\myMN.sps • c:\mics5\spss\myMN.dat MICS Data Processing Workshop

  16. The Child (CH) Export • Syntax: if HL9(LN) > 0then export to myCH HH1, HH2, LN, { ID vars } MODUF, MODAG, MODBR, MODEC, MODBD, MODIM, MODHF, MODCA, MODAN, Anthro_Vars, MODTN(tnoccur), HH6, HH7, HL4(UF4), ED4A(UF6), ED4B(UF6), cdoi, cdob, cage, cage_6, cage_11, caged; endif; • Creates • c:\mics5\spss\myCH.sps • c:\mics5\spss\myCH.dat MICS Data Processing Workshop

  17. Secondary Data Processing Flow Export Data from CSPro Import Data into SPSS Recode Variables Add Sample Weights, Wealth Index and GPS Data Run Tables MICS Data Processing Workshop

  18. Reading the Data Into SPSS • To read one of the exported data files into SPSS: • Start SPSS • Open the syntax file associated with the data file • Execute the syntax file • run --> all 4. Save the file as XX.SAV • where XX is HH, HL, TN, WM, FC, BH, MM, MN or CH MICS Data Processing Workshop

  19. 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'. MICS Data Processing Workshop

More Related