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

]]>

Thank you!]]>

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

Thank you very much!]]>

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;

]]>

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:

No: 3978

Yes: 1050

DK: 26

Total: 5054

No: 3963

Yes: 1148

DK: 29

Total: 5140

]]>

Thank you very much for your kind responses. That helped me a lot]]>