total population from 2000 census 5% sample


#1

Hi,

The total population calculated from the 2000 census 5% sample (using perwt) is 5.6e+08, which is almost twice as large as the actual total U.S. population in 2000.

Is there an explanation for this discrepency? The total population calculated from other years all seem quite reasonable.


#2

Is there any chance you have altered PERWT in 2000 or manipulated the data for 2000 in any other way? I just created an extract and checked the values and there doesn’t seem to be an issue. I would suggest re-saving your extract and trying the tabulation again.


#3

Thank you! I found my mistake – I have both the ACS and the 5% census for 2000, and collapsed two datasets together.

It’s all fixed now. Thank you for the quick response!