Status:Closed    Asked:Nov 09, 2017 - 11:20 AM

How to calculate the population of a specific year (for example 1974) with decennial census data of 1970 and 1980.

With decennial census data( population, for example 1970 and 1980) i would like to calculate the population of specific years (for example 1974). The dataset is in a panel structure where in the columns are the decennial census data and in the rows the cities (nhgiscode) and the years i would like to calculate the population for in a new variable. Is there a specific command (STATA preferred) i can use or some other possibilities?

As you can see in the image the population of ´70 and ´80 is given and i want to fill the variable popnew.

Thank you for your help!

kind regards


Do you have the same question? Follow this Question


Dear Nicolai,

The most straightforward way to create intercensal estimates is thru linear interpolation. You would subtract the pop70 value from pop80 (40165-20411 = 19574) in your example. Then I would divide the difference by 9 (19574 / 9 = 2174.9). I would then set the 1971 value equal to the pop70 + 2174.9. Finally, loop through all the years, adding 2174.9 to each prior year.

I don't know the exact stata commands to execute this, but that is the basi algorithm.


Nov 10, 2017 - 12:41 PM

Report it


The degree of disability in Indonesia 2010 census has three levels but the ta...
Occupation by MSA
Besides the variable for limitations with IADL, are there any other variables...
CPS Volunteer Supplement 2002-2015 - Differences between vlstatus and vlhallo...
When did IPUMS-CPS start like the way (easily downloadable way) like now?
Replicate weights for use with CPS-TUS
Login   |   Register

Recently Active Members

View More »

Share |