The DHS Program User Forum: Service Provision Assessment (SPA)

Home » Topics » Service Provision Assessment (SPA) » Creating two variable (SPA )

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

Re: Creating two variable [message #23376 is a reply to message #23369]

Tue, 31 August 2021 02:35

rasel
Messages: 2
Registered: August 2021

Member

Dear Sara,

Thanks for your help and I was able to recreate variables.
Now, I want to create the variable regular electricity of table 3.3 in DR Congo SPA 2017-18. I have tried with the following codes:
gen sw=facwt/1000000
gen q343a=regexm(q343, "A")
gen q343b=regexm(q343, "B")
gen q343c=regexm(q343, "C")
gen q343d=regexm(q343, "D")
gen ect=0
replace ect=1 if q340==1 & q341==1
replace ect=1 if (q343a==1 | q343b==1) & q345==1 & q346==1
replace ect=1 if q343c==1
replace ect=1 if q343d==1
tab ect [iw=sw]
But unable to match the % with the report table. I wish your help to create this variable.

Regards,
Rasel

Report message to a moderator

[Message index]

		Creating two variable By: rasel on Thu, 26 August 2021 09:20
		Re: Creating two variable By: SaraDHS on Mon, 30 August 2021 08:31
		Re: Creating two variable By: rasel on Tue, 31 August 2021 02:35
		Re: Creating two variable By: SaraDHS on Tue, 31 August 2021 09:26

Previous Topic:	Creating some variables
Next Topic:	SPA variables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Aug 27 09:19:18 Coordinated Universal Time 2025