Are you using Stata? In Stata, the stratum variable can be constructed for this survey with "egen stratum=group(v024 v025)". By itself, v025 is urban/rural residence and cannot be used as the stratum variable. For your other question, please identify specific numbers in tables 3.1 and 2.14 that you believe are inconsistent. Have you tried to match these numbers yourself, using the data files?

]]>

COMPUTE filter_$=(HV105 >= 5).

VARIABLE LABELS filter_$ 'HV105 >= 5 (FILTER)'.

VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.

FORMATS filter_$ (f1.0).

FILTER BY filter_$.

EXECUTE.

*SELECT VALID CASES IN THE VARIABLES SH29 SH25 SH27 SH24 SH26 SH28.

COMPUTE filter_$=(NVALID(SH25) and NVALID(SH29) and NVALID(SH27) and NVALID(SH24) and NVALID(SH26) and NVALID(SH28) ).

* DISTRIBUTION OF HOUSEHOLD MEMBERS OF AGE FIVE YEARS AND OVER BY THE DEGREE OF DIFFICULTY ACCORDING TO FUNCTIONAL AREA.

FREQUENCIES VARIABLES=SH29 SH25 SH27 SH24 SH26 SH28

/ORDER=ANALYSIS.

With this analysis i got a total number of individuals of 36585 instead of 35,226 as shown in table 2.14.

I will also appreciate if am shown how to construct the stratum variable using SPSS.

Thank you.

Nicholas.

]]>

The command in Stata to get the percentage distribution for sh24 in table 2.14, and the total of 35,226 is the following:

use UGPR60FL.dta

tab sh24 [iweight=hv005/1000000] if hv105>=5 & hv105<96 & hv103==1

Here I am excluding cases with hv105>=96, which are basically missing on age. This gives a total of 35,226 weighted cases. Same for sh25 through sh29.

I cannot tell you how to construct a stratum variable in SPSS, because I do not use SPSS. In Stata it would be egen stratum=group(hv024 hv025). Here is another way to do it that does not use egen and group, which are strictly Stata commands.

If you do "tab hv024 hv025" you will see that there are 10 regions and 2 places of residence. There are not 20 combinations, however, because Kampala is completely urban. There are 19. Try this (translated to Stata): "gen stratum=hv024+9*(hv025-1)". There are other ways to do a recode, but this will give the urban parts of the regions as strata 1-10 and the rural parts, excluding Kampala, as 11-19.

]]>

Nicholas

]]>