The DHS Program User Forum
Discussions regarding The DHS Program data and results
Today's Messages (on)  | Unanswered Messages (off)

Forum: Dataset use in Stata
 Topic: Strange Issues w/ Data Formatting from DHS
Re: Strange Issues w/ Data Formatting from DHS [message #29068 is a reply to message #29060] Fri, 19 April 2024 10:56
Trevor-DHS is currently offline  Trevor-DHS
Messages: 789
Registered: January 2013
Senior Member
Hi, I would like to help you resolve this issue. A couple of first steps:
1) If you are working in Stata, you only need the DT files (e.g. TZxxvvDT.zip) and not the FL zip files (e.g. TZxxvvFL.zip), with the exception of the geospatial (GE) files which are only in one format. All of the DT files contain the .dta data files that you need. There is no need to use the .do and .dct files that are found in the FL zip files as the same data are in the DT files.zip
2) Once you have just the DT zip files, you will find the .dta files inside of those zip files and should be able to unzip them automatically to the location of your choice.
Can you test this out and see if it works?

I'm a little confused about the images you have shared of the file contents. I think you have cut sections of the output into the images you shared, but I think you have cut them in the wrong place. For example in your image that starts "successfully extracted TZKR41DT.zip ...", you are mixing the output from extracting two different zip files. You are showing the end of the process for extracting TZKR41DT.zip, with the list of files being shown before "successfully extracted TZKR41DT.zip ..." (but not included in the image you sent) and then telling you that 4 files were processed. Then in the same image you are showing the first part of the extraction of TZKR63FL.zip and listing the 8 files extracted from that, but then not showing the success message.

Let us know if this helps clarify your issues.
Forum: Kenya
 Topic: KDHS 2022 Gender Based Violence Indicators
Re: KDHS 2022 Gender Based Violence Indicators [message #29069 is a reply to message #28265] Fri, 19 April 2024 11:54
Vincent Odhiambo is currently offline  Vincent Odhiambo
Messages: 4
Registered: October 2023
Member
Hello Stephen. I hope you are fine. Kindly assist with a set of variables that would define economic violence using tanzania DHS. i am using IR file from 2022 survey
Forum: Biomarkers
 Topic: BMI of males
Re: BMI of males [message #29070 is a reply to message #28996] Fri, 19 April 2024 16:55
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I meant to say that there seem to have been some inconsistencies in the measurement of men's heights across the NFHS surveys but certainly not by an order of magnitude.

Powers of 10 are used consistently across DHS surveys for the same variables, but are different for different variables.  Powers of 10 are used simply to move the decimal point to the right, often enough for it to be ignored.  The most familiar example is the sampling weight, which is multiplied by 10^6, so the decimal point can be ignored. The same sore of thing is done for height weight, z scores, etc.

I am unfamiliar with the IPUMS files, variable names, recodes, etc.  It looks like you are using the zanthro construction for adults by setting age at 17 years and 11 months.  You can do that, but I believe nutrition experts would question whether the standards for that age should be applied to all adult ages.  DHS staff cannot help with these kinds of analysis issues.
Forum: Nutrition and Anthropometry
 Topic: Stunting Data in 2022 Philippines DHS?
Re: Stunting Data in 2022 Philippines DHS? [message #29071 is a reply to message #29035] Fri, 19 April 2024 16:56
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

That survey did not include measurements of height and weight.
Forum: General
 Topic: MERGING IR AND HR FILE
Re: MERGING IR AND HR FILE [message #29066 is a reply to message #29008] Fri, 19 April 2024 00:47
Noyel Sebastian is currently offline  Noyel Sebastian
Messages: 6
Registered: March 2024
Member
Thank you for the reply. I would like to clarify whether merging my IR file with the PR file will give me the respective women's household characteristics (which are not in the IR file). I understood from your reply that it is better if I merge the IR and PR files to get the missing household variables for women. I can follow this by merging the new file with the BR file.

Is there anything I need to focus on concerning the merging codes of the IR and PR files? Is it possible to share the merge code?



Thank You
 Topic: Regional variable v024
Re: Regional variable v024 [message #29073 is a reply to message #29030] Fri, 19 April 2024 16:58
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

The v variables (variables with prefix v, hv, or mv) are fixed (so far as I know). They will mean the same thing in every survey. However, the specific codes can be different. Source of drinking water would be an example. It has the same variable name in every survey but the codes and categories can be different. This generalization would apply to almost all variables except the survey-specific variables that begin with "s".

As a general rule, the more recent the surveys, the greater the standardization. A good thing about the IPUMS files is that that their staff have checked very carefully for potential inconsistencies and have developed even more consistent labels and codes than in the DHS files.
Forum: Reproductive Health
 Topic: Gabon 2011-2012 Abortion
Re: Gabon 2011-2012 Abortion [message #29072 is a reply to message #29027] Fri, 19 April 2024 16:57
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I have just looked at the questionnaire, specifically the segment between approximately Q232 and Q251.  The woman is asked how many abortions she ever had. That is coded as s232a.  Then, if her most recent abortion was in the past 5 years, there is a series of questions about that specific abortion. 

The woman is not asked for the number of abortions in the past 5 years. If she had at least one abortion in the past 5 years, then variables such as v242 will be asked, that is v242 will be not NA (that is, it will not be coded with a dot).  If her lifetime number of abortions is 1, and it occurred in the past 5 years, then v242 will be not NA and you can tell that she had one abortion in the past 5 years. Otherwise you simply cannot tell how many abortions she had in the past 5 years.
 Topic: Contraceptive calendar
Re: Contraceptive calendar [message #29074 is a reply to message #29043] Fri, 19 April 2024 17:00
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

You could get the Stata code for the calendar (vcal_1) from our GitHub site but it's simple, so I will just paste it below. You don't exactly want the number of pregnancies, but the number of completed pregnancies, which are coded with a B for a birth and T for other terminations.

There is one record with an obvious error that must be dropped.
* Births, terminations, and completed pregnancies in the calendar (the past 5 years)
 

use "...IAIR7EFL.DTA" , clear
gen B=0
gen T=0
quietly forvalues lcol=1/80 {
replace B=B+1 if substr(vcal_1,`lcol',1)=="B" & (`lcol'-v018)<60
replace T=T+1 if substr(vcal_1,`lcol',1)=="T" & (`lcol'-v018)<60
}
 

* There is one record with T=59; drop it
drop if T==59

gen P=B+T
label variable B "Births"
label variable T "Terminations"
label variable P "Pregnancies"
tab1 B T P
 Topic: Cervical cancer
Re: Cervical cancer [message #29075 is a reply to message #29036] Fri, 19 April 2024 17:01
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

You did not say WHICH survey in Gabon, but you are apparently working with the most recent one. If you look at the final report, you will see that the questions for these variables are in section 13, which begins on page 564.

DHS data about non-communicable diseases have been under-analyzed, and we encourage you to do as much as you can with these variables in the Gabon survey.
Forum: Mortality
 Topic: Working through Odds Ratios
Working through Odds Ratios [message #29067] Fri, 19 April 2024 07:08
shivani is currently offline  shivani
Messages: 9
Registered: March 2021
Member
Hi,
I am want to calculate the odds ratio for NNMR, IMR, CMR across social categories for which I am using the variable b6 and b7.
However, there is some error I believe in data as the age at deaths (captured by b6 and b7) shows values greater than 60 months (in the variable b7).
Approx 8000 observations in b7 variable are greater than "60".
Can someone help me with that?
additionally, I hope my approach is correct in which I am only including those observations with b7==0 if the child didn't survive first three years as "having incurred neonatal mortality" in comparison to a live child of age 1 month?

Thanks
Re: Working through Odds Ratios [message #29076 is a reply to message #29067] Fri, 19 April 2024 17:09
Janet-DHS is currently offline  Janet-DHS
Messages: 694
Registered: April 2022
Senior Member
Thank you for submitting your question. Could you please provide some more detailed information so we can better advise you?
Can you let us know:
• Which survey you are using (Include country name and year)?
• Which data files you are referring to?
• Which software you are using (Stata, SPSS, R, etc.)?
If you are trying to match a Table in a final report, please also indicate which table and which estimate you are trying to match.



Current Time: Fri Apr 19 22:42:05 Coordinated Universal Time 2024