The DHS Program User Forum: Child Health

Home » Topics » Child Health » Using svy: tab

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

Re: Using svy: tab [message #8518 is a reply to message #8420]

Sun, 08 November 2015 16:28

lexgw
Messages: 31
Registered: October 2015
Location: United Kingdom

Member

Hello,

In connection to the question I asked previously, I am able to replicate DHS 2011 statistics on child health for Uganda. But this is only when it is a one way tabulation (just one variable). When I make a two-way tabulation (with two variables) I do not replicate DHS statistics. I need help. For example, I generated an ARI variable when I tab it I get correct results but when I tab it with v024 (region), I do not get the figures in table 10.5 DHS report 2011 for Uganda page 129. This is what I get;

I generate ARI variable only for live children only (b5==1)
. gen ari=0 if b5==1
(1299 missing values generated)

. *ARI is defined as children with a cough with short rapid breaths (h31b==1) or/and congestion in the chest/blocked or runny nose
> (h31c==1 | h31c==3)*/
. replace ari=1 if b5==1 & h31b==1 & (h31c==1 | h31c==3)/*1 is for chest only 3 is for both chest & blocked nose*/
(2156 real changes made)

. svy: tab ari if survey==1
(running tabulate on estimation sample)

Number of strata = 19 Number of obs = 7355
Number of PSUs = 404 Population size = 7535.3926
Design df = 385

-----------------------
ari | proportions
----------+------------
0 | .8516
1 | .1484
|
Total | 1
-----------------------
Key: proportions = cell proportions
This seems fine because the report is talking about 15% of children with symptoms of ARI. but for the two I can replicate eg;
svy: tab v024 ari if survey==1
(running tabulate on estimation sample)

Number of strata = 19 Number of obs = 7355
Number of PSUs = 404 Population size = 7535.3926
Design df = 385

-------------------------------
| ari
region | 0 1 Total
----------+--------------------
kampala | .0533 .0086 .062
central | .0894 .0092 .0987
central | .0928 .0125 .1054
east cen | .096 .0171 .1131
eastern | .1419 .0284 .1704
north | .0691 .0196 .0887
karamoja | .0298 .0075 .0373
west-nil | .0509 .0083 .0592
western | .1211 .0244 .1454
southwes | .1072 .0127 .1199
|
Total | .8516 .1484 1
-------------------------------
Key: cell proportions

Pearson:
Uncorrected chi2(9) = 75.4301
Design-based F(7.78, 2996.03)= 3.4660 P = 0.0006

This is different from what is in table 10.5 page 129
svy: tab v106 ari if survey==1
(running tabulate on estimation sample)

Number of strata = 19 Number of obs = 7355
Number of PSUs = 404 Population size = 7535.3926
Design df = 385

-------------------------------
highest |
education | ari
al level | 0 1 Total
----------+--------------------
no educa | .1219 .0216 .1435
primary | .5357 .1002 .6359
secondar | .1627 .0222 .1849
higher | .0312 .0044 .0356
|
Total | .8516 .1484 1
-------------------------------
Key: cell proportions

Still different!! need help. thanks

Report message to a moderator

[Message index]

		Using svy: tab By: lexgw on Fri, 23 October 2015 11:03
		Re: Using svy: tab By: Trevor-DHS on Mon, 26 October 2015 14:42
		Re: Using svy: tab By: lexgw on Tue, 27 October 2015 12:18
		Re: Using svy: tab By: lexgw on Sun, 08 November 2015 16:28
		Re: Using svy: tab By: Trevor-DHS on Thu, 03 December 2015 12:55
		Re: Using svy: tab By: lexgw on Thu, 03 December 2015 13:21

Previous Topic:	Age in months: Missing values
Next Topic:	Running a regression with the KR file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 19 05:55:59 Coordinated Universal Time 2024