Status:Closed    Asked:Oct 04, 2015 - 09:56 AM

Creating kenya population estimates

Hi, I'm new to using and analyzing IPUMS data.

I'm trying to use IPUMS data for Kenya to estimate population densities by district in Kenya over time. (And am also interested in other variables in association with population).

Is there a way to use the IPUMS data to make population density estimates? I am guessing that I will have to arrange the data in Stata first by district, though I'm not sure how to do that.

Also, when exporting data from Stata into Excel or .cvs to be used in arcGIS, I know that there are case number limitations. Will this be solved if I arrange the data differenty (such as by district?)

Thanks so much

Do you have the same question? Follow this Question

Staff Answer




It is not possible to directly estimate district-level population density for Kenyan districts over time purely using IPUMS-International microdata. Rather, you can estimate the population of a district with IPUMS data and then use a non-IPUMS source to determine the area of the district. The population of a district is simply the sum of the PERWT values for each respondent in that district.

Note that the boundaries of Kenyan districts have changed over time. The IPUMS district variable, GEO2_KEX, harmonizes districts by name, but it does not account for the inconsistent boundaries. As a result, GEO2_KEX is not perfectly comparable over time.

As for exporting from STATA to Excel for use in ArcGIS, yes, you will want to group your output by districts, instead of exporting one observation per respondent.

Hope this helps.


Oct 05, 2015 - 03:44 PM

Report it


Is there a way that I can convert a DAT file to a STATA file? If so, how is t...
Underlying files for CPS Education Supplements (October)?
Income varialbe values & US variable
Why there is no data for 'VLHALLORG"
.CVS format data uploaded into EXCEL
County Codes
Login   |   Register

Recently Active Members

View More »

Share |