. use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\KEIR8AFL.DTA" , clear . . . . tab1 g100-g103 [iweight=v005/1000000],m -> tabulation of g100 ever heard | of female | circumcisio | n | Freq. Percent Cum. ------------+----------------------------------- no | 687.939934 2.14 2.14 yes | 16,033.26 49.86 52.00 . | 15,434.8 48.00 100.00 ------------+----------------------------------- Total | 32,156 100.00 -> tabulation of g101 ever heard | of genital | cutting | (probed) | Freq. Percent Cum. ------------+----------------------------------- no | 511.1265 1.59 1.59 yes | 176.813434 0.55 2.14 . | 31,468.061 97.86 100.00 ------------+----------------------------------- Total | 32,156 100.00 -> tabulation of g102 respondent | circumcised | Freq. Percent Cum. ------------+----------------------------------- no | 13,733.975 42.71 42.71 yes | 2,476.0991 7.70 50.41 . | 15,945.927 49.59 100.00 ------------+----------------------------------- Total | 32,156 100.00 -> tabulation of g103 flesh | removed | from | genital | area | Freq. Percent Cum. ------------+----------------------------------- no | 436.194903 1.36 1.36 yes | 2,010.282 6.25 7.61 don't know | 29.622192 0.09 7.70 . | 29,679.901 92.30 100.00 ------------+----------------------------------- Total | 32,156 100.00 . . . . gen fgm=. (32,156 missing values generated) . . replace fgm=0 if g100==0 | g102==0 (12,874 real changes made) . . replace fgm=1 if g102==1 | g103==1 (4,036 real changes made) . . tab fgm [iweight=v005/1000000] fgm | Freq. Percent Cum. ------------+----------------------------------- 0 | 14,245.101 85.19 85.19 1 | 2,476.0991 14.81 100.00 ------------+----------------------------------- Total | 16,721.2 100.00 . . . . * convert to a percentage . . replace fgm=100*fgm (4,036 real changes made) . . . . * get the percentages and n's by counties . . tab v024 fgm [iweight=v005/1000000], row +----------------+ | Key | |----------------| | frequency | | row percentage | +----------------+ | fgm region | 0 100 | Total ----------------+----------------------+---------- mombasa |474.364775 19.131311 |493.496086 | 96.12 3.88 | 100.00 ----------------+----------------------+---------- kwale |252.010447 7.813251 |259.823698 | 96.99 3.01 | 100.00 ----------------+----------------------+---------- kilifi |485.108176 3.718163 |488.826339 | 99.24 0.76 | 100.00 ----------------+----------------------+---------- tana river | 31.734826 47.7213 | 79.456126 | 39.94 60.06 | 100.00 ----------------+----------------------+---------- lamu | 46.708975 6.947806 | 53.656781 | 87.05 12.95 | 100.00 ----------------+----------------------+---------- taita taveta | 101.30427 20.802792 |122.107062 | 82.96 17.04 | 100.00 ----------------+----------------------+---------- garissa | 28.52436 134.313666 |162.838026 | 17.52 82.48 | 100.00 ----------------+----------------------+---------- wajir | 2.522808 87.218186 | 89.740994 | 2.81 97.19 | 100.00 ----------------+----------------------+---------- mandera | 4.606444 108.49319 |113.099634 | 4.07 95.93 | 100.00 ----------------+----------------------+---------- marsabit | 12.252072 59.747461 | 71.999533 | 17.02 82.98 | 100.00 ----------------+----------------------+---------- isiolo | 25.990614 50.488632 | 76.479246 | 33.98 66.02 | 100.00 ----------------+----------------------+---------- meru |395.905789 91.914261 | 487.82005 | 81.16 18.84 | 100.00 ----------------+----------------------+---------- tharaka-nithi | 95.887444 35.60284 |131.490284 | 72.92 27.08 | 100.00 ----------------+----------------------+---------- embu |146.322276 33.67213 |179.994406 | 81.29 18.71 | 100.00 ----------------+----------------------+---------- kitui |332.085769 41.364782 |373.450551 | 88.92 11.08 | 100.00 ----------------+----------------------+---------- machakos |525.779093 18.251498 |544.030591 | 96.65 3.35 | 100.00 ----------------+----------------------+---------- makueni |353.663354 2.401883 |356.065237 | 99.33 0.67 | 100.00 ----------------+----------------------+---------- nyandarua |209.848685 15.503425 | 225.35211 | 93.12 6.88 | 100.00 ----------------+----------------------+---------- nyeri |254.438274 6.422633 |260.860907 | 97.54 2.46 | 100.00 ----------------+----------------------+---------- kirinyaga |233.650547 28.550205 |262.200752 | 89.11 10.89 | 100.00 ----------------+----------------------+---------- murang'a |281.104164 58.326447 |339.430611 | 82.82 17.18 | 100.00 ----------------+----------------------+---------- kiambu | 1,037.281 62.776981 |1,100.0577 | 94.29 5.71 | 100.00 ----------------+----------------------+---------- turkana |171.101271 1.081779 | 172.18305 | 99.37 0.63 | 100.00 ----------------+----------------------+---------- west pokot |109.699269 86.833288 |196.532557 | 55.82 44.18 | 100.00 ----------------+----------------------+---------- samburu | 19.274113 59.580373 | 78.854486 | 24.44 75.56 | 100.00 ----------------+----------------------+---------- trans nzoia |329.657352 29.487111 |359.144463 | 91.79 8.21 | 100.00 ----------------+----------------------+---------- uasin gishu |504.750503 21.994466 |526.744969 | 95.82 4.18 | 100.00 ----------------+----------------------+---------- elgeyo-marakwet | 93.234892 22.821025 |116.055917 | 80.34 19.66 | 100.00 ----------------+----------------------+---------- nandi |324.152143 8.277381 |332.429524 | 97.51 2.49 | 100.00 ----------------+----------------------+---------- baringo | 152.19596 40.847866 |193.043826 | 78.84 21.16 | 100.00 ----------------+----------------------+---------- laikipia |154.540879 18.779056 |173.319935 | 89.17 10.83 | 100.00 ----------------+----------------------+---------- nakuru |753.269399 108.689466 |861.958865 | 87.39 12.61 | 100.00 ----------------+----------------------+---------- narok |183.018949 190.627382 |373.646331 | 48.98 51.02 | 100.00 ----------------+----------------------+---------- kajiado |343.912355 106.950041 |450.862396 | 76.28 23.72 | 100.00 ----------------+----------------------+---------- kericho |334.559587 37.53825 |372.097837 | 89.91 10.09 | 100.00 ----------------+----------------------+---------- bomet |251.057293 76.247688 |327.304981 | 76.70 23.30 | 100.00 ----------------+----------------------+---------- kakamega |649.779188 2.366463 |652.145651 | 99.64 0.36 | 100.00 ----------------+----------------------+---------- vihiga |199.272072 1.529529 |200.801601 | 99.24 0.76 | 100.00 ----------------+----------------------+---------- bungoma |553.440214 18.258821 |571.699035 | 96.81 3.19 | 100.00 ----------------+----------------------+---------- busia |336.005948 .211066 |336.217014 | 99.94 0.06 | 100.00 ----------------+----------------------+---------- siaya |273.424648 1.327663 |274.752311 | 99.52 0.48 | 100.00 ----------------+----------------------+---------- kisumu |391.583732 4.09988 |395.683612 | 98.96 1.04 | 100.00 ----------------+----------------------+---------- homa bay |336.122244 7.995344 |344.117588 | 97.68 2.32 | 100.00 ----------------+----------------------+---------- migori |281.373891 68.828389 | 350.20228 | 80.35 19.65 | 100.00 ----------------+----------------------+---------- kisii |105.197033 358.026525 |463.223558 | 22.71 77.29 | 100.00 ----------------+----------------------+---------- nyamira | 42.548123 125.937768 |168.485891 | 25.25 74.75 | 100.00 ----------------+----------------------+---------- nairobi | 2,020.836 136.579606 | 2,157.416 | 93.67 6.33 | 100.00 ----------------+----------------------+---------- Total |14,245.101 2,476.099 | 16,721.2 | 85.19 14.81 | 100.00 . . . . * estimates for Narok + Kisii . . tab v024 fgm [iweight=v005/1000000] if v024==33 | v024==45, row +----------------+ | Key | |----------------| | frequency | | row percentage | +----------------+ | fgm region | 0 100 | Total ----------------+----------------------+---------- narok |183.018949 190.627382 |373.646331 | 48.98 51.02 | 100.00 ----------------+----------------------+---------- kisii |105.197033 358.026525 |463.223558 | 22.71 77.29 | 100.00 ----------------+----------------------+---------- Total |288.215982 548.653907 |836.869889 | 34.44 65.56 | 100.00 . . . . * pooled estimate for Narok + Kisii . . tab fgm [iweight=v005/1000000] if v024==33 | v024==45 fgm | Freq. Percent Cum. ------------+----------------------------------- 0 | 288.215982 34.44 34.44 100 | 548.653907 65.56 100.00 ------------+----------------------------------- Total | 836.869889 100.00 . . .