The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Weighting data » Weighting when combining datasets - AIS and non-weighted datasets
Weighting when combining datasets - AIS and non-weighted datasets [message #9040] Mon, 01 February 2016 13:07 Go to next message
SKujawski is currently offline  SKujawski
Messages: 8
Registered: May 2015

I am combining two datasets - the Mozambique 2009 AIS and another survey performed in Mozambique that does not need to be adjusted for survey weights. How should I assign survey weights and PSU/strata values to the non-weighted dataset? While I could apply a "1" as the HIV weight, I think I also need to apply a value to the PSU and the strata.

Here is my code for the AIS data:

gen HIVweight = hiv05/1000000

svyset v021 [pweight=HIVweight], strata(v022)

Thank you,
Re: Weighting when combining datasets - AIS and non-weighted datasets [message #9066 is a reply to message #9040] Thu, 04 February 2016 09:40 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 2537
Registered: February 2013
Senior Member
Following is a response from Senior DHS Stata Specialist, Tom Pullum:

As I interpret the situation, you want to append another file to a DHS file and analyze them as one file. I strongly recommend that you not do this. It will be much better to analyze the two files separately and then present the results side by side.

The weights, clusters, and strata are determined by the design of the data collection. If you do not have information about the design of the non-DHS survey, then you cannot safely make any assumptions about those things. It is very unlikely that, as you say, the second sample does not need weights. It's much more likely that the information required for calculating weights was not saved. Almost no samples are genuinely self-weighting.

The weights in a DHS survey reflect relative under-sampling or over-sampling (and response rates) of the clusters. They ignore a factor which is basically the ratio of the national household population to the sampled household population, i.e. the number of cases in the PR file. If you want a pooled DHS sample and non-DHS sample to be nationally representative, you must adjust for the difference in the overall sampling fractions. If n1 is the size of the DHS sample and n2 is the size of the non-DHS sample, then as a minimum you would assign a pseudo-weight n1/n2 to the cases in the non-DHS sample. This would weight the non-DHS sample up if it is smaller than the DHS sample, and down if it is larger than the DHS sample. If you are working with Stata, pweights are always adjusted so that the total weight in the full sample is equal to the unweighted total number of cases. Therefore you can do this kind of adjustment to either sample, without affecting the robust standard errors, etc.

To repeat, I would not go down that path. It would be much better to do parallel analyses of the two data sets and then compare the results. I don't think any journal reviewers, for example, would accept an analysis that was based on the kind of pooling that you suggest.

Previous Topic: Weighting Data Question
Next Topic: Survey Weights for 2010 Kenya SPA Health Worker Interview
Goto Forum:

Current Time: Mon Jun 27 14:23:17 Coordinated Universal Time 2022