The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » ARI among children
ARI among children [message #1634] Wed, 19 March 2014 16:42 Go to next message
user is currently offline  user
Messages: 11
Registered: March 2014
Member
Hi,

I was trying to see the determinants of childhood ARI in Nepal from the Birth/Child recode from NDHS 2011 dataset.
DHS report says that the final result includes 5140 children, but the question about cough was asked to total 5054 mothers only. How can i solve this issue?

I am expecting some help on that..Thank you very much.




tabulate h31

had cough in last
two weeks Freq. Percent Cum.

no 3,978 78.71 78.71
yes, last two weeks 1,050 20.78 99.49
don't know 26 0.51 100.00

Total 5,054 100.00
Re: ARI among children [message #1639 is a reply to message #1634] Thu, 20 March 2014 09:31 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,
We are working on a response. Can you provide the table number and page number you are looking at in the final report?
Thank you!
Re: ARI among children [message #1644 is a reply to message #1639] Thu, 20 March 2014 12:48 Go to previous messageGo to next message
user is currently offline  user
Messages: 11
Registered: March 2014
Member
Dear Liz

I was looking at Table 10.4 Prevalence of Symptoms of ARI, Page no 153. Final report NDHS 2011.

Thank you very much!
Re: ARI among children [message #1645 is a reply to message #1644] Fri, 21 March 2014 01:53 Go to previous messageGo to next message
Liz-DHS
Messages: 1516
Registered: February 2013
Senior Member
Dear User,

The unweighted number of cases is 5054, but the weighted number is 5140. So it is simply a matter of applying the weights: = V005 / 1000000;


I am not a programmer, but here is some code in CSPro for this standard table that may help you in figuring things out.
Please use your map and dictionary to work with the recode variables. You may also want
to reference the recode manual on our website. http://dhsprogram.com/pubs/pdf/DHSG4/Recode6_DHS_22March2013 _DHSG4.pdf

Table definition
crosstab float(1) t1005 chage1+sex2+v463w+hv226w1+v102w+v101w+SHDEVREG+v106wt+v190w+ total
col1005a+col1005b
exclude(rowzero,colzero,percents,totals,specval)
title( "Table 10.5 Prevalence and treatment of symptoms of ARI","",
"Among children under age five, the percentage who had symptoms of acute",
"respiratory infection (ARI) in the two weeks preceding the survey and ",
"among children with symptoms of ARI, the percentage for whom advice or",
"treatment was sought from a health facility or provider and percentage",
"who received antibiotics as treatment, according to background",
"characteristics, Nepal 2011" )
stub( "Background characteristic" );

************************************************************ ************************************************************ ******
for i in REC43_EDT do
months = V008 - B3(HIDX);
box months => chage1;
0-5 => 0;
6-11 => 1;
12-23 => 2;
24-35 => 3;
36-47 => 4;
48-59 => 5;
endbox;
sex2 = B4(HIDX);

if B5(HIDX) = 1 then { for living children }
col1005b = notappl;
if H31B = 1 & H31C in 1,3 then { ARI }
col1005a = 1;
xtab( t1005, rweight );
endif;
col1005a = 2; { all children }
xtab( t1005, rweight );
col1005a = notappl;
if H31B = 1 & H31C in 1,3 then { ARI }
if H32A = 1 | H32B = 1 | H32C = 1 | H32D = 1 | H32E = 1 |
H32F = 1 | H32G = 1 | H32H = 1 | H32I = 1 | H32J = 1 |
H32L = 1 | H32M = 1 | H32N = 1 | H32O = 1 | H32P = 1 |
H32Q = 1 | H32R = 1 then
col1005b = 1; { Pharmacy, shop and traditional practitioner excluded }
xtab( t1005, rweight );
endif;
{ !! if malaria module exist, this category comes from variables ML13x }
{ Wrong if H37I = 1 | H37J = 1 then { antibiotics given }}
col1005b = notappl;
if H37F = 1 | H37G = 1 | H37H = 1 | H37I = 1 | H37J = 1 then
col1005b = 2;
xtab( t1005, rweight );
endif;
{
if H37F = 1 then
errmsg("H37F");
endif;
if H37G = 1 then
errmsg("H37G");
endif;
if H37H = 1 then
errmsg("H37H");
endif;
if H37I = 1 then
errmsg("H37I");
endif;
if H37J = 1 then
errmsg("H37J");
endif;

if H37F = 1 | H37G = 1 | H37H = 1 | H37I = 1 | H37J = 1 then
errmsg("ALL");

if col1005b = notappl then
errmsg("%d %d %d %d %d (%d)", H37F, H37G, H37H, H37I, H37J, rweight);
endif;
endif;
}
col1005b = 3; { all children with ARI }
xtab( t1005, rweight );

{ Table CS10a and CS10c - added by rajendra }

if H32A = 1 then colCS10a = 1; xtab( CS10a, rweight ); endif;
if H32B = 1 then colCS10a = 2; xtab( CS10a, rweight ); endif;
if H32C = 1 then colCS10a = 3; xtab( CS10a, rweight ); endif;
if H32D = 1 then colCS10a = 4; xtab( CS10a, rweight ); endif;
if H32E = 1 then colCS10a = 5; xtab( CS10a, rweight ); endif;
if H32F = 1 then colCS10a = 6; xtab( CS10a, rweight ); endif;
if H32G = 1 then colCS10a = 7; xtab( CS10a, rweight ); endif;
if H32M = 1 then colCS10a = 8; xtab( CS10a, rweight ); endif;
if H32N = 1 then colCS10a = 9; xtab( CS10a, rweight ); endif;
if H32O = 1 then colCS10a = 10; xtab( CS10a, rweight ); endif;
if H32J = 1 then colCS10a = 11; xtab( CS10a, rweight ); endif;
if H32K = 1 then colCS10a = 12; xtab( CS10a, rweight ); endif;
if H32P = 1 then colCS10a = 13; xtab( CS10a, rweight ); endif;
if H32S = 1 then colCS10a = 14; xtab( CS10a, rweight ); endif;
if H32T = 1 then colCS10a = 15; xtab( CS10a, rweight ); endif;
if H32X = 1 then colCS10a = 16; xtab( CS10a, rweight ); endif;
colCS10a = 17; xtab( CS10a, rweight ); { number of children with ARI }

if H37B = 1 then colCS10c = 1; xtab( CS10c, rweight ); endif;
if H37C = 1 then colCS10c = 2; xtab( CS10c, rweight ); endif;
if H37D = 1 then colCS10c = 3; xtab( CS10c, rweight ); endif;
if H37E = 1 then colCS10c = 4; xtab( CS10c, rweight ); endif;
if H37F = 1 then colCS10c = 5; xtab( CS10c, rweight ); endif;
if H37G = 1 then colCS10c = 6; xtab( CS10c, rweight ); endif;
if H37H = 1 then colCS10c = 7; xtab( CS10c, rweight ); endif;
if H37I = 1 then colCS10c = 8; xtab( CS10c, rweight ); endif;
if H37J = 1 then colCS10c = 9; xtab( CS10c, rweight ); endif; {other antibiotics}
if H37K = 1 then colCS10c = 10; xtab( CS10c, rweight ); endif;
if H37L = 1 then colCS10c = 11; xtab( CS10c, rweight ); endif;
if H37M = 1 then colCS10c = 12; xtab( CS10c, rweight ); endif;
if H37X = 1 then colCS10c = 13; xtab( CS10c, rweight ); endif;
if H37Z = 1 then colCS10c = 14; xtab( CS10c, rweight ); endif;
if H37Y = 1 then colCS10c = 15; xtab( CS10c, rweight ); endif;
colCS10c = 17; xtab( CS10c, rweight ); { number of children with ARI }

{ Table CS10a and CS10c - added by rajendra }

endif;
endif;
enddo;

[Updated on: Fri, 21 March 2014 17:52]

Report message to a moderator

Re: ARI among children [message #1649 is a reply to message #1645] Fri, 21 March 2014 13:55 Go to previous messageGo to next message
Kia-DHS is currently offline  Kia-DHS
Messages: 5
Registered: March 2013
Location: DHS
Member
Dear user,
The difference between the numbers you are getting in your tabulation of h31 and the number in Table 10.4 is that your tabulation is unweighted, while Table 10.4 is calculated on weighted data. All tables in DHS Final Reports are weighted data (unless the title specifies otherwise).

The DHS is a survey sample, so in order for the data to be representative of the population, it is necessary to apply weights (so most applications of using the data need to use weighted data). For information about weighting the data, please go to this resource on our website: http://www.dhsprogram.com/data/Using-DataSets-for-Analysis.c fm:

The Unweighted Frequency of h31:
No: 3978
Yes: 1050
DK: 26
Total: 5054


The Weighted Frequency of h31:
No: 3963
Yes: 1148
DK: 29
Total: 5140

Re: ARI among children [message #1653 is a reply to message #1634] Sat, 22 March 2014 08:56 Go to previous message
user is currently offline  user
Messages: 11
Registered: March 2014
Member
Dear Liz & Kia

Thank you very much for your kind responses. That helped me a lot
Previous Topic: Birth Interval-Data Missing
Next Topic: child feces disposal
Goto Forum:
  


Current Time: Fri Dec 27 04:58:25 Coordinated Universal Time 2024