Home » Data » Weighting data » Weighing SPA data Tanzania
Re: Weighing SPA data Tanzania [message #11846 is a reply to message #11828] |
Fri, 17 February 2017 10:41 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
Nadia
Messages: 6 Registered: February 2017
|
Member |
|
|
Bridgette-DHS wrote on Wed, 15 February 2017 10:25Following is a response from DHS Senior Data Specialist, Claudia Marchena:
To get the results published in the report, you need to take the footnotes on the published table 3.3 into consideration.
Footnote:
1 Facility is connected to a central power grid and there has not been an interruption in power supply lasting for more than two hours at a time during normal working hours in the seven days before the survey, or facility has a functioning generator with fuel available on the day of the survey, or else facility has back-up solar power.
As explained in the footnote, the column on "Regular electricity" in table 3.3, uses the following logic to get the results published:
Logic:
(Q340=1 & Q341=1) or (poschar("AB",Q343) and Q345=1 and Q346=1) or pos("C",Q343)
Further explanations for logic:
Poschar("AB",Q343) is Q343 = A or Q343 = B
pos("C",Q343) is Q343 = C
The parenthesis are essential to delimit the conditions.
Regarding the weights and how to use them, they are explained in the survey documentation, TZSP71.doc. But basically each level of analysis has its own weights, Facility in variable FACWT, Provider in variable PROVWT, and client in variable CLIENTWT.
I finally found the facwt variable in the TZFC71FLSP 2014-2015. However, I still do not know if I need to weight the results of the table 3.3 or they already are the weighted values since the number of facilities corresponding to the different results reported are in fact the weighted number of facilities.
Regarding the replication of the results of the above mentioned table 3.3 and the code you provided,
tab factype if (q340==1 & q341==1) | (( q343=="A" | q343=="B") & q345==1 & q346==1) | (q343=="C"),[/b]
we get to far lower percentages than what reported in table 3.3
Thanks again for your help.
BR,
Nadia
|
|
|
Goto Forum:
Current Time: Sun Aug 18 12:07:53 Coordinated Universal Time 2024
|