indicators212hhcom
212hhcom 时间:2021-04-06 阅读:()
StepstoconstructingthenewDHSWealthIndexSheaO.
Rutstein,PhD.
Step0:Thewealthindexisbasedonhouseholddata.
However,therearethreevariablesthatmaybecreatedfromtheindividualinterviewfile:whetherthehouseholdhasoneormoredomesticservants("Domestic"),whetheranyhouseholdmemberworkstheirownortheirfamiliesagriculturalland("Land"),andwhetheranyhouseholdmemberownsadwellingunit("House").
Determineifthesurveythatwillbeusedisrawdataorstandardrecode.
Createafolderforthewealthindexprocess.
Downloadthedatadictionariesanddatafilesforthehouseholdandindividualquestionnaires.
IuseCSPRO,whichhasthehierarchicalfile.
Ifthereisaman'squestionnaire,downloadthatdictionaryanddataaswell.
Step1:Reviewthequestionnaireanddatadictionaryforthehouseholdsurvey(aswellasanyotherdocumentationsuchafrequencies,recodedoc.
)todeterminewhichvariablesaretobeusedforthewealthindex,includingcountry-specificvariables.
Normallyincludedare:Sourceofdrinkingwater,typeoftoilet,sharingoftoiletfacilities,materialofprincipalfloor,walls,roof,cookingfuel,householdservicesandpossessions,suchaselectricity,TV,radio,watch,typesofvehicles,agriculturallandsizeowned,typeandnumberofanimalsowned,bankaccount,typesofwindows.
Theitemsvarysomewhatbetweensurveysaswellasthecategoriesofthecorequestionnaireitems.
Alloftheseitemswillbeusedtodistinguishonehouseholdfromanothersothat"lumpiness"inthewealthdistributionisreduced.
However,sincethewealthindexisanindicatorofthehousehold'seconomicstatus,typeofarea,levelofeducation,occupation(otherthandomesticservant),areNOTincludedsincetheyaredeterminantsofhealthstatusintheirownrightandareusedalongwiththewealthindex.
Step2:Createthethreevariables,Domestic,Land,HousefromtheindividualdataandexportallrelevantvariablestoSPSS,alongwiththehouseholdID.
2a:CreatethevariablesDOMESTIC,LAND,ANDHOUSE.
Therevarioussourcesofinformationdependingonthesurveyanditscodes.
DOMESTIC:Atthehouseholdlevel,setDOMESTIC=0.
Ifthereisacodefordomesticservantintherelationshiptotheheadofthehouseholdvariable(HV101inthehouseholdstandardrecodefile),gothroughthehouseholdmembersandsetDOMESTIC=1ifanymemberhasthatcode.
Iftherelationshiptotheheadofthehouseholddoesnothaveacodefordomesticservant,gothroughtheindividualdatafileusingthewoman'soccupation(V717inindividualstandardrecode).
Ifshehascode6("Householdanddomestic")andherrelationshiptotheheadofthehouseholdis"notrelated",thesetDOMESTIC=1.
WherethepropercodesareavailableinV716,thatvariablecanalsobeused.
Alsocheckcountry-specificoccupationsfordomesticandhouseholdworkercategoriesorusepersonalservicesifthedomesticandhouseholdworkeroccupationisnotgiveninanyofthevariables.
Forrawdataindividualfiles,thepropercodesneedtobeused.
Thenrepeatforthewoman'spartner(V704andV705individualrecode)andcheckingtomakesureheisunrelatedtotheheadofthehousehold.
Ifthereisaman'squestionnaire,dothesameusingtheappropriatevariablesfromthemen'sindividualdata.
NotethatDOMESTICiscodedeither0(nodomesticservant)or1(domesticservant),nomatterhowmanyservantsareinthehouseholdorthesourceoftheinformation.
Alsonotethatalldomesticservantsshouldnotberelatedtotheheadofthehousehold.
LAND:SetLAND=0.
Usingthewomen'sandmen'sindividualdatasets,setLAND=1ifthewomanworksherownorfamily'sland(inthestandardrecode,V740=0or1).
AlsosetLAND=1,ifthemanworkshisownorfamily'sland.
Besuretocheckforcountry-specificquestionsonlandownership.
Note:ifagriculturallandownershipisaskedaboutinthehouseholdquestionnaire,donotusethecreatedLandvariable.
HOUSE:SetHOUSE=0.
Ifthereisacountry-specificitemonownershipofdwellingintheindividualwoman'sormen'sindividualquestionnaire,setHOUSE=1.
Additionalvariablesthatneedtobecreatedifusingtherawdatafiles:HV009,HV012,HV013:HV009isthenumberofpersonslistedinthehouseholdschedule(usuallyqhsec01).
HV012isthenumberofdejurepersonslistedinthehouseholdschedule(usuallyqhsec01whereqh05=1).
HV013isthenumberofdefactopersonslistedinthehouseholdschedule(usuallyqhsec01whereqh06=1).
Notes:1.
Forrawdatafiles,theappropriatevariablesandcodeswillhavetobeuseduponreviewingthequestionnaires.
2.
Thesevariablesmayalsobecreatedusingnon-hierarchicalfilesbyaggregatingovertheindividualdatabelongingtothesamehousehold.
2b.
Exportthecreatedvariablesandhouseholddatanecessaryforcreatingthewealthindex.
ExportthevariablesforthehouseholdID(HHIDinthestandardrecode),urban-rurallocation,householdweight,HV009,HV012,HV013,thehouseholdcharacteristics(RECH1andRECH3inthestandardrecodeandqhsec02intherawdatafile),andDOMESTIC,LAND,andHOUSE.
Beforeexporting,selectforinterviewedhouseholds(HV015=1inthestandardrecode,QHRESULT=1intherawdata).
Step3:ImportthedatafileintoSPSS(orotherdataanalysisprogramcapableoffactororprincipalcomponentsanalysis)andcreatethewealthindexindicatorvariables.
Assignvariableandvaluelabelstoeachofthecreatedindicatorvariables.
3a:Importthedatafileandsaveitunderanewnamesuchasassetsxxnn.
sav,wherexxisthecountrycodeandnnisthesurveyyear.
3b:Indicatorconstruction1.
Runfrequenciesforallcategoricalvariablestobeusedinthefactoranalysis(alsoknownasprincipalcomponentsanalysis—PCA).
BasetheconstructionofthePCAindicatorvariablesonthesefrequenciessincenotallcategoriesmayhavebeenused.
Thereisnoneedtoconstructindicatorvariablesforemptycategories.
Alsonotewhetherthereareadditionalcategoriestothoseinthequestionnairesincesomemayhavebeencreatedatthedataentrystagefrom"other"answers.
2.
Fromcategoricalvariables,suchassourceofdrinkingwater,roofingmaterials,etc.
,generatedichotomous(0-1)variablesforeachcategoryofthecategoricalvariables.
Settheindicatorvariableto1ifhouseholdisinthatcategoryand0otherwise.
The"other"categoryismadeintoanindicatorvariablebutthemissingandDKcategoriesarenot.
Specificvariableinstructions:a.
Sourceofdrinkingwater—eachcategoryisaseparateindicatorvariableexceptthatsurfacewatersources(lakes,ponds,rivers,streams,etc.
)iscombinedintooneindicatorvariableiftheyareseparatecategories.
b.
Typeoftoiletandsharingoftoilets—therehavebeentwoapproachesused.
Thefirstistocreateindicatorvariablesforeachtypeoftoiletcategoryandaseparateindicatorvariableforwhetherthetoiletissharedwithotherhouseholds(1ifshared,0ifnotsharedorquestionisnotapplicable).
Thesecondapproachistocreateasetofindicatorvariablesforeachcategoryoftoiletthatisshared.
Forexampleinthisapproach,thereisanindicatorvariablefornon-sharedflushtoiletconnectedtothesewersystemandanotherforsharedflushtoiletconnectedtothesewersystem,sothatthehouseholdhasa1valueforonlyoneoftheindicatorvariables.
Inthisapproachthesharedtoiletvariableshouldnotbeusedintheprincipalcomponentsanalysis.
Thissecondapproachprovidesslightlymoreinformationonwhichtobasethewealthindexbuttheeffectisnotlarge.
c.
Typeoffloor,wall,androofmaterials—Naturalmaterialsareusuallycombinedintoasinglematerial—earth,sand,dungfloors;cane,palmleaves,sodroofs;andcane,palm,trunks,brushandmudwalls.
3.
Useofyes-nooriginalvariables,whetherstandardorcountry-specific—thesevariablesarerecodedsothata1indicatesifthehouseholdhasa"yes"answertothequestionand0ifitdoesnothavea"yes"answer.
The0categoryincludes"no"answers(coded0instandardrecodedatasetsand2inrawdatasets),missing,DKandnotapplicableresponses.
4.
Memberspersleepingroom—ThisvariableisacontinuousvariableinthePCA.
Toconstructmemberspersleepingroomdividethenumberofdejuremembers(HV012)bythenumberofsleepingrooms(HV216inthestandardrecode).
Iftherearenodejuremembers,usethenumberofdefactomembersinstead.
(Noteiftherearenodefactomembers,thenthehouseholdshouldhavebeenexcludedfromtheanalysisdataset).
Ifthenumberofsleepingroomsiszero,thensetthenumberofsleepingroomstoonesincehouseholdmembershavetosleepsomewhere.
Ifthequestiononsleepingroomsisnotaskedbutaquestiononnumberofroomsisasked,usethatquestioninstead.
IfthenumberofsleepingroomsorpersonsismissingorDK,setthevalueofthevariabletomissing.
(MeansubstitutionformissingvalueswillbeusedinthePCA.
)5.
Agriculturalland—InlaterDHSsurveys,whetherthehouseholdownedagriculturallandandtheamountoflandownedwasasked.
Ifthisisthecase,createacontinuouslandareavariableforthePCAindicatingtheamountowned.
Ifthehouseholddoesnotownagriculturallandthencode0inthelandareaindicatorvariable.
Insomesurveys,theunitofmeasurementvariesandwillhavetobeconvertedtoasingleunit.
Iftheamountismissingthenthecreatedlandareavariableissettomissing.
6.
Farmanimals(livestock)—AlsoinlaterDHSsurveys,householdswereaskedwhethertheypossessedfarmanimalsandifsothenumbersofdifferenttypeswereasked,thetypesvaryingbycountry.
Similarlytoagriculturalland,codeacontinuousindicatorvariableforeachtypeoffarmanimal.
Allfarmanimalindicatorvariablesshouldbesetto0ifthehouseholdhasnofarmanimals.
IfthenumbersofeachtypeofanimalismissingorDK,thensettheindicatorvariabletomissing.
Thereshouldbeno'notapplicable'codeforthefarmanimalindicatorvariablessincethiscodeisincorporatedas0.
7.
Runthefrequenciesonallthecreatedindicatorvariables,comparewiththeoriginalfrequencies,andcorrectanydiscrepancies.
8.
Savethedatafileandsyntaxfile.
Step4:GenerationofhouseholdwealthscoresTherearefoursubstepstogeneratingthehouseholdwealthscores.
Allarerunwithnoweights.
4a:Eliminationofindicatorvariableswithnovariation,usuallyduetonocases.
Putallindicatorvariablesintoafactoranalysis,makingsurethattheoptionforunivariatedescriptivesisused(/PRINTUNIVARIATEinSPSS).
Iftheanalysisfails,checkthestandarddeviationforeachindicatorvariableanddeletefromthefactoranalysissyntaxallvariableswithzerostandarddeviation,meaningthatthereisnovariationforthatvariable.
Alsocheckthemissingvaluenumberofcasestomakesurethattherearenounexpectednumbers,rememberingthatsmallnumbersofmissingsmaybeexpectedforafewoftheindicatorvariables,especiallythecontinuousvariables,whichwillbeassignedthemeanvalueforthatvariable.
4b:FactoranalysisofcommonvariablesForthecommonwealthscore,usingtheindicatorvariablessuccessfullyruninstep4a,selectthesubsetindicatorvariableswhicharethoughttohavethesamerelationshipwiththeunderlyingeconomicstatusdimensioninbothurbanandruralareasandselectoutthosethatdonotapplytooneoranotherareaorarethoughttoindicatedifferentlevelsofwealth.
Anexampleisnumberofchickenssincehavingafewchickensinanurbanareamayindicateapoorurbanhouseholdcomparedtothosewithnochickenswhileinruralareashavingsomechickensmayindicateahouseholdthatiswealthierthanonewithnochickens.
Theselectionofwhichvariablestobeincludedinthecommonfactoranalysisisbasedonone'sunderstandingandexperience.
Thefactoranalysisshouldberunwiththefollowingoptions:principalcomponentsextractionusingcorrelationmethodwithonefactorextracted,substitutionofmeanformissingvalues,estimationofthefactorscoresusingtheregressionmethod,savingofthefactorscoresforeachhouseholdontothedatafileusingthenameCOM,printingofunivariatedescriptives,initialandextractedcommunalities,andfactorscorecoefficient.
Thedatashouldbeunweighted.
4c.
FactoranalysisforurbanareasFortheurbanwealthscore,firstselectthecasesofthedatafileforurbanareas.
Thenfortheurbanfactoranalysis,,selectthesubsetindicatorvariableswhicharethoughttoberelevanttourbanareasagainusingtheindicatorvariablessuccessfullyruninstep4a.
Rural-typeindicatorsmayalsoberelevantinurbanareasbutwithadifferentrelationshiptowealth.
Theselectionofwhichvariablestobeincludedintheurbanfactoranalysisisagainbasedonone'sunderstandingandexperience.
Runthefactoranalysisasforthecommonvariablesin4b.
abovebutchangingthenameofthesavedfactorscorevariabletoURB.
Ifanindicatorvariablehasnostandarddeviation,itshouldbedeletedfromtheanalysis.
Thedatashouldbeunweighted.
4d.
RepeatfactoranalysisforruralareasRemembertostartwiththevariablelistfromstep4asincesomeindicatorvariablesmayberelevantforruralareaseventhoughtherearenocasesforurbanareas.
Step5:EstimationofcompositewealthscoresSavethesyntax,dataandoutputfiles.
Thefactorscorevalueswillnowbeinthedatasetfromthecommonvariables(COM1inSPSS)forallcases,fromtheurbanfactoranalysis(URB1)inthesetofcasesinurbanareaswithmissingvaluesforruralareas,andfromruralfactoranalysis(RUR1)intheruralsetofcaseswithmissingvaluesforurbanareas.
Theurbanandruralwealthscoreswillberegressedonthecommonwealthscorestoobtaintheparameterstoestimatethecompositewealthscore.
5a.
UrbanandruralregressionsSelecturbanareacases.
Runaregressionwiththecommonfactorscore(COM1)asthedependentvariableandtheurbanareafactorscore(URB1)astheindependentvariable.
Thedatashouldbeunweighted.
Notetheconstanttermandthecoefficient.
Alsocheckthesignificanceoftheregressionandterms.
Theyshouldbehighlysignificant.
Repeatforruralareasselectingruralcasesusingtheruralareafactorscore(RUR1)astheindependentvariable.
5b.
CalculatecombinedscoreUsingallcases,firstmakeanewvariableforthecombinedscore,COMBSCOR,withfivedecimalplacesandsetitequalto0.
Thenforeachareacalculatethecombinedscoreusingtheappropriateurbanorruralfactorscores,constantsandcoefficientsobtainedinsubstep5a.
Step6:Calculatethewealthquintilesandtheircutpoints.
6a.
CalculateweightednumberofhouseholdmembersMultiplythenumberofdejurehouseholdmembersbythehouseholdsamplingweightdividedby1,000,000toobtainavariablecalledHHMEMWT.
SettheanalysissampleweightequaltoHHMEMWT.
Iftherearenodejuremembers,usethenumberofdefactohouseholdmembers.
6b.
Dividethefactorscoresintofiveequalparts(quintiles)Therearetwowaystoachievethequintiles.
Usingtheappropriatewealthscore,determinetheweightedcumulativepercentagedistributionofthewealthscore,determinethewealthscorevaluesthatcorrespondtothefourcutpointvaluesofthequintiles(1thenskipcase;endif;hv012=0;hv013=0;hv009=soccurs(qhsec01);i=1;whilei=1andq826a=1andq826b0)memsleep=trunc(hv012/qh117).
if(qh117=0)memsleep=hv012.
if(memsleep>=98)memsleep=98.
VARIABLELABELSMEMSLEEP"Numberofmemberspersleepingroom".
valuelabelsmemsleep0'Lessthan1perroom'.
*{Drinkingwatersupply}.
computeh2oires=0.
if(qh102=11)h2oires=1.
varlabelsh2oires"Pipedintodwelling".
computeh2oyrd=0.
if(qh102=12)h2oyrd=1.
varlabelsh2oyrd"Pipedintoyard/plot".
computeh2opub=0.
if(qh102=13)h2opub=1.
varlabelsh2opub"Publictap/standpipe".
computeh2obwell=0.
if(qh102=21)h2obwell=1.
varlabelsh2obwell"Tubewellorborehole".
computeh2ipwell=0.
if(qh102=31)h2ipwell=1.
varlabelsh2ipwell"Protecteddugwell".
computeh2iowell=0.
if(qh102=32)h2iowell=1.
varlabelsh2iowell"Unprotecteddugwell".
computeh2opspg=0.
if(qh102=41)h2opspg=1.
varlabelsh2opspg"ProtectedSpring".
computeh2ouspg=0.
if(qh102=42)h2ouspg=1.
varlabelsh2ouspg"UnprotectedSpring".
computeh2orain=0.
if(qh102=51)h2orain=1.
varlabelsh2orain"Waterfromrain".
computeh2otruck=0.
if(qh102=61)h2otruck=1.
varlabelsh2otruck"Waterfromtankertruck".
computeh2ocart=0.
if(qh102=71)h2ocart=1.
varlabelsh2ocart"Waterfromcartwithsmalltank".
computeh2osurf=0.
if(qh102=81)h2osurf=1.
varlabelsh2osurf"Surfacewater-river,lake,dam,etc.
".
computeh2obot=0.
if(qh102=91)h2obot=1.
varlabelsh2obot"Waterfrombottle".
computeh2ooth=0.
if(qh102=96)h2ooth=1.
varlabelsh2ooth"Otherwatersource".
*{Toiletfacility}.
computeflushs=0.
if(qh107=11)flushs=1.
varlabelsflushs"Flushtoilettosewer".
computeflusht=0.
if(qh107=12)flusht=1.
varlabelsflusht"Flushtoilettoseptictank".
computeflushp=0.
if(qh107=13)flushp=1.
varlabelsflushp"Flushtoilettopitlatrine".
computeflushe=0.
if(qh107=14orqh107=15)flushe=1.
varlabelsflushe"Flushtoilettoelsewhere".
computelatvip=0.
if(qh107=21)latvip=1.
varlabelslatvip"VIPlatrine".
computelatpits=0.
if(qh107=22)latpits=1.
varlabelslatpits"Pitlatrinewithslab".
computelatpit=0.
if(qh107=23)latpit=1.
varlabelslatpit"Traditionalpitlatrine".
computelatcomp=0.
if(qh107=31)latcomp=1.
varlabelslatcomp'Compostingtoilet/ecosan'.
computelatpail=0.
if(qh107=41)latpail=1.
varlabelslatpail'Buckettoilet'.
computelathang=0.
if(qh107=51)lathang=1.
varlabelslathang'Hangingtoilet/latrine'.
computelatbush=0.
if(qh107=61)latbush=1.
varlabelslatbush"Nofacility/bush/field".
computelatoth=0.
if(qh107=96)latoth=1.
varlabelslatoth'Othertypeoflatrine/toilet'.
computelatshare=0.
if(qh108=1)latshare=1.
varlabelslatshare'Shareslatrine/toiletwithotherhouseholds'.
*{Flooring}.
computedirtfloo=0.
if(qh114=11orqh114=12)dirtfloo=1.
varlabelsdirtfloo"Earth,sand,dungfloor".
computewoodfloo=0.
if(qh114=21orqh114=22)woodfloo=1.
varlabelswoodfloo"Rudimentarywoodplank,palm,bamboofloor".
computeprqfloo=0.
if(qh114=31)prqfloo=1.
varlabelsprqfloo"Polishedwoodfloor".
computevinlfloo=0.
if(qh114=32)vinlfloo=1.
varlabelsvinlfloo"Vinyl,asphaltstripfloor".
computetilefloo=0.
if(qh114=33)tilefloo=1.
varlabelstilefloo"Ceramictilefloor".
computecemtfloo=0.
if(qh114=34)cemtfloo=1.
varlabelscemtfloo"Cementfloor".
computerugfloo=0.
if(qh114=35)rugfloo=1.
varlabelsrugfloo"Carpetedfloor".
computeothfloo=0.
if(qh114=96)othfloo=1.
varlabelsothfloo"Othertypeofflooring".
*{Walls}.
computenowall=0.
if(qh116=11)nowall=1.
varlabelsnowall"Nowalls".
computenatwall=0.
if(qh116=12orqh116=13)natwall=1.
varlabelsnatwall"Cane/palm/trunks/dirtwalls".
computemudwall=0.
if(qh116=21)mudwall=1.
varlabelsmudwall"Bamboowithmudwalls".
computemdstwall=0.
if(qh116=22)mdstwall=1.
varlabelsmdstwall"Stonewithmudwalls".
computeadobwall=0.
if(qh116=23)adobwall=1.
varlabelsadobwall"Uncoveredadobewalls".
computeplywall=0.
if(qh116=24)plywall=1.
varlabelsplywall"Plywoodwalls".
computecardwall=0.
if(qh116=25)cardwall=1.
varlabelscardwall"Cardboardwalls".
computerwoodwall=0.
if(qh116=26)rwoodwall=1.
varlabelsrwoodwall"Reusedwoodwalls".
computecmtwall=0.
if(qh116=31)cmtwall=1.
varlabelscmtwall"Cementwalls".
computestonwall=0.
if(qh116=32)stonwall=1.
varlabelsstonwall"Stonewallswithlime/cement".
computebrkwall=0.
if(qh116=33)brkwall=1.
varlabelsbrkwall"Bakedbrickwalls".
computecmtbwall=0.
if(qh116=34)cmtbwall=1.
varlabelscmtbwall"Cementblockwalls".
computecadobwall=0.
if(qh116=35)cadobwall=1.
varlabelscadobwall"Coveredadobewalls".
computewoodwall=0.
if(qh116=36)woodwall=1.
varlabelswoodwall"Woodplanks,shingleswalls".
computeothwall=0.
if(qh116=96)othwall=1.
varlabelsothwall"Othertypeofwalls".
*{Roofing}.
computenoroof=0.
if(qh115=11)noroof=1.
varlabelsnoroof"Noroof".
computenatroof=0.
if(qh115=12)natroof=1.
varlabelsnatroof"Thatch/palm/sodroof".
computematroof=0.
if(qh115=21)matroof=1.
varlabelsmatroof"Rusticmat/plasticroof".
computebambroof=0.
if(qh115=22)bambroof=1.
varlabelsbambroof"Reed/bambooroof".
computewproof=0.
if(qh115=23)wproof=1.
varlabelswproof"Woodplanksroof".
computecardroof=0.
if(qh115=24)cardroof=1.
varlabelscardroof"Cardboardroof".
computemetroof=0.
if(qh115=31)metroof=1.
varlabelsmetroof"Ironsheetroof".
computewoodroof=0.
if(qh115=32)woodroof=1.
varlabelswoodroof"Woodroof".
computeasbroof=0.
if(qh115=33)asbroof=1.
varlabelsasbroof"Asbestos/cementfiberroof".
computecmtroof=0.
if(qh115=34)cmtroof=1.
varlabelscmtroof"Concreteroof".
computeshngroof=0.
if(qh115=35)shngroof=1.
varlabelsshngroof"Roofingshinglesroof".
computeothroof=0.
if(qh115=96)othroof=1.
varlabelsothroof"Othertypeofroof".
*{CookingFuel}.
computecookelec=0.
if(qh111=1)cookelec=1.
varlabelscookelec"Electricityforcooking".
computecooklpg=0.
if(qh111=2)cooklpg=1.
varlabelscooklpg"LPGforcooking".
computecookgas=0.
if(qh111=3)cookgas=1.
varlabelscookgas"Naturalgasforcooking".
computecookbio=0.
if(qh111=4)cookbio=1.
varlabelscookbio"Biogasforcooking".
computecookkero=0.
if(qh111=5)cookkero=1.
varlabelscookkero"Keroseneforcooking".
computecookchar=0.
if(qh111=6)cookchar=1.
varlabelscookchar"Charcoalforcooking".
computecookwood=0.
if(qh111=7)cookwood=1.
varlabelscookwood"Woodforcooking".
computecookstraw=0.
if(qh111=8)cookstraw=1.
varlabelscookstraw"Strawforcooking".
computecookcrop=0.
if(qh111=9)cookcrop=1.
varlabelscookcrop"Agriculturalcropforcooking".
computecookdung=0.
if(qh111=10)cookdung=1.
varlabelscookdung"Dungforcooking".
computecooknone=0.
if(qh111=95)cooknone=1.
varlabelscooknone'Doesnotcook'.
computecookoth=0.
if(qh111=96)cookoth=1.
varlabelscookoth"Otherfuelforcooking".
*{Resetmissingvaluesto"doesnothave",change2codeto0}.
if(qh110a1)qh110a=0.
if(qh110b1)qh110b=0.
if(qh110c1)qh110c=0.
if(qh110d1)qh110d=0.
if(qh110e1)qh110e=0.
if(qh110f1)qh110f=0.
if(qh110g1)qh110g=0.
if(qh110h1)qh110h=0.
if(qh110i1)qh110i=0.
if(qh110j1)qh110j=0.
if(qh110k1)qh110k=0.
if(qh110l1)qh110l=0.
if(qh118a1)qh118a=0.
if(qh118b1)qh118b=0.
if(qh118c1)qh118c=0.
if(qh118d1)qh118d=0.
if(qh1191)qh119=0.
if(qh1191)qh120=0.
computelandarea=0.
if(not(missing(qh120)))landarea=qh120.
if(qh1191)landarea=0.
FREQUENCIESlandarea.
if(qh1211)qh121=0.
if(qh1211)qh122a=0.
if(qh1211)qh122b=0.
if(qh1211)qh122c=0.
if(qh1211)qh122d=0.
if(qh1211)qh122e=0.
if(qh1211)qh122f=0.
if(qh1211)qh122g=0.
missingvaluesqh122atoqh122g(98,99).
if(qh1231)qh123=0.
*{Lightingfuel—NotavailableinEthiopia}.
*computeeleclgt=0.
*if(qh106=1)eleclgt=1.
*varlabelseleclgt"Electricityforlighting".
*computesunlgt=0.
*if(qh106=2)sunlgt=1.
*varlabelssunlgt"Solarelectricityforlighting".
*computegaslgt=0.
*if(qh106=3)gaslgt=1.
*varlabelsgaslgt"Gasforlighting".
*computehurrlgt=0.
*if(qh106=4)hurrlgt=1.
*varlabelshurrlgt"Pariffin-hurricanelamp".
*computepreslgt=0.
*if(qh106=5)preslgt=1.
*varlabelspreslgt"Pariffin-pressurelamp".
*computewicklgt=0.
*if(qh106=6)wicklgt=1.
*varlabelswicklgt"Wicklampforlighting".
*computecandlgt=0.
*if(qh106=8)candlgt=1.
*varlabelscandlgt"Candlesforlighting".
*computewoodlgt=0.
*if(qh106=7)woodlgt=1.
*varlabelswoodlgt"Firewoodforlighting".
*computeothlgt=0.
*if(qh106=96)othlgt=1.
*varlabelsothlgt"Othertypeoflighting".
*{Solidwaste/garbagecollection—NotavailableinEthiopia}.
execute.
*Checkonindicatorvariablecreation.
FREQUENCIESVARIABLES=QHTYPEHV009HV012HV013QH102QH107QH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH111QH114QH115QH116QH117QH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELAND/ORDER=ANALYSIS.
FREQUENCIESVARIABLES=memsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookoth/ORDER=ANALYSIS.
saveoutfile="c:\hnp2a\Ethiopia2010\etassets.
sav".
***FactorAnalysistoTestDistributionofcreatedvariables.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/PRINTUNIVARIATEINITIALEXTRACTION/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/METHOD=CORRELATION.
***CommonFactorAnalysis.
FILTEROFF.
USEALL.
EXECUTE.
****Redoremovingarea-specificvariables****.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookoth/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookoth/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLCOM)/METHOD=CORRELATION.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(qhtype=1).
VARIABLELABELfilter_$'qhtype=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
WEIGHTOFF.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLURB)/METHOD=CORRELATION.
**RuralArea.
USEALL.
COMPUTEfilter_$=(qhtype=2).
VARIABLELABELfilter_$'qhtype=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLRUR)/METHOD=CORRELATION.
*Calculateregressionswithtotalscore.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(qhtype=1).
VARIABLELABELfilter_$'qhtype=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERURB1.
**RuralArea.
USEALL.
COMPUTEfilter_$=(qhtype=2).
VARIABLELABELfilter_$'qhtype=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERRUR1.
FILTEROFF.
USEALL.
EXECUTE.
***CalculatecombinedwealthscorefromUrbanandRuralScores.
computecombscor=0.
printformatscombscor(F11.
5).
**Urban.
if(qhtype=1)combscor=1.
232+0.
856*URB1.
**Rural.
if(qhtype=2)combscor=(-0.
544)+0.
352*RUR1.
execute.
*Calculatequintilesandscoresfordatafile.
computehhmemwt=qhweight*hv012/1000000.
weightbyhhmemwt.
VARIABLELABELShhmemwt'HHmembersweightingforIndex'.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(qhtype=1).
VARIABLELABELfilter_$'qhtype=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=urb1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**RuralArea.
USEALL.
COMPUTEfilter_$=(qhtype=2).
VARIABLELABELfilter_$'qhtype=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=rur1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**Nationalcombinedscore.
FILTEROFF.
USEALL.
EXECUTE.
RANKVARIABLES=combscor(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/NTILES=5/STATISTICS=STDDEVMINIMUMMAXIMUMMEANMEDIANMODESKEWNESSSESKEWKURTOSISSEKURT/ORDER=ANALYSIS.
***Checkonquintiles.
frequenciesvariables=ncombsco.
computehhwt=qhweight/1000000.
weightbyhhwt.
VARIABLELABELShhwt'HHweights'.
MEANSTABLES=QH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareabyNcombsco/CELLSMEANCOUNTSTDDEV.
saveoutfile="c:\hnp2a\Ethiopia2010\et10assets.
sav".
WEIGHTOFF.
***Writeoutscoresfile.
writeformatscombscor(f11.
5).
WRITEOUTFILE='c:\hnp2a\Ethiopia2010\et10scores.
dat'TABLE/qhclustqhnumbercombscorncombscourb1nurb1rur1nrur1.
EXECUTE.
saveoutfile="c:\hnp2a\Ethiopia2010\et10assets.
sav".
ExamplesofHistogramSPSSsyntax.
***Histogramofcombinedwealthscorevalues.
weightbyhhwt.
GRAPH/HISTOGRAM(NORMAL)=combscor/TITLE='DistributionofHouseholdsbyWealthScoresEthiopia2010'.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/STATISTICS=STDDEVMEAN/HISTOGRAMNORMAL/ORDER=ANALYSISExampleofISSAGinicoefficientsyntax.
PROCGINITablefloat(1)popdistwlthindgcolpoptotal+hv025+shregionexclude(totals,specval)Title("DistributionofHouseholdPopulationbyWealthScore","Peru2000");Tablefloat(1)wlthdistwlthindgcolwlthtotal+hv025+shregionexclude(totals,specval)Title("ShareofWealthbyWealthScore","Peru2000");Tablefloat(1)coeftotal+hv025+shregionexclude(totals,specval)Title("GiniCoefficient","Peru2000");PROCPEIR41preproclevel0;{Findminimumandmaximumwealthscore}wlthmin=0;wlthmax=0;w=open(scores);whileloadcase(scores)doifwlthindfwlthmaxthenwlthmax=wlthindf;endif;enddo;w=close(scores);d=display(12,wlthmin,wlthmax);level1ifhv0151thenskipcase;endif;hweight=hv005/1000000;{Loadinwealthindexandquintiles}if!
loadcase(scores,hhid)thene=errmsg(1,hhid);endif;{Determinetabulationcategoriesas1/100ofrangeofwealthscores}wlthrng=wlthmax-wlthmin;{Notethatwlthminisanegativenumber}wlthindg=int((wlthindf-wlthmin)/(wlthrng/100));{x=display(10,wlthindf,wlthindg);}{Tabulatehouseholdpopulationandwealthscorebyweathgroups}colpop=0;x=xtab(popdist,hweight*hv009);colwlth=0;ginico=notappl;x=xtab(wlthdist,hweight*(wlthindf-wlthmin))postproclevel0popsum=0;wlthsum=0;k=0;whilek1thenskipcase;endif;postprocsetbehavior()export(SPSS,ItemOnly);exporttoSPSS_EXPORTcase_id(HHID)HV005,HV025,HV009,HV012,HV013,RECH2,RECH3,domestic,house,land;procWOMANpreprocifV716=95andHV101(V003)=12thendomestic=1;endif;ifV704=95andHV101(V003)=12thendomestic=1;endif;ifV745A>=1andV745A=1andV745B0)memsleep=trunc(hv012/hv216).
if(hv216=0)memsleep=hv012.
if(memsleep>=98)memsleep=98.
VARIABLELABELSMEMSLEEP"Numberofmemberspersleepingroom".
valuelabelsmemsleep0'Lessthan1perroom'.
*{Drinkingwatersupply}.
computeh2oires=0.
if(hv201=11)h2oires=1.
varlabelsh2oires"Pipedintodwelling".
computeh2oyrd=0.
if(hv201=12)h2oyrd=1.
varlabelsh2oyrd"Pipedintoyard/plot".
computeh2opub=0.
if(hv201=13)h2opub=1.
varlabelsh2opub"Publictap/standpipe".
computeh2obwell=0.
if(hv201=21)h2obwell=1.
varlabelsh2obwell"Tubewellorborehole".
computeh2ipwell=0.
if(hv201=31)h2ipwell=1.
varlabelsh2ipwell"Protecteddugwell".
computeh2iowell=0.
if(hv201=32)h2iowell=1.
varlabelsh2iowell"Unprotecteddugwell".
computeh2opspg=0.
if(hv201=41)h2opspg=1.
varlabelsh2opspg"ProtectedSpring".
computeh2ouspg=0.
if(hv201=42)h2ouspg=1.
varlabelsh2ouspg"UnprotectedSpring".
computeh2orain=0.
if(hv201=51)h2orain=1.
varlabelsh2orain"Waterfromrain".
computeh2otruck=0.
if(hv201=61)h2otruck=1.
varlabelsh2otruck"Waterfromtankertruck".
computeh2ocart=0.
if(hv201=62)h2ocart=1.
varlabelsh2ocart"Waterfromcartwithsmalltank".
computeh2osurf=0.
if(hv201=43)h2osurf=1.
varlabelsh2osurf"Surfacewater-river,lake,dam,etc.
".
computeh2obot=0.
if(hv201=71)h2obot=1.
varlabelsh2obot"Waterfrombottle".
computeh2ooth=0.
if(hv201=96)h2ooth=1.
varlabelsh2ooth"Otherwatersource".
*{Toiletfacility}.
computeflushs=0.
if(hv205=11)flushs=1.
varlabelsflushs"Flushtoilettosewer".
computeflusht=0.
if(hv205=12)flusht=1.
varlabelsflusht"Flushtoilettoseptictank".
computeflushp=0.
if(hv205=13)flushp=1.
varlabelsflushp"Flushtoilettopitlatrine".
computeflushe=0.
if(hv205=14)flushe=1.
varlabelsflushe"Flushtoilettoelsewhere".
computelatvip=0.
if(hv205=21)latvip=1.
varlabelslatvip"VIPlatrine".
computelatpits=0.
if(hv205=22)latpits=1.
varlabelslatpits"Pitlatrinewithslab".
computelatpit=0.
if(hv205=23)latpit=1.
varlabelslatpit"Traditionalpitlatrine".
computelatpail=0.
if(hv205=42)latpail=1.
varlabelslatpail'Buckettoilet'.
computelathang=0.
if(hv205=43)lathang=1.
varlabelslathang'Hangingtoilet/latrine'.
computelatbush=0.
if(hv205=31)latbush=1.
varlabelslatbush"Nofacility/bush/field".
computelatoth=0.
if(hv205=96)latoth=1.
varlabelslatoth'Othertypeoflatrine/toilet'.
computelatshare=0.
varlabelslatshare'Shareslatrine/toiletwithotherhouseholds'.
computesflushs=0.
varlabelsflushs"Flushtoilettosewer".
computesflusht=0.
varlabelssflusht"Flushtoilettoseptictank".
computesflushp=0.
varlabelssflushp"SharedFlushtoilettopitlatrine".
computesflushe=0.
varlabelssflushe"SharedFlushtoilettoelsewhere".
computeslatvip=0.
varlabelsslatvip"SharedVIPlatrine".
computeslatpits=0.
varlabelsslatpits"SharedPitlatrinewithslab".
computeslatpit=0.
varlabelsslatpit"SharedTraditionalpitlatrine".
computeslathang=0.
varlabelsslathang'SharedHangingtoilet/latrine'.
computeslatoth=0.
varlabelsslatoth'Othertypeoflatrine/toilet'.
doif(hv225=1).
computelatshare=1.
if(hv205=11)sflushs=1.
if(hv205=12)sflusht=1.
if(hv205=13)sflushp=1.
if(hv205=14)sflushe=1.
if(hv205=21)slatvip=1.
if(hv205=22)slatpits=1.
if(hv205=23)slatpit=1.
if(hv205=43)slathang=1.
if(hv205=96)slatoth=1.
endif.
*{Flooring}.
computedirtfloo=0.
if(hv213=11orhv213=12)dirtfloo=1.
varlabelsdirtfloo"Earth,sand,dungfloor".
computewoodfloo=0.
if(hv213=21orhv213=22)woodfloo=1.
varlabelswoodfloo"Rudimentarywoodplank,palm,bamboofloor".
computeprqfloo=0.
if(hv213=31)prqfloo=1.
varlabelsprqfloo"Polishedwoodfloor".
computevinlfloo=0.
if(hv213=32)vinlfloo=1.
varlabelsvinlfloo"Vinyl,asphaltstripfloor".
computetilefloo=0.
if(hv213=33)tilefloo=1.
varlabelstilefloo"Ceramictilefloor".
computecemtfloo=0.
if(hv213=34)cemtfloo=1.
varlabelscemtfloo"Cementfloor".
computerugfloo=0.
if(hv213=35)rugfloo=1.
varlabelsrugfloo"Carpetedfloor".
computeothfloo=0.
if(hv213=96)othfloo=1.
varlabelsothfloo"Othertypeofflooring".
*{Walls}.
computenowall=0.
if(hv214=11)nowall=1.
varlabelsnowall"Nowalls".
computenatwall=0.
if(hv214=12orhv214=13)natwall=1.
varlabelsnatwall"Cane/palm/trunks/dirtwalls".
computemudwall=0.
if(hv214=21)mudwall=1.
varlabelsmudwall"Bamboowithmudwalls".
computestonwall=0.
if(hv214=22)stonwall=1.
varlabelsstonwall"Stonewithmudwalls".
computeadobwall=0.
if(hv214=23)adobwall=1.
varlabelsadobwall"Uncoveredadobewalls".
computeplywall=0.
if(hv214=24)plywall=1.
varlabelsplywall"Plywoodwalls".
computecardwall=0.
if(hv214=25)cardwall=1.
varlabelscardwall"Cardboardwalls".
computerwoodwall=0.
if(hv214=26)rwoodwall=1.
varlabelsrwoodwall"Reusedwoodwalls".
computecmtwall=0.
if(hv214=31)cmtwall=1.
varlabelscmtwall"Cementwalls".
computestonwall=0.
if(hv214=32)stonwall=1.
varlabelsstonwall"Stonewallswithlime/cement".
computebrkwall=0.
if(hv214=33)brkwall=1.
varlabelsbrkwall"Bakedbrickwalls".
computecmtbwall=0.
if(hv214=34)cmtbwall=1.
varlabelscmtbwall"Cementblockwalls".
computecadobwall=0.
if(hv214=35)cadobwall=1.
varlabelscadobwall"Coveredadobewalls".
computewoodwall=0.
if(hv214=36)woodwall=1.
varlabelswoodwall"Woodplanks,shingleswalls".
computeothwall=0.
if(hv214=96)othwall=1.
varlabelsothwall"Othertypeofwalls".
*{Roofing}.
computenoroof=0.
if(hv215=11)noroof=1.
varlabelsnoroof"Noroof".
computenatroof=0.
if(hv215>=12andhv2151)hv206=0.
if(hv2071)hv207=0.
if(hv2081)hv208=0.
if(hv2091)hv209=0.
if(hv2101)hv210=0.
if(hv2111)hv211=0.
if(hv2121)hv212=0.
if(hv2211)hv221=0.
if(hv243a1)hv243a=0.
if(hv243b1)hv243b=0.
if(hv243c1)hv243c=0.
if(hv243d1)hv243d=0.
if(hv2471)hv247=0.
*Country-specificassets.
if(sh111g1)sh111g=0.
if(sh111h1)sh111h=0.
if(sh111i1)sh111i=0.
if(sh111j1)sh111j=0.
if(sh111k1)sh111k=0.
if(sh111l1)sh111l=0.
if(sh111m1)sh111m=0.
if(sh111n1)sh111n=0.
if(sh111o1)sh111o=0.
if(sh111p1)sh111p=0.
if(sh111q1)sh111q=0.
if(sh111r1)sh111r=0.
if(sh135a1)sh135a=0.
if(sh135b1)sh135b=0.
if(sh135c1)sh135c=0.
if(sh135d1)sh135d=0.
if(sh135e1)sh135e=0.
if(sh135f1)sh135f=0.
if(sh2011)sh201=0.
if(sh2021)sh202=0.
**Landowned.
if(hv2441)hv244=0.
computelandarea=0.
if(not(missing(hv245)))landarea=hv245/10.
if(hv244=1andhv245=0)landarea=0.
5.
if(missing(hv245)orhv245=998)landarea=$sysmis.
if(hv2441)landarea=0.
FREQUENCIESlandarea.
*Livestock--farmanimals.
if(hv2461)hv246=0.
if(hv2461)hv246a=0.
if(hv2461)hv246b=0.
if(hv2461)hv246c=0.
if(hv2461)hv246d=0.
if(hv2461)hv246e=0.
if(hv2461)hv246f=0.
if(hv2461)sh125f=0.
missingvalueshv246atohv246f,sh125f(98,99).
*Typeoftenencyofresidence.
computeownres=0.
if(sh127=1)ownres=1.
varlabelsownres'Ownsresidence'.
computerentres=0.
if(sh127=2)rentres=1.
varlabelsrentres'Rentsresidence'.
computefreeres=0.
if(sh127=3)freeres=1.
varlabelsfreeres'Freelodging/Illegaloccupancy'.
*{Lightingfuel}.
*computeeleclgt=0.
*if(qh106=1)eleclgt=1.
*varlabelseleclgt"Electricityforlighting".
*computesunlgt=0.
*if(qh106=2)sunlgt=1.
*varlabelssunlgt"Solarelectricityforlighting".
*computegaslgt=0.
*if(qh106=3)gaslgt=1.
*varlabelsgaslgt"Gasforlighting".
*computehurrlgt=0.
*if(qh106=4)hurrlgt=1.
*varlabelshurrlgt"Pariffin-hurricanelamp".
*computepreslgt=0.
*if(qh106=5)preslgt=1.
*varlabelspreslgt"Pariffin-pressurelamp".
*computewicklgt=0.
*if(qh106=6)wicklgt=1.
*varlabelswicklgt"Wicklampforlighting".
*computecandlgt=0.
*if(qh106=8)candlgt=1.
*varlabelscandlgt"Candlesforlighting".
*computewoodlgt=0.
*if(qh106=7)woodlgt=1.
*varlabelswoodlgt"Firewoodforlighting".
*computeothlgt=0.
*if(qh106=96)othlgt=1.
*varlabelsothlgt"Othertypeoflighting".
*{Solidwaste/garbagecollection}.
execute.
FREQUENCIESVARIABLES=HV025HV009HV012HV013HV201HV205HV206HV207HV208HV209HV210HV211HV212HV213HV214HV215HV216HV221HV225HV226HV243AHV243BHV243CHV243DHV244HV245HV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FSH127SH135ASH135BSH135CSH135DSH135ESH135FSH135YSH201SH202DOMESTICHOUSELAND/ORDER=ANALYSIS.
FREQUENCIESVARIABLES=memsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpsflusheslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/ORDER=ANALYSIS.
saveoutfile="c:\hnp2a\Cameroon2011\cmassets.
sav".
***FactorAnalysistoTestDistributionofcreatedvariables.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTION/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/METHOD=CORRELATION.
***CommonFactorAnalysis.
FILTEROFF.
USEALL.
EXECUTE.
****Redoremovingarea-specificvariables****.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV247SH111GSH111HSH111JSH111KSH111LDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV247SH111GSH111HSH111JSH111KSH111LDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLCOM)/METHOD=CORRELATION.
**UrbanAreas.
USEALL.
COMPUTEfilter_$=(HV025=1).
VARIABLELABELfilter_$'HV025=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
WEIGHTOFF.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLURB)/METHOD=CORRELATION.
**RuralArea.
USEALL.
COMPUTEfilter_$=(HV025=2).
VARIABLELABELfilter_$HVv025=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2ocarth2osurfh2oboth2oothflushsflushtflushplatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcooklpgcookgascookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2ocarth2osurfh2oboth2oothflushsflushtflushplatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcooklpgcookgascookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLRUR)/METHOD=CORRELATION.
*Calculateregressionswithtotalscore.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(HV025=1).
VARIABLELABELfilter_$'HV025=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERURB1.
**RuralArea.
USEALL.
COMPUTEfilter_$=(HV025=2).
VARIABLELABELfilter_$'HV025=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERRUR1.
FILTEROFF.
USEALL.
EXECUTE.
***CalculatecombinedwealthscorefromUrbanandRuralScores.
computecombscor=0.
printformatscombscor(F11.
5).
**Urban.
if(HV025=1)combscor=0.
733+0.
776*URB1.
**Rural.
if(HV025=2)combscor=(-0.
655)+0.
597*RUR1.
execute.
*Tabulationforhistograms.
weightbyhhwt.
filteroff.
useall.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/NTILES=5/STATISTICS=STDDEVMEAN/HISTOGRAMNORMAL/ORDER=ANALYSIS.
*Calculatehistogramintervals.
computehistnac=trunc(fac1_1/((2.
5-(-2.
0))/50)).
if(fac1_1ge0)histnac=histnac+1.
freqvar=histnac.
*Calculatequintilesandscoresfordatafile.
computehhmemwt=HV005*hv012/1000000.
weightbyhhmemwt.
VARIABLELABELShhmemwt'HHmembersweightingforIndex'.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(HV025=1).
VARIABLELABELfilter_$'HV025=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=urb1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**RuralArea.
USEALL.
COMPUTEfilter_$=(HV025=2).
VARIABLELABELfilter_$'HV025=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=rur1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**Nationalcombinedscore.
FILTEROFF.
USEALL.
EXECUTE.
RANKVARIABLES=combscor(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/NTILES=5/STATISTICS=STDDEVMINIMUMMAXIMUMMEANMEDIANMODESKEWNESSSESKEWKURTOSISSEKURT/ORDER=ANALYSIS.
frequenciesvariables=ncombsco.
computehhwt=HV005/1000000.
weightbyhhwt.
VARIABLELABELShhwt'HHweights'.
MEANSTABLES=HV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeresbyNcombsco/CELLSMEANCOUNTSTDDEV.
computehv271=combscor.
computehv270=ncombsco.
saveoutfile="c:\hnp2a\Cameroon2011\cmassets.
sav".
WEIGHTOFF.
writeformatscombscor(f11.
5).
WRITEOUTFILE='c:\hnp2a\Cameroon2011\cm11scores.
dat'TABLE/hhidcombscorncombscourb1nurb1rur1nrur1.
EXECUTE.
computehhwt=HV005/1000000.
weightbyhhwt.
GRAPH/HISTOGRAM(NORMAL)=combscor/TITLE='DistributionofHouseholdsbyWealthScoresCameroon'.
weightoff.
Rutstein,PhD.
Step0:Thewealthindexisbasedonhouseholddata.
However,therearethreevariablesthatmaybecreatedfromtheindividualinterviewfile:whetherthehouseholdhasoneormoredomesticservants("Domestic"),whetheranyhouseholdmemberworkstheirownortheirfamiliesagriculturalland("Land"),andwhetheranyhouseholdmemberownsadwellingunit("House").
Determineifthesurveythatwillbeusedisrawdataorstandardrecode.
Createafolderforthewealthindexprocess.
Downloadthedatadictionariesanddatafilesforthehouseholdandindividualquestionnaires.
IuseCSPRO,whichhasthehierarchicalfile.
Ifthereisaman'squestionnaire,downloadthatdictionaryanddataaswell.
Step1:Reviewthequestionnaireanddatadictionaryforthehouseholdsurvey(aswellasanyotherdocumentationsuchafrequencies,recodedoc.
)todeterminewhichvariablesaretobeusedforthewealthindex,includingcountry-specificvariables.
Normallyincludedare:Sourceofdrinkingwater,typeoftoilet,sharingoftoiletfacilities,materialofprincipalfloor,walls,roof,cookingfuel,householdservicesandpossessions,suchaselectricity,TV,radio,watch,typesofvehicles,agriculturallandsizeowned,typeandnumberofanimalsowned,bankaccount,typesofwindows.
Theitemsvarysomewhatbetweensurveysaswellasthecategoriesofthecorequestionnaireitems.
Alloftheseitemswillbeusedtodistinguishonehouseholdfromanothersothat"lumpiness"inthewealthdistributionisreduced.
However,sincethewealthindexisanindicatorofthehousehold'seconomicstatus,typeofarea,levelofeducation,occupation(otherthandomesticservant),areNOTincludedsincetheyaredeterminantsofhealthstatusintheirownrightandareusedalongwiththewealthindex.
Step2:Createthethreevariables,Domestic,Land,HousefromtheindividualdataandexportallrelevantvariablestoSPSS,alongwiththehouseholdID.
2a:CreatethevariablesDOMESTIC,LAND,ANDHOUSE.
Therevarioussourcesofinformationdependingonthesurveyanditscodes.
DOMESTIC:Atthehouseholdlevel,setDOMESTIC=0.
Ifthereisacodefordomesticservantintherelationshiptotheheadofthehouseholdvariable(HV101inthehouseholdstandardrecodefile),gothroughthehouseholdmembersandsetDOMESTIC=1ifanymemberhasthatcode.
Iftherelationshiptotheheadofthehouseholddoesnothaveacodefordomesticservant,gothroughtheindividualdatafileusingthewoman'soccupation(V717inindividualstandardrecode).
Ifshehascode6("Householdanddomestic")andherrelationshiptotheheadofthehouseholdis"notrelated",thesetDOMESTIC=1.
WherethepropercodesareavailableinV716,thatvariablecanalsobeused.
Alsocheckcountry-specificoccupationsfordomesticandhouseholdworkercategoriesorusepersonalservicesifthedomesticandhouseholdworkeroccupationisnotgiveninanyofthevariables.
Forrawdataindividualfiles,thepropercodesneedtobeused.
Thenrepeatforthewoman'spartner(V704andV705individualrecode)andcheckingtomakesureheisunrelatedtotheheadofthehousehold.
Ifthereisaman'squestionnaire,dothesameusingtheappropriatevariablesfromthemen'sindividualdata.
NotethatDOMESTICiscodedeither0(nodomesticservant)or1(domesticservant),nomatterhowmanyservantsareinthehouseholdorthesourceoftheinformation.
Alsonotethatalldomesticservantsshouldnotberelatedtotheheadofthehousehold.
LAND:SetLAND=0.
Usingthewomen'sandmen'sindividualdatasets,setLAND=1ifthewomanworksherownorfamily'sland(inthestandardrecode,V740=0or1).
AlsosetLAND=1,ifthemanworkshisownorfamily'sland.
Besuretocheckforcountry-specificquestionsonlandownership.
Note:ifagriculturallandownershipisaskedaboutinthehouseholdquestionnaire,donotusethecreatedLandvariable.
HOUSE:SetHOUSE=0.
Ifthereisacountry-specificitemonownershipofdwellingintheindividualwoman'sormen'sindividualquestionnaire,setHOUSE=1.
Additionalvariablesthatneedtobecreatedifusingtherawdatafiles:HV009,HV012,HV013:HV009isthenumberofpersonslistedinthehouseholdschedule(usuallyqhsec01).
HV012isthenumberofdejurepersonslistedinthehouseholdschedule(usuallyqhsec01whereqh05=1).
HV013isthenumberofdefactopersonslistedinthehouseholdschedule(usuallyqhsec01whereqh06=1).
Notes:1.
Forrawdatafiles,theappropriatevariablesandcodeswillhavetobeuseduponreviewingthequestionnaires.
2.
Thesevariablesmayalsobecreatedusingnon-hierarchicalfilesbyaggregatingovertheindividualdatabelongingtothesamehousehold.
2b.
Exportthecreatedvariablesandhouseholddatanecessaryforcreatingthewealthindex.
ExportthevariablesforthehouseholdID(HHIDinthestandardrecode),urban-rurallocation,householdweight,HV009,HV012,HV013,thehouseholdcharacteristics(RECH1andRECH3inthestandardrecodeandqhsec02intherawdatafile),andDOMESTIC,LAND,andHOUSE.
Beforeexporting,selectforinterviewedhouseholds(HV015=1inthestandardrecode,QHRESULT=1intherawdata).
Step3:ImportthedatafileintoSPSS(orotherdataanalysisprogramcapableoffactororprincipalcomponentsanalysis)andcreatethewealthindexindicatorvariables.
Assignvariableandvaluelabelstoeachofthecreatedindicatorvariables.
3a:Importthedatafileandsaveitunderanewnamesuchasassetsxxnn.
sav,wherexxisthecountrycodeandnnisthesurveyyear.
3b:Indicatorconstruction1.
Runfrequenciesforallcategoricalvariablestobeusedinthefactoranalysis(alsoknownasprincipalcomponentsanalysis—PCA).
BasetheconstructionofthePCAindicatorvariablesonthesefrequenciessincenotallcategoriesmayhavebeenused.
Thereisnoneedtoconstructindicatorvariablesforemptycategories.
Alsonotewhetherthereareadditionalcategoriestothoseinthequestionnairesincesomemayhavebeencreatedatthedataentrystagefrom"other"answers.
2.
Fromcategoricalvariables,suchassourceofdrinkingwater,roofingmaterials,etc.
,generatedichotomous(0-1)variablesforeachcategoryofthecategoricalvariables.
Settheindicatorvariableto1ifhouseholdisinthatcategoryand0otherwise.
The"other"categoryismadeintoanindicatorvariablebutthemissingandDKcategoriesarenot.
Specificvariableinstructions:a.
Sourceofdrinkingwater—eachcategoryisaseparateindicatorvariableexceptthatsurfacewatersources(lakes,ponds,rivers,streams,etc.
)iscombinedintooneindicatorvariableiftheyareseparatecategories.
b.
Typeoftoiletandsharingoftoilets—therehavebeentwoapproachesused.
Thefirstistocreateindicatorvariablesforeachtypeoftoiletcategoryandaseparateindicatorvariableforwhetherthetoiletissharedwithotherhouseholds(1ifshared,0ifnotsharedorquestionisnotapplicable).
Thesecondapproachistocreateasetofindicatorvariablesforeachcategoryoftoiletthatisshared.
Forexampleinthisapproach,thereisanindicatorvariablefornon-sharedflushtoiletconnectedtothesewersystemandanotherforsharedflushtoiletconnectedtothesewersystem,sothatthehouseholdhasa1valueforonlyoneoftheindicatorvariables.
Inthisapproachthesharedtoiletvariableshouldnotbeusedintheprincipalcomponentsanalysis.
Thissecondapproachprovidesslightlymoreinformationonwhichtobasethewealthindexbuttheeffectisnotlarge.
c.
Typeoffloor,wall,androofmaterials—Naturalmaterialsareusuallycombinedintoasinglematerial—earth,sand,dungfloors;cane,palmleaves,sodroofs;andcane,palm,trunks,brushandmudwalls.
3.
Useofyes-nooriginalvariables,whetherstandardorcountry-specific—thesevariablesarerecodedsothata1indicatesifthehouseholdhasa"yes"answertothequestionand0ifitdoesnothavea"yes"answer.
The0categoryincludes"no"answers(coded0instandardrecodedatasetsand2inrawdatasets),missing,DKandnotapplicableresponses.
4.
Memberspersleepingroom—ThisvariableisacontinuousvariableinthePCA.
Toconstructmemberspersleepingroomdividethenumberofdejuremembers(HV012)bythenumberofsleepingrooms(HV216inthestandardrecode).
Iftherearenodejuremembers,usethenumberofdefactomembersinstead.
(Noteiftherearenodefactomembers,thenthehouseholdshouldhavebeenexcludedfromtheanalysisdataset).
Ifthenumberofsleepingroomsiszero,thensetthenumberofsleepingroomstoonesincehouseholdmembershavetosleepsomewhere.
Ifthequestiononsleepingroomsisnotaskedbutaquestiononnumberofroomsisasked,usethatquestioninstead.
IfthenumberofsleepingroomsorpersonsismissingorDK,setthevalueofthevariabletomissing.
(MeansubstitutionformissingvalueswillbeusedinthePCA.
)5.
Agriculturalland—InlaterDHSsurveys,whetherthehouseholdownedagriculturallandandtheamountoflandownedwasasked.
Ifthisisthecase,createacontinuouslandareavariableforthePCAindicatingtheamountowned.
Ifthehouseholddoesnotownagriculturallandthencode0inthelandareaindicatorvariable.
Insomesurveys,theunitofmeasurementvariesandwillhavetobeconvertedtoasingleunit.
Iftheamountismissingthenthecreatedlandareavariableissettomissing.
6.
Farmanimals(livestock)—AlsoinlaterDHSsurveys,householdswereaskedwhethertheypossessedfarmanimalsandifsothenumbersofdifferenttypeswereasked,thetypesvaryingbycountry.
Similarlytoagriculturalland,codeacontinuousindicatorvariableforeachtypeoffarmanimal.
Allfarmanimalindicatorvariablesshouldbesetto0ifthehouseholdhasnofarmanimals.
IfthenumbersofeachtypeofanimalismissingorDK,thensettheindicatorvariabletomissing.
Thereshouldbeno'notapplicable'codeforthefarmanimalindicatorvariablessincethiscodeisincorporatedas0.
7.
Runthefrequenciesonallthecreatedindicatorvariables,comparewiththeoriginalfrequencies,andcorrectanydiscrepancies.
8.
Savethedatafileandsyntaxfile.
Step4:GenerationofhouseholdwealthscoresTherearefoursubstepstogeneratingthehouseholdwealthscores.
Allarerunwithnoweights.
4a:Eliminationofindicatorvariableswithnovariation,usuallyduetonocases.
Putallindicatorvariablesintoafactoranalysis,makingsurethattheoptionforunivariatedescriptivesisused(/PRINTUNIVARIATEinSPSS).
Iftheanalysisfails,checkthestandarddeviationforeachindicatorvariableanddeletefromthefactoranalysissyntaxallvariableswithzerostandarddeviation,meaningthatthereisnovariationforthatvariable.
Alsocheckthemissingvaluenumberofcasestomakesurethattherearenounexpectednumbers,rememberingthatsmallnumbersofmissingsmaybeexpectedforafewoftheindicatorvariables,especiallythecontinuousvariables,whichwillbeassignedthemeanvalueforthatvariable.
4b:FactoranalysisofcommonvariablesForthecommonwealthscore,usingtheindicatorvariablessuccessfullyruninstep4a,selectthesubsetindicatorvariableswhicharethoughttohavethesamerelationshipwiththeunderlyingeconomicstatusdimensioninbothurbanandruralareasandselectoutthosethatdonotapplytooneoranotherareaorarethoughttoindicatedifferentlevelsofwealth.
Anexampleisnumberofchickenssincehavingafewchickensinanurbanareamayindicateapoorurbanhouseholdcomparedtothosewithnochickenswhileinruralareashavingsomechickensmayindicateahouseholdthatiswealthierthanonewithnochickens.
Theselectionofwhichvariablestobeincludedinthecommonfactoranalysisisbasedonone'sunderstandingandexperience.
Thefactoranalysisshouldberunwiththefollowingoptions:principalcomponentsextractionusingcorrelationmethodwithonefactorextracted,substitutionofmeanformissingvalues,estimationofthefactorscoresusingtheregressionmethod,savingofthefactorscoresforeachhouseholdontothedatafileusingthenameCOM,printingofunivariatedescriptives,initialandextractedcommunalities,andfactorscorecoefficient.
Thedatashouldbeunweighted.
4c.
FactoranalysisforurbanareasFortheurbanwealthscore,firstselectthecasesofthedatafileforurbanareas.
Thenfortheurbanfactoranalysis,,selectthesubsetindicatorvariableswhicharethoughttoberelevanttourbanareasagainusingtheindicatorvariablessuccessfullyruninstep4a.
Rural-typeindicatorsmayalsoberelevantinurbanareasbutwithadifferentrelationshiptowealth.
Theselectionofwhichvariablestobeincludedintheurbanfactoranalysisisagainbasedonone'sunderstandingandexperience.
Runthefactoranalysisasforthecommonvariablesin4b.
abovebutchangingthenameofthesavedfactorscorevariabletoURB.
Ifanindicatorvariablehasnostandarddeviation,itshouldbedeletedfromtheanalysis.
Thedatashouldbeunweighted.
4d.
RepeatfactoranalysisforruralareasRemembertostartwiththevariablelistfromstep4asincesomeindicatorvariablesmayberelevantforruralareaseventhoughtherearenocasesforurbanareas.
Step5:EstimationofcompositewealthscoresSavethesyntax,dataandoutputfiles.
Thefactorscorevalueswillnowbeinthedatasetfromthecommonvariables(COM1inSPSS)forallcases,fromtheurbanfactoranalysis(URB1)inthesetofcasesinurbanareaswithmissingvaluesforruralareas,andfromruralfactoranalysis(RUR1)intheruralsetofcaseswithmissingvaluesforurbanareas.
Theurbanandruralwealthscoreswillberegressedonthecommonwealthscorestoobtaintheparameterstoestimatethecompositewealthscore.
5a.
UrbanandruralregressionsSelecturbanareacases.
Runaregressionwiththecommonfactorscore(COM1)asthedependentvariableandtheurbanareafactorscore(URB1)astheindependentvariable.
Thedatashouldbeunweighted.
Notetheconstanttermandthecoefficient.
Alsocheckthesignificanceoftheregressionandterms.
Theyshouldbehighlysignificant.
Repeatforruralareasselectingruralcasesusingtheruralareafactorscore(RUR1)astheindependentvariable.
5b.
CalculatecombinedscoreUsingallcases,firstmakeanewvariableforthecombinedscore,COMBSCOR,withfivedecimalplacesandsetitequalto0.
Thenforeachareacalculatethecombinedscoreusingtheappropriateurbanorruralfactorscores,constantsandcoefficientsobtainedinsubstep5a.
Step6:Calculatethewealthquintilesandtheircutpoints.
6a.
CalculateweightednumberofhouseholdmembersMultiplythenumberofdejurehouseholdmembersbythehouseholdsamplingweightdividedby1,000,000toobtainavariablecalledHHMEMWT.
SettheanalysissampleweightequaltoHHMEMWT.
Iftherearenodejuremembers,usethenumberofdefactohouseholdmembers.
6b.
Dividethefactorscoresintofiveequalparts(quintiles)Therearetwowaystoachievethequintiles.
Usingtheappropriatewealthscore,determinetheweightedcumulativepercentagedistributionofthewealthscore,determinethewealthscorevaluesthatcorrespondtothefourcutpointvaluesofthequintiles(1thenskipcase;endif;hv012=0;hv013=0;hv009=soccurs(qhsec01);i=1;whilei=1andq826a=1andq826b0)memsleep=trunc(hv012/qh117).
if(qh117=0)memsleep=hv012.
if(memsleep>=98)memsleep=98.
VARIABLELABELSMEMSLEEP"Numberofmemberspersleepingroom".
valuelabelsmemsleep0'Lessthan1perroom'.
*{Drinkingwatersupply}.
computeh2oires=0.
if(qh102=11)h2oires=1.
varlabelsh2oires"Pipedintodwelling".
computeh2oyrd=0.
if(qh102=12)h2oyrd=1.
varlabelsh2oyrd"Pipedintoyard/plot".
computeh2opub=0.
if(qh102=13)h2opub=1.
varlabelsh2opub"Publictap/standpipe".
computeh2obwell=0.
if(qh102=21)h2obwell=1.
varlabelsh2obwell"Tubewellorborehole".
computeh2ipwell=0.
if(qh102=31)h2ipwell=1.
varlabelsh2ipwell"Protecteddugwell".
computeh2iowell=0.
if(qh102=32)h2iowell=1.
varlabelsh2iowell"Unprotecteddugwell".
computeh2opspg=0.
if(qh102=41)h2opspg=1.
varlabelsh2opspg"ProtectedSpring".
computeh2ouspg=0.
if(qh102=42)h2ouspg=1.
varlabelsh2ouspg"UnprotectedSpring".
computeh2orain=0.
if(qh102=51)h2orain=1.
varlabelsh2orain"Waterfromrain".
computeh2otruck=0.
if(qh102=61)h2otruck=1.
varlabelsh2otruck"Waterfromtankertruck".
computeh2ocart=0.
if(qh102=71)h2ocart=1.
varlabelsh2ocart"Waterfromcartwithsmalltank".
computeh2osurf=0.
if(qh102=81)h2osurf=1.
varlabelsh2osurf"Surfacewater-river,lake,dam,etc.
".
computeh2obot=0.
if(qh102=91)h2obot=1.
varlabelsh2obot"Waterfrombottle".
computeh2ooth=0.
if(qh102=96)h2ooth=1.
varlabelsh2ooth"Otherwatersource".
*{Toiletfacility}.
computeflushs=0.
if(qh107=11)flushs=1.
varlabelsflushs"Flushtoilettosewer".
computeflusht=0.
if(qh107=12)flusht=1.
varlabelsflusht"Flushtoilettoseptictank".
computeflushp=0.
if(qh107=13)flushp=1.
varlabelsflushp"Flushtoilettopitlatrine".
computeflushe=0.
if(qh107=14orqh107=15)flushe=1.
varlabelsflushe"Flushtoilettoelsewhere".
computelatvip=0.
if(qh107=21)latvip=1.
varlabelslatvip"VIPlatrine".
computelatpits=0.
if(qh107=22)latpits=1.
varlabelslatpits"Pitlatrinewithslab".
computelatpit=0.
if(qh107=23)latpit=1.
varlabelslatpit"Traditionalpitlatrine".
computelatcomp=0.
if(qh107=31)latcomp=1.
varlabelslatcomp'Compostingtoilet/ecosan'.
computelatpail=0.
if(qh107=41)latpail=1.
varlabelslatpail'Buckettoilet'.
computelathang=0.
if(qh107=51)lathang=1.
varlabelslathang'Hangingtoilet/latrine'.
computelatbush=0.
if(qh107=61)latbush=1.
varlabelslatbush"Nofacility/bush/field".
computelatoth=0.
if(qh107=96)latoth=1.
varlabelslatoth'Othertypeoflatrine/toilet'.
computelatshare=0.
if(qh108=1)latshare=1.
varlabelslatshare'Shareslatrine/toiletwithotherhouseholds'.
*{Flooring}.
computedirtfloo=0.
if(qh114=11orqh114=12)dirtfloo=1.
varlabelsdirtfloo"Earth,sand,dungfloor".
computewoodfloo=0.
if(qh114=21orqh114=22)woodfloo=1.
varlabelswoodfloo"Rudimentarywoodplank,palm,bamboofloor".
computeprqfloo=0.
if(qh114=31)prqfloo=1.
varlabelsprqfloo"Polishedwoodfloor".
computevinlfloo=0.
if(qh114=32)vinlfloo=1.
varlabelsvinlfloo"Vinyl,asphaltstripfloor".
computetilefloo=0.
if(qh114=33)tilefloo=1.
varlabelstilefloo"Ceramictilefloor".
computecemtfloo=0.
if(qh114=34)cemtfloo=1.
varlabelscemtfloo"Cementfloor".
computerugfloo=0.
if(qh114=35)rugfloo=1.
varlabelsrugfloo"Carpetedfloor".
computeothfloo=0.
if(qh114=96)othfloo=1.
varlabelsothfloo"Othertypeofflooring".
*{Walls}.
computenowall=0.
if(qh116=11)nowall=1.
varlabelsnowall"Nowalls".
computenatwall=0.
if(qh116=12orqh116=13)natwall=1.
varlabelsnatwall"Cane/palm/trunks/dirtwalls".
computemudwall=0.
if(qh116=21)mudwall=1.
varlabelsmudwall"Bamboowithmudwalls".
computemdstwall=0.
if(qh116=22)mdstwall=1.
varlabelsmdstwall"Stonewithmudwalls".
computeadobwall=0.
if(qh116=23)adobwall=1.
varlabelsadobwall"Uncoveredadobewalls".
computeplywall=0.
if(qh116=24)plywall=1.
varlabelsplywall"Plywoodwalls".
computecardwall=0.
if(qh116=25)cardwall=1.
varlabelscardwall"Cardboardwalls".
computerwoodwall=0.
if(qh116=26)rwoodwall=1.
varlabelsrwoodwall"Reusedwoodwalls".
computecmtwall=0.
if(qh116=31)cmtwall=1.
varlabelscmtwall"Cementwalls".
computestonwall=0.
if(qh116=32)stonwall=1.
varlabelsstonwall"Stonewallswithlime/cement".
computebrkwall=0.
if(qh116=33)brkwall=1.
varlabelsbrkwall"Bakedbrickwalls".
computecmtbwall=0.
if(qh116=34)cmtbwall=1.
varlabelscmtbwall"Cementblockwalls".
computecadobwall=0.
if(qh116=35)cadobwall=1.
varlabelscadobwall"Coveredadobewalls".
computewoodwall=0.
if(qh116=36)woodwall=1.
varlabelswoodwall"Woodplanks,shingleswalls".
computeothwall=0.
if(qh116=96)othwall=1.
varlabelsothwall"Othertypeofwalls".
*{Roofing}.
computenoroof=0.
if(qh115=11)noroof=1.
varlabelsnoroof"Noroof".
computenatroof=0.
if(qh115=12)natroof=1.
varlabelsnatroof"Thatch/palm/sodroof".
computematroof=0.
if(qh115=21)matroof=1.
varlabelsmatroof"Rusticmat/plasticroof".
computebambroof=0.
if(qh115=22)bambroof=1.
varlabelsbambroof"Reed/bambooroof".
computewproof=0.
if(qh115=23)wproof=1.
varlabelswproof"Woodplanksroof".
computecardroof=0.
if(qh115=24)cardroof=1.
varlabelscardroof"Cardboardroof".
computemetroof=0.
if(qh115=31)metroof=1.
varlabelsmetroof"Ironsheetroof".
computewoodroof=0.
if(qh115=32)woodroof=1.
varlabelswoodroof"Woodroof".
computeasbroof=0.
if(qh115=33)asbroof=1.
varlabelsasbroof"Asbestos/cementfiberroof".
computecmtroof=0.
if(qh115=34)cmtroof=1.
varlabelscmtroof"Concreteroof".
computeshngroof=0.
if(qh115=35)shngroof=1.
varlabelsshngroof"Roofingshinglesroof".
computeothroof=0.
if(qh115=96)othroof=1.
varlabelsothroof"Othertypeofroof".
*{CookingFuel}.
computecookelec=0.
if(qh111=1)cookelec=1.
varlabelscookelec"Electricityforcooking".
computecooklpg=0.
if(qh111=2)cooklpg=1.
varlabelscooklpg"LPGforcooking".
computecookgas=0.
if(qh111=3)cookgas=1.
varlabelscookgas"Naturalgasforcooking".
computecookbio=0.
if(qh111=4)cookbio=1.
varlabelscookbio"Biogasforcooking".
computecookkero=0.
if(qh111=5)cookkero=1.
varlabelscookkero"Keroseneforcooking".
computecookchar=0.
if(qh111=6)cookchar=1.
varlabelscookchar"Charcoalforcooking".
computecookwood=0.
if(qh111=7)cookwood=1.
varlabelscookwood"Woodforcooking".
computecookstraw=0.
if(qh111=8)cookstraw=1.
varlabelscookstraw"Strawforcooking".
computecookcrop=0.
if(qh111=9)cookcrop=1.
varlabelscookcrop"Agriculturalcropforcooking".
computecookdung=0.
if(qh111=10)cookdung=1.
varlabelscookdung"Dungforcooking".
computecooknone=0.
if(qh111=95)cooknone=1.
varlabelscooknone'Doesnotcook'.
computecookoth=0.
if(qh111=96)cookoth=1.
varlabelscookoth"Otherfuelforcooking".
*{Resetmissingvaluesto"doesnothave",change2codeto0}.
if(qh110a1)qh110a=0.
if(qh110b1)qh110b=0.
if(qh110c1)qh110c=0.
if(qh110d1)qh110d=0.
if(qh110e1)qh110e=0.
if(qh110f1)qh110f=0.
if(qh110g1)qh110g=0.
if(qh110h1)qh110h=0.
if(qh110i1)qh110i=0.
if(qh110j1)qh110j=0.
if(qh110k1)qh110k=0.
if(qh110l1)qh110l=0.
if(qh118a1)qh118a=0.
if(qh118b1)qh118b=0.
if(qh118c1)qh118c=0.
if(qh118d1)qh118d=0.
if(qh1191)qh119=0.
if(qh1191)qh120=0.
computelandarea=0.
if(not(missing(qh120)))landarea=qh120.
if(qh1191)landarea=0.
FREQUENCIESlandarea.
if(qh1211)qh121=0.
if(qh1211)qh122a=0.
if(qh1211)qh122b=0.
if(qh1211)qh122c=0.
if(qh1211)qh122d=0.
if(qh1211)qh122e=0.
if(qh1211)qh122f=0.
if(qh1211)qh122g=0.
missingvaluesqh122atoqh122g(98,99).
if(qh1231)qh123=0.
*{Lightingfuel—NotavailableinEthiopia}.
*computeeleclgt=0.
*if(qh106=1)eleclgt=1.
*varlabelseleclgt"Electricityforlighting".
*computesunlgt=0.
*if(qh106=2)sunlgt=1.
*varlabelssunlgt"Solarelectricityforlighting".
*computegaslgt=0.
*if(qh106=3)gaslgt=1.
*varlabelsgaslgt"Gasforlighting".
*computehurrlgt=0.
*if(qh106=4)hurrlgt=1.
*varlabelshurrlgt"Pariffin-hurricanelamp".
*computepreslgt=0.
*if(qh106=5)preslgt=1.
*varlabelspreslgt"Pariffin-pressurelamp".
*computewicklgt=0.
*if(qh106=6)wicklgt=1.
*varlabelswicklgt"Wicklampforlighting".
*computecandlgt=0.
*if(qh106=8)candlgt=1.
*varlabelscandlgt"Candlesforlighting".
*computewoodlgt=0.
*if(qh106=7)woodlgt=1.
*varlabelswoodlgt"Firewoodforlighting".
*computeothlgt=0.
*if(qh106=96)othlgt=1.
*varlabelsothlgt"Othertypeoflighting".
*{Solidwaste/garbagecollection—NotavailableinEthiopia}.
execute.
*Checkonindicatorvariablecreation.
FREQUENCIESVARIABLES=QHTYPEHV009HV012HV013QH102QH107QH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH111QH114QH115QH116QH117QH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELAND/ORDER=ANALYSIS.
FREQUENCIESVARIABLES=memsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookoth/ORDER=ANALYSIS.
saveoutfile="c:\hnp2a\Ethiopia2010\etassets.
sav".
***FactorAnalysistoTestDistributionofcreatedvariables.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/PRINTUNIVARIATEINITIALEXTRACTION/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/METHOD=CORRELATION.
***CommonFactorAnalysis.
FILTEROFF.
USEALL.
EXECUTE.
****Redoremovingarea-specificvariables****.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookoth/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookoth/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLCOM)/METHOD=CORRELATION.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(qhtype=1).
VARIABLELABELfilter_$'qhtype=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
WEIGHTOFF.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLURB)/METHOD=CORRELATION.
**RuralArea.
USEALL.
COMPUTEfilter_$=(qhtype=2).
VARIABLELABELfilter_$'qhtype=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
FACTOR/VARIABLESQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/MISSINGMEANSUB/ANALYSISQH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandarea/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLRUR)/METHOD=CORRELATION.
*Calculateregressionswithtotalscore.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(qhtype=1).
VARIABLELABELfilter_$'qhtype=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERURB1.
**RuralArea.
USEALL.
COMPUTEfilter_$=(qhtype=2).
VARIABLELABELfilter_$'qhtype=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERRUR1.
FILTEROFF.
USEALL.
EXECUTE.
***CalculatecombinedwealthscorefromUrbanandRuralScores.
computecombscor=0.
printformatscombscor(F11.
5).
**Urban.
if(qhtype=1)combscor=1.
232+0.
856*URB1.
**Rural.
if(qhtype=2)combscor=(-0.
544)+0.
352*RUR1.
execute.
*Calculatequintilesandscoresfordatafile.
computehhmemwt=qhweight*hv012/1000000.
weightbyhhmemwt.
VARIABLELABELShhmemwt'HHmembersweightingforIndex'.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(qhtype=1).
VARIABLELABELfilter_$'qhtype=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=urb1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**RuralArea.
USEALL.
COMPUTEfilter_$=(qhtype=2).
VARIABLELABELfilter_$'qhtype=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=rur1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**Nationalcombinedscore.
FILTEROFF.
USEALL.
EXECUTE.
RANKVARIABLES=combscor(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/NTILES=5/STATISTICS=STDDEVMINIMUMMAXIMUMMEANMEDIANMODESKEWNESSSESKEWKURTOSISSEKURT/ORDER=ANALYSIS.
***Checkonquintiles.
frequenciesvariables=ncombsco.
computehhwt=qhweight/1000000.
weightbyhhwt.
VARIABLELABELShhwt'HHweights'.
MEANSTABLES=QH108QH110AQH110BQH110CQH110DQH110EQH110FQH110GQH110HQH110IQH110JQH110KQH110LQH118AQH118BQH118CQH118DQH119QH120QH121QH122AQH122BQH122CQH122DQH122EQH122FQH122GQH123DOMESTICHOUSELANDh2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatcomplatpaillathanglatbushlatothlatsharedirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareabyNcombsco/CELLSMEANCOUNTSTDDEV.
saveoutfile="c:\hnp2a\Ethiopia2010\et10assets.
sav".
WEIGHTOFF.
***Writeoutscoresfile.
writeformatscombscor(f11.
5).
WRITEOUTFILE='c:\hnp2a\Ethiopia2010\et10scores.
dat'TABLE/qhclustqhnumbercombscorncombscourb1nurb1rur1nrur1.
EXECUTE.
saveoutfile="c:\hnp2a\Ethiopia2010\et10assets.
sav".
ExamplesofHistogramSPSSsyntax.
***Histogramofcombinedwealthscorevalues.
weightbyhhwt.
GRAPH/HISTOGRAM(NORMAL)=combscor/TITLE='DistributionofHouseholdsbyWealthScoresEthiopia2010'.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/STATISTICS=STDDEVMEAN/HISTOGRAMNORMAL/ORDER=ANALYSISExampleofISSAGinicoefficientsyntax.
PROCGINITablefloat(1)popdistwlthindgcolpoptotal+hv025+shregionexclude(totals,specval)Title("DistributionofHouseholdPopulationbyWealthScore","Peru2000");Tablefloat(1)wlthdistwlthindgcolwlthtotal+hv025+shregionexclude(totals,specval)Title("ShareofWealthbyWealthScore","Peru2000");Tablefloat(1)coeftotal+hv025+shregionexclude(totals,specval)Title("GiniCoefficient","Peru2000");PROCPEIR41preproclevel0;{Findminimumandmaximumwealthscore}wlthmin=0;wlthmax=0;w=open(scores);whileloadcase(scores)doifwlthindfwlthmaxthenwlthmax=wlthindf;endif;enddo;w=close(scores);d=display(12,wlthmin,wlthmax);level1ifhv0151thenskipcase;endif;hweight=hv005/1000000;{Loadinwealthindexandquintiles}if!
loadcase(scores,hhid)thene=errmsg(1,hhid);endif;{Determinetabulationcategoriesas1/100ofrangeofwealthscores}wlthrng=wlthmax-wlthmin;{Notethatwlthminisanegativenumber}wlthindg=int((wlthindf-wlthmin)/(wlthrng/100));{x=display(10,wlthindf,wlthindg);}{Tabulatehouseholdpopulationandwealthscorebyweathgroups}colpop=0;x=xtab(popdist,hweight*hv009);colwlth=0;ginico=notappl;x=xtab(wlthdist,hweight*(wlthindf-wlthmin))postproclevel0popsum=0;wlthsum=0;k=0;whilek1thenskipcase;endif;postprocsetbehavior()export(SPSS,ItemOnly);exporttoSPSS_EXPORTcase_id(HHID)HV005,HV025,HV009,HV012,HV013,RECH2,RECH3,domestic,house,land;procWOMANpreprocifV716=95andHV101(V003)=12thendomestic=1;endif;ifV704=95andHV101(V003)=12thendomestic=1;endif;ifV745A>=1andV745A=1andV745B0)memsleep=trunc(hv012/hv216).
if(hv216=0)memsleep=hv012.
if(memsleep>=98)memsleep=98.
VARIABLELABELSMEMSLEEP"Numberofmemberspersleepingroom".
valuelabelsmemsleep0'Lessthan1perroom'.
*{Drinkingwatersupply}.
computeh2oires=0.
if(hv201=11)h2oires=1.
varlabelsh2oires"Pipedintodwelling".
computeh2oyrd=0.
if(hv201=12)h2oyrd=1.
varlabelsh2oyrd"Pipedintoyard/plot".
computeh2opub=0.
if(hv201=13)h2opub=1.
varlabelsh2opub"Publictap/standpipe".
computeh2obwell=0.
if(hv201=21)h2obwell=1.
varlabelsh2obwell"Tubewellorborehole".
computeh2ipwell=0.
if(hv201=31)h2ipwell=1.
varlabelsh2ipwell"Protecteddugwell".
computeh2iowell=0.
if(hv201=32)h2iowell=1.
varlabelsh2iowell"Unprotecteddugwell".
computeh2opspg=0.
if(hv201=41)h2opspg=1.
varlabelsh2opspg"ProtectedSpring".
computeh2ouspg=0.
if(hv201=42)h2ouspg=1.
varlabelsh2ouspg"UnprotectedSpring".
computeh2orain=0.
if(hv201=51)h2orain=1.
varlabelsh2orain"Waterfromrain".
computeh2otruck=0.
if(hv201=61)h2otruck=1.
varlabelsh2otruck"Waterfromtankertruck".
computeh2ocart=0.
if(hv201=62)h2ocart=1.
varlabelsh2ocart"Waterfromcartwithsmalltank".
computeh2osurf=0.
if(hv201=43)h2osurf=1.
varlabelsh2osurf"Surfacewater-river,lake,dam,etc.
".
computeh2obot=0.
if(hv201=71)h2obot=1.
varlabelsh2obot"Waterfrombottle".
computeh2ooth=0.
if(hv201=96)h2ooth=1.
varlabelsh2ooth"Otherwatersource".
*{Toiletfacility}.
computeflushs=0.
if(hv205=11)flushs=1.
varlabelsflushs"Flushtoilettosewer".
computeflusht=0.
if(hv205=12)flusht=1.
varlabelsflusht"Flushtoilettoseptictank".
computeflushp=0.
if(hv205=13)flushp=1.
varlabelsflushp"Flushtoilettopitlatrine".
computeflushe=0.
if(hv205=14)flushe=1.
varlabelsflushe"Flushtoilettoelsewhere".
computelatvip=0.
if(hv205=21)latvip=1.
varlabelslatvip"VIPlatrine".
computelatpits=0.
if(hv205=22)latpits=1.
varlabelslatpits"Pitlatrinewithslab".
computelatpit=0.
if(hv205=23)latpit=1.
varlabelslatpit"Traditionalpitlatrine".
computelatpail=0.
if(hv205=42)latpail=1.
varlabelslatpail'Buckettoilet'.
computelathang=0.
if(hv205=43)lathang=1.
varlabelslathang'Hangingtoilet/latrine'.
computelatbush=0.
if(hv205=31)latbush=1.
varlabelslatbush"Nofacility/bush/field".
computelatoth=0.
if(hv205=96)latoth=1.
varlabelslatoth'Othertypeoflatrine/toilet'.
computelatshare=0.
varlabelslatshare'Shareslatrine/toiletwithotherhouseholds'.
computesflushs=0.
varlabelsflushs"Flushtoilettosewer".
computesflusht=0.
varlabelssflusht"Flushtoilettoseptictank".
computesflushp=0.
varlabelssflushp"SharedFlushtoilettopitlatrine".
computesflushe=0.
varlabelssflushe"SharedFlushtoilettoelsewhere".
computeslatvip=0.
varlabelsslatvip"SharedVIPlatrine".
computeslatpits=0.
varlabelsslatpits"SharedPitlatrinewithslab".
computeslatpit=0.
varlabelsslatpit"SharedTraditionalpitlatrine".
computeslathang=0.
varlabelsslathang'SharedHangingtoilet/latrine'.
computeslatoth=0.
varlabelsslatoth'Othertypeoflatrine/toilet'.
doif(hv225=1).
computelatshare=1.
if(hv205=11)sflushs=1.
if(hv205=12)sflusht=1.
if(hv205=13)sflushp=1.
if(hv205=14)sflushe=1.
if(hv205=21)slatvip=1.
if(hv205=22)slatpits=1.
if(hv205=23)slatpit=1.
if(hv205=43)slathang=1.
if(hv205=96)slatoth=1.
endif.
*{Flooring}.
computedirtfloo=0.
if(hv213=11orhv213=12)dirtfloo=1.
varlabelsdirtfloo"Earth,sand,dungfloor".
computewoodfloo=0.
if(hv213=21orhv213=22)woodfloo=1.
varlabelswoodfloo"Rudimentarywoodplank,palm,bamboofloor".
computeprqfloo=0.
if(hv213=31)prqfloo=1.
varlabelsprqfloo"Polishedwoodfloor".
computevinlfloo=0.
if(hv213=32)vinlfloo=1.
varlabelsvinlfloo"Vinyl,asphaltstripfloor".
computetilefloo=0.
if(hv213=33)tilefloo=1.
varlabelstilefloo"Ceramictilefloor".
computecemtfloo=0.
if(hv213=34)cemtfloo=1.
varlabelscemtfloo"Cementfloor".
computerugfloo=0.
if(hv213=35)rugfloo=1.
varlabelsrugfloo"Carpetedfloor".
computeothfloo=0.
if(hv213=96)othfloo=1.
varlabelsothfloo"Othertypeofflooring".
*{Walls}.
computenowall=0.
if(hv214=11)nowall=1.
varlabelsnowall"Nowalls".
computenatwall=0.
if(hv214=12orhv214=13)natwall=1.
varlabelsnatwall"Cane/palm/trunks/dirtwalls".
computemudwall=0.
if(hv214=21)mudwall=1.
varlabelsmudwall"Bamboowithmudwalls".
computestonwall=0.
if(hv214=22)stonwall=1.
varlabelsstonwall"Stonewithmudwalls".
computeadobwall=0.
if(hv214=23)adobwall=1.
varlabelsadobwall"Uncoveredadobewalls".
computeplywall=0.
if(hv214=24)plywall=1.
varlabelsplywall"Plywoodwalls".
computecardwall=0.
if(hv214=25)cardwall=1.
varlabelscardwall"Cardboardwalls".
computerwoodwall=0.
if(hv214=26)rwoodwall=1.
varlabelsrwoodwall"Reusedwoodwalls".
computecmtwall=0.
if(hv214=31)cmtwall=1.
varlabelscmtwall"Cementwalls".
computestonwall=0.
if(hv214=32)stonwall=1.
varlabelsstonwall"Stonewallswithlime/cement".
computebrkwall=0.
if(hv214=33)brkwall=1.
varlabelsbrkwall"Bakedbrickwalls".
computecmtbwall=0.
if(hv214=34)cmtbwall=1.
varlabelscmtbwall"Cementblockwalls".
computecadobwall=0.
if(hv214=35)cadobwall=1.
varlabelscadobwall"Coveredadobewalls".
computewoodwall=0.
if(hv214=36)woodwall=1.
varlabelswoodwall"Woodplanks,shingleswalls".
computeothwall=0.
if(hv214=96)othwall=1.
varlabelsothwall"Othertypeofwalls".
*{Roofing}.
computenoroof=0.
if(hv215=11)noroof=1.
varlabelsnoroof"Noroof".
computenatroof=0.
if(hv215>=12andhv2151)hv206=0.
if(hv2071)hv207=0.
if(hv2081)hv208=0.
if(hv2091)hv209=0.
if(hv2101)hv210=0.
if(hv2111)hv211=0.
if(hv2121)hv212=0.
if(hv2211)hv221=0.
if(hv243a1)hv243a=0.
if(hv243b1)hv243b=0.
if(hv243c1)hv243c=0.
if(hv243d1)hv243d=0.
if(hv2471)hv247=0.
*Country-specificassets.
if(sh111g1)sh111g=0.
if(sh111h1)sh111h=0.
if(sh111i1)sh111i=0.
if(sh111j1)sh111j=0.
if(sh111k1)sh111k=0.
if(sh111l1)sh111l=0.
if(sh111m1)sh111m=0.
if(sh111n1)sh111n=0.
if(sh111o1)sh111o=0.
if(sh111p1)sh111p=0.
if(sh111q1)sh111q=0.
if(sh111r1)sh111r=0.
if(sh135a1)sh135a=0.
if(sh135b1)sh135b=0.
if(sh135c1)sh135c=0.
if(sh135d1)sh135d=0.
if(sh135e1)sh135e=0.
if(sh135f1)sh135f=0.
if(sh2011)sh201=0.
if(sh2021)sh202=0.
**Landowned.
if(hv2441)hv244=0.
computelandarea=0.
if(not(missing(hv245)))landarea=hv245/10.
if(hv244=1andhv245=0)landarea=0.
5.
if(missing(hv245)orhv245=998)landarea=$sysmis.
if(hv2441)landarea=0.
FREQUENCIESlandarea.
*Livestock--farmanimals.
if(hv2461)hv246=0.
if(hv2461)hv246a=0.
if(hv2461)hv246b=0.
if(hv2461)hv246c=0.
if(hv2461)hv246d=0.
if(hv2461)hv246e=0.
if(hv2461)hv246f=0.
if(hv2461)sh125f=0.
missingvalueshv246atohv246f,sh125f(98,99).
*Typeoftenencyofresidence.
computeownres=0.
if(sh127=1)ownres=1.
varlabelsownres'Ownsresidence'.
computerentres=0.
if(sh127=2)rentres=1.
varlabelsrentres'Rentsresidence'.
computefreeres=0.
if(sh127=3)freeres=1.
varlabelsfreeres'Freelodging/Illegaloccupancy'.
*{Lightingfuel}.
*computeeleclgt=0.
*if(qh106=1)eleclgt=1.
*varlabelseleclgt"Electricityforlighting".
*computesunlgt=0.
*if(qh106=2)sunlgt=1.
*varlabelssunlgt"Solarelectricityforlighting".
*computegaslgt=0.
*if(qh106=3)gaslgt=1.
*varlabelsgaslgt"Gasforlighting".
*computehurrlgt=0.
*if(qh106=4)hurrlgt=1.
*varlabelshurrlgt"Pariffin-hurricanelamp".
*computepreslgt=0.
*if(qh106=5)preslgt=1.
*varlabelspreslgt"Pariffin-pressurelamp".
*computewicklgt=0.
*if(qh106=6)wicklgt=1.
*varlabelswicklgt"Wicklampforlighting".
*computecandlgt=0.
*if(qh106=8)candlgt=1.
*varlabelscandlgt"Candlesforlighting".
*computewoodlgt=0.
*if(qh106=7)woodlgt=1.
*varlabelswoodlgt"Firewoodforlighting".
*computeothlgt=0.
*if(qh106=96)othlgt=1.
*varlabelsothlgt"Othertypeoflighting".
*{Solidwaste/garbagecollection}.
execute.
FREQUENCIESVARIABLES=HV025HV009HV012HV013HV201HV205HV206HV207HV208HV209HV210HV211HV212HV213HV214HV215HV216HV221HV225HV226HV243AHV243BHV243CHV243DHV244HV245HV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FSH127SH135ASH135BSH135CSH135DSH135ESH135FSH135YSH201SH202DOMESTICHOUSELAND/ORDER=ANALYSIS.
FREQUENCIESVARIABLES=memsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpsflusheslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/ORDER=ANALYSIS.
saveoutfile="c:\hnp2a\Cameroon2011\cmassets.
sav".
***FactorAnalysistoTestDistributionofcreatedvariables.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTION/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/METHOD=CORRELATION.
***CommonFactorAnalysis.
FILTEROFF.
USEALL.
EXECUTE.
****Redoremovingarea-specificvariables****.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV247SH111GSH111HSH111JSH111KSH111LDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV247SH111GSH111HSH111JSH111KSH111LDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLCOM)/METHOD=CORRELATION.
**UrbanAreas.
USEALL.
COMPUTEfilter_$=(HV025=1).
VARIABLELABELfilter_$'HV025=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
WEIGHTOFF.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLURB)/METHOD=CORRELATION.
**RuralArea.
USEALL.
COMPUTEfilter_$=(HV025=2).
VARIABLELABELfilter_$HVv025=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
FACTOR/VARIABLESHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2ocarth2osurfh2oboth2oothflushsflushtflushplatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcooklpgcookgascookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/MISSINGMEANSUB/ANALYSISHV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSELANDmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2ocarth2osurfh2oboth2oothflushsflushtflushplatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcooklpgcookgascookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeres/PRINTUNIVARIATEINITIALEXTRACTIONFSCORE/CRITERIAFACTORS(1)ITERATE(25)/EXTRACTIONPC/ROTATIONNOROTATE/SAVEREG(ALLRUR)/METHOD=CORRELATION.
*Calculateregressionswithtotalscore.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(HV025=1).
VARIABLELABELfilter_$'HV025=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERURB1.
**RuralArea.
USEALL.
COMPUTEfilter_$=(HV025=2).
VARIABLELABELfilter_$'HV025=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
REGRESSION/MISSINGLISTWISE/STATISTICSCOEFFOUTSRANOVA/CRITERIA=PIN(.
05)POUT(.
10)/NOORIGIN/DEPENDENTCOM1/METHOD=ENTERRUR1.
FILTEROFF.
USEALL.
EXECUTE.
***CalculatecombinedwealthscorefromUrbanandRuralScores.
computecombscor=0.
printformatscombscor(F11.
5).
**Urban.
if(HV025=1)combscor=0.
733+0.
776*URB1.
**Rural.
if(HV025=2)combscor=(-0.
655)+0.
597*RUR1.
execute.
*Tabulationforhistograms.
weightbyhhwt.
filteroff.
useall.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/NTILES=5/STATISTICS=STDDEVMEAN/HISTOGRAMNORMAL/ORDER=ANALYSIS.
*Calculatehistogramintervals.
computehistnac=trunc(fac1_1/((2.
5-(-2.
0))/50)).
if(fac1_1ge0)histnac=histnac+1.
freqvar=histnac.
*Calculatequintilesandscoresfordatafile.
computehhmemwt=HV005*hv012/1000000.
weightbyhhmemwt.
VARIABLELABELShhmemwt'HHmembersweightingforIndex'.
**UrbanArea.
USEALL.
COMPUTEfilter_$=(HV025=1).
VARIABLELABELfilter_$'HV025=1(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=urb1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**RuralArea.
USEALL.
COMPUTEfilter_$=(HV025=2).
VARIABLELABELfilter_$'HV025=2(FILTER)'.
VALUELABELSfilter_$0'NotSelected'1'Selected'.
FORMATfilter_$(f1.
0).
FILTERBYfilter_$.
EXECUTE.
RANKVARIABLES=rur1(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
**Nationalcombinedscore.
FILTEROFF.
USEALL.
EXECUTE.
RANKVARIABLES=combscor(A)/RANK/NTILES(5)/PRINT=YES/TIES=MEAN.
FREQUENCIESVARIABLES=combscor/FORMAT=NOTABLE/NTILES=5/STATISTICS=STDDEVMINIMUMMAXIMUMMEANMEDIANMODESKEWNESSSESKEWKURTOSISSEKURT/ORDER=ANALYSIS.
frequenciesvariables=ncombsco.
computehhwt=HV005/1000000.
weightbyhhwt.
VARIABLELABELShhwt'HHweights'.
MEANSTABLES=HV206HV207HV208HV209HV210HV211HV212HV221HV243AHV243BHV243CHV243DHV246HV246AHV246BHV246CHV246DHV246EHV246FHV247SH111GSH111HSH111ISH111JSH111KSH111LSH111MSH111NSH111OSH111PSH111QSH111RSH125FDOMESTICHOUSEmemsleeph2oiresh2oyrdh2opubh2obwellh2ipwellh2iowellh2opspgh2ouspgh2orainh2otruckh2ocarth2osurfh2oboth2oothflushsflushtflushpflushelatviplatpitslatpitlatpaillathanglatbushlatothlatsharesflushssflushtsflushpslatvipslatpitsslatpitslathangslatothdirtfloowoodflooprqfloovinlflootilefloocemtfloorugflooothfloonowallnatwallmudwallstonwalladobwallplywallcardwallrwoodwallcmtwallbrkwallcmtbwallcadobwallwoodwallothwallnoroofnatroofmatroofbambroofwproofcardroofmetroofwoodroofasbrooftileroofcmtroofshngroofothroofcookeleccooklpgcookgascookbiocookkerocookcoalcookcharcookwoodcookstrawcookcropcookdungcooknonecookothlandareaownresrentresfreeresbyNcombsco/CELLSMEANCOUNTSTDDEV.
computehv271=combscor.
computehv270=ncombsco.
saveoutfile="c:\hnp2a\Cameroon2011\cmassets.
sav".
WEIGHTOFF.
writeformatscombscor(f11.
5).
WRITEOUTFILE='c:\hnp2a\Cameroon2011\cm11scores.
dat'TABLE/hhidcombscorncombscourb1nurb1rur1nrur1.
EXECUTE.
computehhwt=HV005/1000000.
weightbyhhwt.
GRAPH/HISTOGRAM(NORMAL)=combscor/TITLE='DistributionofHouseholdsbyWealthScoresCameroon'.
weightoff.
- indicators212hhcom相关文档
- h0212hhcom
- 录入212hhcom
- ,,"Outstandingqueryfrom2008-09dataset"
- mandatory212hhcom
- 高雄市212hhcom
- 烟台市212hhcom
hostio荷兰10Gbps带宽，10Gbps带宽，€5/月，最低配2G内存+2核+5T流量
成立于2006年的荷兰Access2.IT Group B.V.（可查：VAT: NL853006404B01，CoC: 58365400） 一直运作着主机周边的业务，当前正在对荷兰的高性能AMD平台的VPS进行5折优惠，所有VPS直接砍一半。自有AS208258，vps母鸡配置为Supermicro 1024US-TRT 1U，2*AMD Epyc 7452(64核128线程)，16条32G D...
2022年腾讯云新春采购季代金券提前领 领取满减优惠券和域名优惠
2022年春节假期陆续结束，根据惯例在春节之后各大云服务商会继续开始一年的促销活动。今年二月中旬会开启新春采购季的活动，我们已经看到腾讯云商家在春节期间已经有预告活动。当时已经看到有抢先优惠促销活动，目前我们企业和个人可以领取腾讯云代金券满减活动，以及企业用户可以领取域名优惠低至.COM域名1元。 直达链接 - 腾讯云新春采购活动抢先看活动时间：2022年1月20日至2022年2月15日我们可以在...
柚子互联（34元），湖北十堰高防， 香港 1核1G 5M
柚子互联官网商家介绍柚子互联（www.19vps.cn）本次给大家带来了盛夏促销活动，本次推出的活动是湖北十堰高防产品，这次老板也人狠话不多丢了一个6.5折优惠券而且还是续费同价，稳撸。喜欢的朋友可以看看下面的活动详情介绍，自从站长这么久以来柚子互联从19年开始算是老商家了。六五折优惠码：6kfUGl07活动截止时间：2021年9月30日客服QQ：207781983本次仅推荐部分套餐，更多套餐可进...
212hhcom为你推荐
-
8080端口路由器要怎么设置才能使外网访问80;8080端口西部妈妈网我爸妈在云南做非法集资了，钱肯定交了很多，我不恨她们。他们叫我明天去看，让我用心的看，，说是什么...嘉兴商标注册怎么查商标注册日期甲骨文不满赔偿不签合同不满一年怎么补偿比肩工场大运比肩主事,运行长生地是什么意思？www.kkk.comwww.kkk103.com网站产品质量有保证吗lunwenjiance知网论文检测查重系统陈嘉垣马德钟狼吻案事件是怎么回事mole.61.com摩尔庄园的米米号和密码我都忘了 只记得注册的邮箱 怎么办-_-www.33xj.compro/engineer 在哪里下载，为什么找不到下载网站？