| 
		
			| 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.
 |  
	|  |  |