The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » General Data Questions » 2013 Namibia DHS data: Numbers not matching
2013 Namibia DHS data: Numbers not matching [message #13540] Fri, 17 November 2017 07:42 Go to previous message
jwichmannza is currently offline  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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Is the DHS data a longitudinal one?
Next Topic: Question on Benin's Raw Service Availability Data 2006
Goto Forum:
  


Current Time: Sat Apr 27 20:02:47 Coordinated Universal Time 2024