| Bangladesh 2014 [message #13290] |
Fri, 13 October 2017 14:40  |
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
|
|
|
|
Members
Search
Help
Register
Login
Home
