Hae guys kindly help me figure out this.i have a integer variable which is categorized into 3 measurements;hours,days and weeks.So that week for example is 1,2,34,5 and same for hour and days.My question is now,how do get 1 for example for hours and not for weeks.
NB:For those familiar with KDHS dataset,this is the variable m71_1 in KDHS 2014 for individual record/women data.This data can be downloaded from http://www.dhsprogram.com .
The variable when tab in stata is as follows:
time after delivery |
postnatal check took |
place | Freq. Percent Cum.
--------------------------+-----------------------------------
immediately/in first hour | 723 15.96 15.96
hours: 1 | 616 13.60 29.56
102 | 274 6.05 35.61
103 | 153 3.38 38.98
104 | 84 1.85 40.84
105 | 51 1.13 41.96
106 | 82 1.81 43.77
107 | 15 0.33 44.11
108 | 24 0.53 44.64
109 | 14 0.31 44.94
110 | 10 0.22 45.17
111 | 5 0.11 45.28
112 | 39 0.86 46.14
113 | 2 0.04 46.18
114 | 6 0.13 46.31
115 | 1 0.02 46.34
116 | 2 0.04 46.38
120 | 1 0.02 46.40
123 | 1 0.02 46.42
124 | 1 0.02 46.45
130 | 1 0.02 46.47
days: 1 | 214 4.72 51.19
202 | 121 2.67 53.86
203 | 102 2.25 56.11
204 | 49 1.08 57.20
205 | 28 0.62 57.81
206 | 20 0.44 58.26
207 | 28 0.62 58.87
208 | 3 0.07 58.94
209 | 3 0.07 59.01
210 | 10 0.22 59.23
211 | 3 0.07 59.29
212 | 1 0.02 59.32
214 | 4 0.09 59.40
216 | 1 0.02 59.43
217 | 1 0.02 59.45
218 | 1 0.02 59.47
219 | 1 0.02 59.49
228 | 1 0.02 59.51
230 | 2 0.04 59.56
231 | 1 0.02 59.58
weeks: 1 | 355 7.84 67.42
302 | 509 11.24 78.65
303 | 161 3.55 82.21
304 | 301 6.64 88.85
305 | 26 0.57 89.43
306 | 376 8.30 97.73
307 | 13 0.29 98.01
308 | 41 0.91 98.92
309 | 4 0.09 99.01
312 | 2 0.04 99.05
316 | 1 0.02 99.07
321 | 1 0.02 99.09
324 | 1 0.02 99.12
336 | 1 0.02 99.14
don't know | 39 0.86 100.00
--------------------------+-----------------------------------
Total | 4,530 100.00