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


How come my .dat file has one column and all rows contain the same numerical ...
Are respondents in the IPUMS higher ed surveys also in the IPUMS USA surveys?...
What observations would be coded as observations not applicable in MIGRATE1?
Match rate between consecutive ASEC years
Merging accounts
Labor and capital income in the CPS
Login   |   Register

Recently Active Members

View More »

Share |