However, when i took the 2d group (married men who have one son), and manually summarise the number of sons at home with the number of sons living elsewhere, the amount does not correspond to the results in SPSS frequency table. Sons at home of 169 + sons elsewhere of 41 should give 210, however in the frequency table for living sons there is 167. Pls see below.

In this regards, I would appreciate for your advice in two questions:

1) whether my above steps were right to get a total number living sons as a sum of MV202 (sons at home) and MV204 (sons elsewhere)?

2) why there is a different result for living sons?

best regards,

]]>

Thanks]]>

Please do a crosstab between MV202 and MV204 in your sub-sample.

I do not have your sub-sample, but like you, I created a variable 'SONSLIV' for the total Kyrgyztan male data file using COMPUTE and produced the attached frequencies for MV202, MV204 and SONSLIV in Excel. I found 590 men with 1 child alive.

The crosstab of MV202 and MV204 (also attached) gives 526 men with 1 son at home (and none elsewhere) and 64 with 1 elsewhere (but none at home). 526 + 64 gives 590, which matches the number in 'SONSLIV'.

Please let me know if I misunderstood your problem.

Thanks,

Albert Themme

]]>

hello. thank you very much for your responce. Sorry, i could not give feedback earlier. as per your advice, i also used a command "Compute variables" on the whole sample of men. I agree that what you wrote is workable for men with sons living elsewhere and sons living at home having one son. I also received total living sons 590. But what about men who have two sons, three sons?

For example, 339 men having 2 sons at home and zero elsewhere plus 17 men having two sons elsewhere and none at home (339+17) would give us 356 men. However, in the Sonslive it is 404. maybe i did something wrong?

Would appreciate for your advice.

thank you again.]]>

I clarified uncenrtainties with the sum of MV202 and MV204. Two Sons at home (339) plus one son elsewhere and one son at home (48) plus two sons elsewhere and no sons at home (17) give 404 which matches the number on Sonslive.

best regards.]]>