| Replicating table in DR Congo SPA 2017-18 [message #23316] |
Mon, 23 August 2021 01:57  |
foysal
Messages: 6
Registered: August 2021
|
Member |
|
|
Dear DHS Experts and SPA Users,
How can I create a variable named "Overnight observation beds (any)" having two categories (Yes, No) using variable "q112" in DR Congo SPA 2017-18?
I also want to recreate some variables from table 3.3, 3.7.1, and 3.9.1 in STATA. I have tried with the following codes:
gen sw=facwt/1000000
Table 3.3-
*Electricity
gen ect=0
replace ect=1 if if (q340==1 & q341==1) | (q343a==1 | q343b==1) & q345==1 & q346==1 | q343c==1
tab ect [iw=sw]
Table 3.7.1:
I want to reproduce variables "Sterilization equipment", and "Equipment for high level disinfection". But, I did not find any value of the variable "sterequip" in the dataset for sterilization equipment. Also, I did not find variable "hldequip" for equipment for high level disinfection.
Table 3.9.1:
* X ray machine
gen xr=0
replace xr=1 if (q881a_2==1 & q881b_2==1)
tab xr [iw=sw]
It looks like I am looking the right variables for creating electricity and x ray machine variables, but for some reason I am not getting the percentages as of the tables. I would greatly appreciate any help on this matter.
Many thanks
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
