The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Sample Weight for Merged Dataset (Which sample weight, strata, and cluster variables should be used to create an SPSS Complex Samples Plan File)
Sample Weight for Merged Dataset [message #23736] Sat, 20 November 2021 16:39 Go to previous message
Helen is currently offline  Helen
Messages: 2
Registered: November 2021
Member
Hi, I will appreciate your expert advice about the sample weight, strata, and cluster variables that should be used to create an SPSS complex Samples analytical plan file. I have merged the male and female datasets from the eight sub-Saharan countries that I am including in my study. I merged the sample weight variables, strata, and PSU variables for the male and female datasets. I am worried that there is no difference between the population estimate and unweighted counts from Complex samples frequencies. Here are the syntaxes I used to create the Complex Samples plan file. I have also attached the SPSS output for the frequencies.

Frequencies Variables=V005 MV005 GENDER.
Compute totalsamplewegiht=0.
If (GENDER=0) totalsampleweight=V005.
If (GENDER=1) totalsampleweight=MV005.
Execute.
Frequencies Variables=totalsampleweight V005 MV005 GENDER.

COMPUTE WGT= totalsampleweight/1000000.

* Analysis Preparation Wizard.
CSPLAN ANALYSIS
/PLAN FILE='D:\Angola\Angola_Complex_samples_File2.csaplan'
/PLANVARS ANALYSISWEIGHT=WGT
/SRSESTIMATOR TYPE=WR
/PRINT PLAN
/DESIGN STRATA=V023Merged CLUSTER=V021Merged
/ESTIMATOR TYPE=WR.
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Using Normalized Weight in Analysis
Next Topic: Use of weights on subsetted data
Goto Forum:
  


Current Time: Wed Nov 30 13:23:46 Coordinated Universal Time 2022