| Pooling male and female files [message #13158] |
Fri, 29 September 2017 15:29  |
claurti
Messages: 2
Registered: September 2017
|
Member |
|
|
I'm working with 2013 Nigeria DHS data.
I would like to pool the male and female files. I have already prepared each file individually (e.g., renamed variables) and appended the male to female file.
However, I need help with the following:
1. When I run a simple tabulation on gender, 69% of the sample is female. I've applied the sampling weights, so I was expecting this would be more of a 50% / 50% split, reflecting the population. Is another step needed?
2. In addition to the PSU, I need to adjust for the household stage of sampling. What is an elegant way in Stata to identify the household level?
Many thanks for all your help. I'm a new DHS user, so appreciate any guidance you can provide.
Charles
|
|
|
|
| Re: Pooling male and female files [message #13172 is a reply to message #13158] |
Sun, 01 October 2017 01:12  |
schoumaker
Messages: 66
Registered: May 2013
Location: Belgium
|
Senior Member |
|
|
Hello,
The sampling rate is usually smaller among men (e.g. one out of 2 eligible men).
The weights are computed to adjust for differences in sampling rate within a sample (e.g. men) -> their sum is equal to the sample size.
What I would do:
- If the sampling rate of men is half the sampling rate of women, you divide each man's weight (mv005) by 2.
- you then divide each weight by the average weight (in the full sample) to normalize them (not necessary in Stata, but necessary in other software packages).
Best,
Bruno
Bruno Schoumaker
Centre for Demographic Research
Université catholique de Louvain
|
|
|
|
| Re: Pooling male and female files [message #13190 is a reply to message #13172] |
Mon, 02 October 2017 14:40 |
Bridgette-DHS
Messages: 3199
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS Stata Specialist, Tom Pullum:
Regarding your second question, we do not have the sampling fractions or weights for households within clusters. The weight we provide is for the combination of sampling clusters and sampling households within clusters. There have been several earlier posts on this.
Regarding the first question, if you open the PR file and enter "tab1 hv117 hv118" you will see that this survey subsampled only half of the men. When you combine with women, you need to approximately double the weight for the men.
The following routine will calculate the correct weight for the men relative to the women
use e:\DHS\DHS_data\PR_files\NGPR6AFL.dta, clear
* Reduce the PR file to men who are eligible by age and are de facto
keep if hv105>=15 & hv105<=49
keep if hv103==1
keep if hv104==1
* Total hh weight for men who are eligible by age and are de facto
summarize hv005
scalar W=r(sum)
* Total hh weight for men who are eligible by age and are de facto and are subsampled
summarize hv005 if hv104==1 & hv118==1
scalar W1=r(sum)
* Calculate the ratio
scalar factor=W/W1
scalar list factor
use e:\DHS\DHS_data\MR_files\NGMR6AFL.dta, clear
* Multiply mv005 by the ratio and round to an integer
gen mv005_rewtd=round(mv005*factor)
* Then append the IR and MR files and use mv005_rewtd as the weight for men
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
