U.S. Department of Commerce

Survey of Public Pensions: State Data

Skip top of page navigation
You are here: Census.govBusiness & IndustryFederal, State, & Local GovernmentsSurvey of Public Pensions: State DataHow the Data are Collected › Data Processing
Skip top of page navigation

Data Processing: 2012

Editing

Editing is a process that ensures survey data are accurate, complete, and consistent. Efforts are made at all phases of collection, processing, and tabulation to minimize errors. Although some edits are built into the Internet data collection instrument and the data entry programs, the majority of the edits are performed after the case has been loaded into the Census Bureau's database.

Edits consist primarily of two types: consistency and a ratio of the current year's reported value to the prior year's value. The consistency edits check the logical relationships of data items reported on the form. For example, if a value exists for the number of retirees receiving benefits because of age or length of service then there must be a value reported for the amount paid. The current year/prior year edits compare by item code the data reported for the current year with data reported for the prior year. If data fall out of acceptable tolerance levels, the item is flagged for review.

For both types of edits, the edit results are reviewed by analysts and adjusted when needed. When the analyst is unable to resolve or accept the edit failure, contact is made with the respondent to verify or correct the reported data.


Imputation

Not all respondents answer every item on the questionnaire. Imputation is the process of filling in missing or invalid data with reasonable values in order to have a complete data set.

The imputations were based on either a prior year annual survey or the most recent Census of Governments. All but six missing variables (Z90, Z95 and four relatively new variables: Z13, Z14, Z15, and Z16) were imputed using one of the following methods: cell median or donor distribution of Z81, cell mean, or reported prior year or census year data which was multiplied by a growth factor. If the non-respondent to Z90 and Z95 does not write in anything in the Other categories for Z90 and Z95, we impute those variables to be zero.


Tabulations

After the data were edited, the survey data was aggregated to yield the viewable and downloadable files that are available on the website.


Revisions

The 2012 Census of Governments: Finance - Survey of Public Pensions: State-Administered Defined Benefit Data released data for Fiscal Year 2012 on August 1, 2013. Users should note that this release also includes revisions to Fiscal Years 2007, 2008, 2009, 2010, and 2011. The revised data are accessible through all viewable and downloadable data files on the survey's website


Sampling Error

These data are not subject to sampling error or any sampling variability because this is a complete enumeration of all 227 state government pension system.

For further information, please refer to the 2012 Census of Governments: Finance — Survey of Public Pensions: State-Administered Defined Benefit Data 2012 Survey Methodology. [26KB]


[PDF] or PDF denotes a file in Adobe’s Portable Document Format. To view the file, you will need the Adobe® Reader® Off Site available free from Adobe.
[Excel] or the letters [xls] indicate a document is in the Microsoft® Excel® Spreadsheet Format (XLS). To view the file, you will need the Microsoft® Excel® Viewer Off Site available for free from Microsoft®.
This symbol Off Site indicates a link to a non-government web site. Our linking to these sites does not constitute an endorsement of any products, services or the information found on them. Once you link to another site you are subject to the policies of the new site.
Source: U.S. Census Bureau | Annual Survey of Public Pensions: State-Administered Defined Benefit Data | 1 (888) 529-1963 | govs.pensions@census.gov |  Last Revised: March 25, 2010