Missouri Census Data Center

Population Estimates by Age -- Online Help

Rev. 10/24/2012

Overview

This application lets you access population estimates by age, race, sex and hispanic orgin at the state and county levels for anywhere in the United States. You can choose years starting with 1990 and going to the most recently released figures (currently 2011, typically updated in August/September of each year with the previous year's data).

The revised version (Oct. 2012) provides access to new estimates for 2010 and 2011. These are post-censal estimates based on using the 2010 census figures as the base. Unfortunately, the data being used here for the decade 2000-2009 are still the post-censal estimates from that decade. We hope to replace these soon with intercensal estimates for that decade. We have indications that such a file will be made available to us in the not-too-distant future.

The source of these data is the special "bridged race" estimates created by the Census Bureau for the National Center for Health Statistics (NCHS). For more information regarding these estimates see our Readme page regarding that data. Users familiar with the Missouri Census Data Center's Uexplore/Dexter system for accessing data can access these data directly using those web tools and access the nchsbri subdirectory of our /pub/data/popests directory. But using this application will be a lot easier and will do most of the things that Dexter that will do.

Specifying the Parameters

Running the Request and Retrieving the Results

After making all your parameter choices you click on the Run Request button at the bottom of the form to invoke the application and pass it all your choices. If all goes well, your browser screen should turn a light blue and output results should begin appearing, first a link to a Summary Log file and a message indicating ...extraction work in progress...Please be patient. Within a few seconds (depends on how much data you requested, but typical requests take only a few seconds) links to the requested output file(s) should appear in your browser window followed by an Execution completed at ... line telling you that the application has finished its work.

If you have problems and need help you can send e-mail to the author (use the link at the very bottom of the application form) and be sure to specify the Job ID which appears on the second line of your output page. It consists of the date and a sequential number, e.g. 12OCT24_00003.

Generated files will remain on the mcdc site for 48 hours. You can capture the URL of any of your output files by right-clicking on the link to the file which appears on your output menu page, and then choosing the option that lets you copy that URL to the clipboard. You can then paste that value into an e-mail message (for example) in order to provide easy access to the result to someone else.

Output File(s)

The output files created by the application will be made up of one row/line/observation for each geographic area, year and age group. In addition to the age groups specified by the user on the form, there will also be an output row with "-All-" as the age group value; this row contains data for all persons without respect to age. The output is sorted by geographic area (state totals before county numbers, in FIPS code order), year (earliest years first) and age group (with the -All- summary preceding the specified intervals which are in ascending age order). The columns/variables include State, the name of the area summarized, the Year, an AgeGrp variable (with values of "-All-" or <low> to <high> where <low> is the lower end of the interval and <high> is the upper end.) If the interval is open-ended at the top then the dash and upper limit will be replaced by a "+", e.g. "65+" rather than "65-99". The other columns will be based upon the variables the user chose off the form. For each of those variables a corresponding percentage value will also be added. In the case of the Total population variable there is a PctAgeGrp variable which is the total population for this age group as a percentage of the geographic area's total population (for all ages). For all other variables the percentage variable will be derived by taking that variable's value as a percentage of the total population for the row (age group). So, the variable Black contains the count of persons who are counted as black or African American (bridged definition), and the PctBlack variable will indicate what percentage of the row's total population is black. For example, for the state of Missouri for year 2005, for the age in terval 0 to 17 the value of the variable Black is 216,172 and the value of Total is 1,378,232 . PctBlack is 15.7, which is 216,172 as a percentage of 1,378,232. In this same row the value of PctAgeGrp is 23.8, which indicates that 23.8% of the state's population in 2005 was in the age cohort 0-17.

For csv and SAS output files a column/variable named FIPS containing the federal code for the state or county is included. This column does not appear in HTML reports. Unfortunately, Excel strips the leading 0's from this code when it imports a csv file.

On SAS datasets the variables State and County are stored as codes but display as names using custom SAS format codes. This can cause an error when attempting to open in SAS unless you either

  1. tell it to ignore the format codes or
  2. provide SAS with access to those format codes.

To do the former just submit the SAS statement

                  options nofmterr; .

To provide access to the format codes you can access the necessary SAS code on the MCDC web site at http://mcdc2.missouri.edu/cgi-bin/browse?/pub/sasfmats/state_county.sas@. You need to include this code as a step in your SAS program to define the 2 format codes prior to attempting to open the extract dataset. You may want to edit the proc format source code if you are only planning to access data for one or just a few states.


This file last modified Wednesday October 24, 2012, 07:34:39

Site Map    |    Our URL    |   
The Missouri Census Data Center is a sponsored program of the Missouri State Library within the office of the Missouri Secretary of State. The MCDC has been a partner in the U.S. Census Bureau's State Data Center program since 1979.

Questions/Comments regarding this page or this web site are strongly encouraged and can be sent to