2013 Namibia DHS data: Numbers not matching [message #13540] |
Fri, 17 November 2017 07:42 |
jwichmannza
Messages: 3 Registered: October 2017 Location: South Africa
|
Member |
|
|
I am using the 2013 Namibia DHS data in one of the projects of my MPH students here at the University of Pretoria.
Please refer to Table 11.5 in the report.
I do not get these numbers at all when I use the children's recode data set, namely NMKR61FL.
e.g. below are the numbers/frequencies for the age categories I get
The SAS System 09:45 Thursday, November 16, 2017 16
The FREQ Procedure
Cumulative Cumulative
agecat Frequency Percent Frequency Percent
ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ ƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒƒ
1 271 13.93 271 13.93
2 251 12.90 522 26.84
3 430 22.11 952 48.95
4 374 19.23 1326 68.17
5 323 16.61 1649 84.78
6 296 15.22 1945 100.00
Frequency Missing = 3101
data xxx ;
set xxx ;
agecat = . ;
if hw1 ne . and hw1 > 47 then agecat = 6;
if hw1 ne . and hw1 < 48 then agecat = 5;
if hw1 ne . and hw1 < 36 then agecat = 4;
if hw1 ne . and hw1 < 24 then agecat = 3;
if hw1 ne . and hw1 < 12 then agecat = 2;
if hw1 ne . and hw1 < 6 then agecat = 1;
run;
I get many missing values for the age categories, even in the FREQ file it is the same.
|
|
|