The DHS Program User Forum: Service Provision Assessment (SPA) » Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15

Home » Topics » Service Provision Assessment (SPA) » Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 (2014-15 TSPA)

Show: Today's Messages :: Show Polls :: Message Navigator

Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 [message #23315 is a reply to message #23300]

Mon, 23 August 2021 00:21

shakim
Messages: 10
Registered: January 2021

Member

Dear Sara,

Thanks a lot for your kindest support and I was able to reproduce the tables with your help.
Now, I want create some variables from Nepal SPA 2015 using STATA. I have tried with the following codes-
gen wt=facwt/1000000
Table 3.3:
*Regular electricity
gen elec=0
replace elec=1 if q340==1 & q341==1
replace elec=1 if (q343a==1 | q343b==1) & q345==1 & q346==1
replace elec=1 if q343c==1
tab elec [iw=wt],m
Table 3.5.1:
*Soap and running water or else
alcohol-based hand disinfectant
gen swatrub=0
replace swatrub=1 if (q710_02==1 & q710_01==1) | q710_03==1
tab swatrub [iw=wt]
Table 3.7.3:
*Xray machine
gen xray=0
replace xr=1 if (q881a_2==1 & q881b_2==1)
tab xray [iw=wt]
*Full blood count
gen blood_count=0
replace blood_count=1 if q802a_1==1 & q802b_1==1 & q802c_1==1
tab blood_count [iw=wt]
*Liver or renal function test
gen lrt=0
replace lrt =1 if q834==1 & q835==1
tab lrt [iw=wt]

It looks like I am using the correct variables. Unfortunately, I am not getting the percentages as of the tables in Nepal 2015 report.
Please help me in recreating the above variables in STATA.

Regards,
Shakim

Report message to a moderator

[Message index]

		Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: shakim on Tue, 17 August 2021 12:07
		Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: SaraDHS on Wed, 18 August 2021 11:13
		Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: shakim on Mon, 23 August 2021 00:21
		Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: SaraDHS on Mon, 23 August 2021 13:20
		Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: foysal on Tue, 24 August 2021 14:28
		Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: shakim on Tue, 24 August 2021 14:34
		Re: Replicating table 3.3 and 3.7 in Tanzania SPA 2014-15 By: SaraDHS on Wed, 25 August 2021 14:20

Previous Topic:	Replicating table in DR Congo SPA 2017-18
Next Topic:	Creating some variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Nov 7 08:29:49 Coordinated Universal Time 2025