Dear Statalist Members,
I am running into a peculiar issue with Stata 15.1 with the following [i believe] straightforward addition command
Code:
cap drop india50
bysort areacode2 ageGrp  : egen india50 = total(india50_bysex)
This should yield 96371150 + 95693199 = 192064349
However I am getting 192064352 as the data output.
Any suggestions why this might be happening
Thanks
Vivek


Code:
* PRE - DATA
* Example generated by -dataex-. To install: ssc install dataex
clear
input float areacode2 byte(ageGrp sex) double india50_bysex
1 1 1 96371150
1 1 2 95693199
1 2 1 96371150
1 2 2 95693199
1 3 1 96371150
1 3 2 95693199
1 4 1 96371150
1 4 2 95693199
end
label values areacode2 area2lb
label def area2lb 1 "Jammu", modify
label values ageGrp ageGrp
label def ageGrp 1 "50-59", modify
label def ageGrp 2 "60-69", modify
label def ageGrp 3 "70-79", modify
label def ageGrp 4 ">=80", modify
label values sex sexlb
label def sexlb 1 "Male", modify
label def sexlb 2 "Female", modify
Code:
* POST COMMAND - DATA
* Example generated by -dataex-. To install: ssc install dataex
clear
input float areacode2 byte(ageGrp sex) float india50 double(india50_bysex india50_byagesex)
1 1 1 192064352 96371150 45299278
1 1 2 192064352 95693199 42916031
1 2 1 192064352 96371150 31646075
1 2 2 192064352 95693199 32472615
1 3 1 192064352 96371150 14142102
1 3 2 192064352 95693199 14299243
1 4 1 192064352 96371150  5283695
1 4 2 192064352 95693199  6005310
end