The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nepal » Replicating some variables (Replicating some variables in NHFS 2021)
Replicating some variables [message #25411] Sun, 16 October 2022 09:38 Go to next message
Mila is currently offline  Mila
Messages: 4
Registered: October 2022
Member
I am trying to replicate Nepal Health Facility Survey 2021 table 6.4 Testing capacity using SPSS recode file. However, I couldn't replicate Urine protein and Urine glucose. I am using variables V851A, V851B, V462B, V462C but either way, my result didn't match with the table. Similarly, I get some variation with Table 6.6 especially for iron and folic acid even after combining folic acid tablets and the iron. How much of variation is acceptable? for example in the table 7.3, I got 27.3% for staff trained in delivery care against 29.2% in the table. I really appreciate for your help to solve these discrepancies. I have used weight for calculations divided by 1000000. Many thanks.
Re: Replicating some variables [message #25470 is a reply to message #25411] Tue, 25 October 2022 11:26 Go to previous messageGo to next message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 131
Registered: August 2020
Location: USA
Senior Member
Hello,

Are you matching the number of facilities that offer ANC services? In Table 6.4 you see that there are 1,538 that offer ANC services. To match this denominator you must drop HTC stand alone facilities. You must only select for facilities that offer ANC services to match this table.

Best,
Shireen Assaf
The DHS Program
Re: Replicating some variables [message #25499 is a reply to message #25470] Sun, 30 October 2022 07:51 Go to previous messageGo to next message
Mila is currently offline  Mila
Messages: 4
Registered: October 2022
Member
Many thanks for your reply. Actually, I missed to combine availability from general medicine section. I have one more request.
Would you be able to provide information on geo-ecological region i.e., Hill, Terai, mountain districts of Nepal for 2021. It was provided in the 2015.
I failed to find this information in the facility data. couldn't find this in the GPS set as well.
Or else, can you direct me the online GIS layer for intersection so that I can match facility with GIS LAYER. Really appreciate your reply.
I tried directly converting district into these regions but couldn't replicate the numbers. Many thanks again.
Re: Replicating some variables [message #25507 is a reply to message #25499] Mon, 31 October 2022 08:49 Go to previous message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 131
Registered: August 2020
Location: USA
Senior Member
Hello,

I can provide you with the Stata code to construct the geo-ecological region. I hope you can use this to translate to SPSS code.

To get this variable you need to recode the district variable as follows:

recode district (101 102 103 301 302 303 402 403 601 602 603 604 605 701 702 703=1 Mountain) (104 105 106 107 108 109 110 114 304 305 306 307 308 309 310 311 312 401 404 405 406 407 409 410 411 501 502 503 504 505 506 606 607 608 609 610 704 705 706 707 =2 Hill) (111 112 113 201 202 203 204 205 206 207 208 313 408 507 508 509 510 511 512 708 709 =3 Terai), gen(ecoregion)

gen wt=facwt/1000000
tab ecoregion [iw=wt]

This weighted tabulation matches table 2.3.1 in the Final report.

Best,
Shireen Assaf
The DHS Program
Previous Topic: Nutritional status of women
Goto Forum:
  


Current Time: Sat Dec 3 20:02:32 Coordinated Universal Time 2022