The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use (other programs) » respondents not visiting health facility
respondents not visiting health facility [message #25378] Thu, 13 October 2022 05:46 Go to next message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
Dear forum members,

This is to request you to kindly share any example of calculating respondents who did not visit the health facility .

Regards
Lincoln
Re: respondents not visiting health facility [message #25383 is a reply to message #25378] Thu, 13 October 2022 08:23 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
From DHS staff member, Tom Pullum:

Users are asked to be more specific. A general answer to a general question like this will not be very helpful to you. What survey are you working with? Are you trying to match a table in a report? If so, which table?
Re: respondents not visiting health facility [message #25384 is a reply to message #25378] Thu, 13 October 2022 09:11 Go to previous messageGo to next message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
Dear Tom,

I was looking for Household variable in NFHS -5, which can guide me calculate the proportion of households who did or did not access health care in last three months. Similar to the table 11.20 which provides individual male/female information on percentage who visited to the health facility/camp in last three months, but at household level, not at individual level.

Regards
Lincoln
Re: respondents not visiting health facility [message #25420 is a reply to message #25384] Mon, 17 October 2022 12:14 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is a response from DHS staff member, Tom Pullum:

You already asked about Table 11.20, in August. As I said then, this table is based on s361 and s368 in the IR file, and sm320 in the MR file. The questions are about individuals, not households. To construct a household-level version, you would have to allow for the possibility that there are no women, or no men, in the household. There can be more than one women or more than one man. The individual women or men will give different responses. The men are in a 1/6 subsample of households. In the households for which men were not sampled, the household-level classification would depend solely on the responses for women.

I can help if you will be more specific. How about calculating the following?

"Percentage of households with at least one woman who had any contact with a health worker in the past 3 months"
"Percentage of households with at least one woman who visited a health facility or camp in the past 3 months"
"Percentage of households with at least one man who visited a health facility or camp in the past 3 months"

If that's what you want, I can show you how to do it.
Re: respondents not visiting health facility [message #25468 is a reply to message #25420] Tue, 25 October 2022 09:06 Go to previous messageGo to next message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
Dear Tom,

Many thanks for the kind response.

Please guide me in doing the calculations for the three indicators. I am using R.

Regards
Lincoln
Re: respondents not visiting health facility [message #25472 is a reply to message #25468] Tue, 25 October 2022 12:42 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from DHS staff member, Tom Pullum:

There are probably different ways to interpret what you want. The following Stata code estimates this: Out of all households with at least one "yes" or "no" response, what is the percentage that had at least one "yes". I don't use R but you should be able to translate this from Stata to R.


use "...IAIR7DFL.DTA" ,clear
gen reg=v024
gen cluster=v001
gen hh=v002
gen line=v003

gen s361_yes=1 if s361==1
gen s361_no =1 if s361==0

gen s368_yes=1 if s368==1
gen s368_no =1 if s368==0

* Collapse to get the numbers of yes and no responses within households
collapse (sum) s361_* s368_* (first) v005, by(reg cluster hh)

* The units of analysis are households with at least one woman who has a response to s361
tab s361_yes s361_no [iweight=v005/1000000] 
gen     s361_yes_1plus=0 if s361_yes+s361_no>0
replace s361_yes_1plus=1 if s361_yes>1
tab s361_yes_1plus [iweight=v005/1000000]

* The units of analysis are households with at least one woman who has a response to s368
tab s368_yes s368_no [iweight=v005/1000000] 
gen     s368_yes_1plus=0 if s368_yes+s368_no>0
replace s368_yes_1plus=1 if s368_yes>1
tab s368_yes_1plus [iweight=v005/1000000]



use "...IAMR7DFL.DTA", clear 
gen reg=mv024
gen cluster=mv001
gen hh=mv002
gen line=mv003

gen sm320_yes=1 if sm320==1
gen sm320_no =1 if sm320==0

* Collapse to get the numbers of yes and no responses within households
collapse (sum) sm320_* (first) mv005, by(reg cluster hh)

* The units of analysis are households with at least one man who has a response to sm320
tab sm320_yes sm320_no [iweight=mv005/1000000] 
gen     sm320_yes_1plus=0 if sm320_yes+sm320_no>0
replace sm320_yes_1plus=1 if sm320_yes>1
tab sm320_yes_1plus [iweight=mv005/1000000]
Re: respondents not visiting health facility [message #25473 is a reply to message #25472] Tue, 25 October 2022 16:06 Go to previous messageGo to next message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
Thanks.

Could manage to do it for the Men. Have problem with the women file. both for the facility and for meeting the health worker.

Regards
Lincoln

Re: respondents not visiting health facility [message #25474 is a reply to message #25473] Tue, 25 October 2022 23:52 Go to previous messageGo to next message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
Hi,

I am not very familiar with STATA, but it will be great if you can please share the full code for either 361 or 368. to create the table 11.20.

Regards
Lincoln
Re: respondents not visiting health facility [message #25476 is a reply to message #25474] Wed, 26 October 2022 07:18 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member

Following is a response from DHS staff member, Tom Pullum:

I just re-ran the code and it works fine for me. Perhaps you have a typo or the wrong data file?

Re: respondents not visiting health facility [message #25479 is a reply to message #25476] Wed, 26 October 2022 09:18 Go to previous messageGo to next message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
I have re downloaded the data.

Please find attached the screen short.

I am still not able to generate the State wise table (Attached).

Regards
Lincoln

Re: respondents not visiting health facility [message #25480 is a reply to message #25479] Wed, 26 October 2022 11:46 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3199
Registered: February 2013
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I think the problem is that v024 (or other covariates) must be included in the "collapse" command, after "(first)". Otherwise the covariate is lost. The following should do what you want.

use "...IAIR7DFL.DTA",clear
gen reg=v024
gen cluster=v001
gen hh=v002
gen line=v003

gen s361_yes=1 if s361==1
gen s361_no =1 if s361==0

gen s368_yes=1 if s368==1
gen s368_no =1 if s368==0

* Collapse to get the numbers of yes and no responses within households
collapse (sum) s361_* s368_* (first) v005 v024, by(reg cluster hh)

* Must re-attach the values label after the collapse
label values v024 V024 

* The units of analysis are households with at least one woman who has a response to s361
tab s361_yes s361_no [iweight=v005/1000000] 
gen     s361_yes_1plus=0 if s361_yes+s361_no>0
replace s361_yes_1plus=1 if s361_yes>1
tab v024 s361_yes_1plus [iweight=v005/1000000], row



* The units of analysis are households with at least one woman who has a response to s368
tab s368_yes s368_no [iweight=v005/1000000] 
gen     s368_yes_1plus=0 if s368_yes+s368_no>0
replace s368_yes_1plus=1 if s368_yes>1
tab v024 s368_yes_1plus [iweight=v005/1000000], row



use "...IAMR7DFL.DTA",clear
gen reg=mv024
gen cluster=mv001
gen hh=mv002
gen line=mv003

gen sm320_yes=1 if sm320==1
gen sm320_no =1 if sm320==0

* Collapse to get the numbers of yes and no responses within households
collapse (sum) sm320_* (first) mv005 mv024, by(reg cluster hh)

* Must re-attach the values label after the collapse
label values mv024 MV024 

* The units of analysis are households with at least one man who has a response to sm320
tab sm320_yes sm320_no [iweight=mv005/1000000] 
gen     sm320_yes_1plus=0 if sm320_yes+sm320_no>0
replace sm320_yes_1plus=1 if sm320_yes>1
tab mv024 sm320_yes_1plus [iweight=mv005/1000000], row
Re: respondents not visiting health facility [message #25483 is a reply to message #25480] Thu, 27 October 2022 03:34 Go to previous message
Lincoln is currently offline  Lincoln
Messages: 31
Registered: July 2022
Member
I go the results. Many thanks for the kind support.

Regards
Lincoln
Previous Topic: multilevel log-binomial regression
Next Topic: Merging PR and KR file NFHS
Goto Forum:
  


Current Time: Wed Nov 27 10:29:04 Coordinated Universal Time 2024