The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Bangladesh 2014
Bangladesh 2014 [message #13290] Fri, 13 October 2017 14:40 Go to previous message
loudermilke is currently offline  loudermilke
Messages: 1
Registered: October 2017
Location: College of Public Health
Member
Hello,

I am interested in looking at oral rehydration therapy, wealth index, blood in stools, and having eaten or drank while having diarrhea in the past two weeks. I am using SAS. I am missing a lot of data. Below is my code. Can you help me determine where I am making a mistake and why I have over 7,000 observations missing? I started out with 7,886 and have not yet deleted any missing. Also, when I compare my statistics to the Bangladesh statistics from 2014, I do not get the same numbers.

Thank you in advance for your help!


libname bds 'E:\Quinn_GA\BD_2014\bdkr72sd';
data bds.new;
set bds.bdkr72fl;
run;

proc contents data=bds.new;
run;
/*
H38: Had diarrhea in last two weeks: amount offered to drink
H39: had diarrhea in last two weeks: amount offered to eat
H11B: Blood in the stools
V113: Source of drinking water
V190: Wealth index
H11: had diarrhea recently-Whether the child had diarrhea in the last 24 hours
or within the last two weeks
B8: Current age of child
H13: received oral rehydration therapy
*/

data bds.new1;
set bds.new;
keep h38 h39 h11b v113 v190 h11 b8 h13 S510JG;
run;
proc contents data=bds.new1;
run;
proc freq data=bds.new1;
tables h38 h39 h11b v113 v190 h11 b8 h13 S510JG;
run;

data bds.new2;
set bds.new1;

if b8 <=5 then child=1;
Else delete;

if h11 = 2 then diarrhea=1;
if h11 = 0 then diarrhea=0;


if h11b = 0 then blood=0;
if h11b = 1 then blood=1;


run;

proc freq data=bds.new2;
tables (child blood v190)*diarrhea h13 h13*diarrhea;
run;
/*Total of 370 children had diarrhea; 15.4% of them had blood in their stools*/
proc freq data=bds.new2;
tables diarrhea child child*diarrhea blood blood*diarrhea; run;
/*Sample: 7,541, 4.92% of children under the age of 5 had diarrhea in the last 2 weeks*/

proc contents data=bds.new2;
run;

proc freq data=bds.new2;
tables h38 h39 h11b v113 v190;
run;


EL
 
Read Message
Read Message
Previous Topic: using NFHS I from India
Next Topic: POSTNATAL CARE FOR NEWBORN
Goto Forum:
  


Current Time: Fri Mar 29 06:47:49 Coordinated Universal Time 2024