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

Forum: Dataset use in SPSS
Topic: Indonesia 2017 data set
Re: Indonesia 2017 data set [message #17933 is a reply to message #17871] Fri, 19 July 2019 07:23
 Bridgette-DHS Messages: 1643Registered: February 2013 Senior Member
Following is a response from DHS Lead Nutrition Research Associate, Rukundo Benedict:

I re-ran the data and I get what is in the report. Below is the code I used to get my results.

```use "C:\Users\39788\ICF\Analysis - Shared Resources\Data\DHSdata\IDKR71FL.DTA"

*Generate weight variable**
gen wgt=v005/1000000
*Generate age, keep those <2 years
gen age=b19
keep if age<24
*keep only those children alive
ta b5
keep if b5==1
*Generate age groups
recode age (0/1=1 "0-1")(2/3=2 "2-3")(4/5=3 "4-5")(6/8=4 "6-8")(9/11=5 "9-11")(12/17=6 "12-17")(18/23=7 "18-23"), gen (age_months)
**If drank from bottle with nipple (bottlefeeding)
gen bottle=0
replace bottle=1 if m38==1
ta age_month bottle  [iw=wgt], row
*Important Note: for the other indicators, children must be the youngest child and living with mother
*keep only those living with mother
keep if b9==0
* finding the youngest child living with the mother
bysort v001 v002 v003: egen minbidx=min(bidx)
* keep only children less than 2 years
keep if age<24
ta bidx minbidx
* need to drop those that are bidx==2 and minbidx==1
drop if bidx>minbidx
ta age_month [iw=wgt]
gen water=0
gen liquids=0
gen milk=0
gen solids=0
gen breast=0
*To determine if child is given water, sugar water, jiuce, tea or other
replace water=1 if (v409>=1 & v409<=7)

* If given other liquids
foreach xvar of varlist v409a v410 v410a v413*  {
replace liquids=1 if `xvar'>=1 & `xvar'<=7
}

* If given powder/tinned milk, formula or fresh milk
foreach xvar of varlist v411 v411a v412 v414p {
replace milk=1 if `xvar'>=1 & `xvar'<=7
}

*If currently breastfeeding
replace breast=1 if m4==95

*CBF at 1 year
gen CBFage=0
replace CBFage=1 if age>11 & age<16
ta CBFage
ta breast CBFage
ta CBFage breast [iw=wgt], row
```
Forum: Reproductive Health
Topic: Surveys with menopause
Re: Surveys with menopause [message #17934 is a reply to message #17821] Fri, 19 July 2019 07:41
 L.Brown11@lse.ac.uk Messages: 10Registered: August 2018 Location: London Member
Hi DHS support,

I just wanted to flag this query as unanswered - are you able to advise RE whether there is a list of DHS datasets that ask about menopause?

Many thanks,

Laura
Forum: Ethiopia
Topic: SPA data set related question
Re: SPA dataset: antanatal care dataset [message #17935 is a reply to message #17869] Fri, 19 July 2019 11:28
 Bridgette-DHS Messages: 1643Registered: February 2013 Senior Member
Following is a response from DHS Senior Analysis and Research Manager, Wenjuan Wang:

The DRC SPA data are raw data, and the recode data are not yet available. That is why you saw the letter code as shown in the table below or in your tabulation.
Variable oa115 comes from Q115 in the ANC observation questionnaire, see below: In the raw data file, the letters remain as categories without recoding. For example, in the tabulation below, the first row means A (asked the client where she will deliver) was done for 147 observed clients; the second row "AB" means Both A and B were done for 124 clients, the third row, "ABC" means A, B, and C were done for 86 clients, so on and so forth... But when you analyze data, you probably want to know how many or what percentage of clients got A regardless instead of different combinations listed in variable oa115. In that case, you need to recode variable oa115. If you use Stata, you can use this command "regexm" to generate a new variable that indicates if A was done at all, regardless it was the only thing done or with other services.

Hope this helps and let us know if you have other questions.

```gen a=0
replace a=1 if regexm(of115,"A")
```

• Attachment: Antenatal.PNG
Forum: Dataset access
Tanzanian DHS 2015-2016 Access to Occupation Text data Fri, 19 July 2019 12:30
 Judith R Messages: 1Registered: July 2019 Member
I am interested in accessing the text data for 'occupation' in relation to variable V704 and V716 from the Tanzanian DHS 2015-2016. Is there a process by which this might be achieved? Specifically I am interested in distinguishing between agricultural workers and fishery workers: ie 'label define V704' and 'label define' 716 numbers '61', '62', '63', and '92' where these categories are grouped together. I would appreciate any assistance in this regard.

[Updated on: Fri, 19 July 2019 12:32]

Report message to a moderator

Forum: Other countries
Topic: Health Insurance Coverage
Re: Health Insurance Coverage [message #17937 is a reply to message #17882] Fri, 19 July 2019 13:27
 Bridgette-DHS Messages: 1643Registered: February 2013 Senior Member

Following is a response from DHS Research & Data Analysis Director, Tom Pullum:

We apologize for the delay in responding to your July 2 forum post. We have determined that the tables on health insurance in the report are correct, but, as you suggested, the labels for v481c and v481e are reversed. The correct labels would be "PBI" for v481c and "non-PBI" for v481e. Thank you for alerting us to this error.

Current Time: Fri Jul 19 21:53:34 Eastern Daylight Time 2019