To find the variables for water, first use the lookfor command.
lookfor water
165. wsame byte %9.0g wsame 1 :drinking + other water sourc 166. wsource_ byte %9.0g wsource_ 2 :code:main water source 167. wsupply byte %9.0g wsupply 3 :get all water needed? 168. wfetch byte %9.0g 4 :fetch water daily? 169. wdist_c byte %9.0g wdist_c 5 :code:distance to water
The variables listed here include the two needed variables for this problem. "Wsupply" stands for whether or not a family gets all the water that they need daily. "Wdist_c" is the categorical variable for how far a family has to go to fetch water daily. Now we do a crosstab. Use the command "tab wdist_c wsupply" getting rid of negative values to get the following table:
tab wdist_c wsupply if wdist_c>=0 & wsupply>=0
5 |
:code:dist |
ance to | 3 :get all water needed?
water | 01-yes m 02-somet 03-no mo | Total
-----------+---------------------------------+----------
01-less | 960 128 52 | 1140
02-100m | 765 167 66 | 998
03-500m | 183 119 86 | 388
04-1km - | 79 87 39 | 205
-----------+---------------------------------+----------
Total | 1987 501 243 | 2731
Studying the codes from the survey, we know that 1 stands for "yes" for the "Do you get all the water you need daily?" variable and 4 stands for "1 kilometer or more" for the "distance to water" variable. Therefore, we can simply look at the chart to find that 79 people get all the water they need daily by fetching it from more than one kilometer away everyday.