Skip Main Navigation Skip To Navigation Content

Quarterly Survey of Public Pensions

Skip top of page navigation
You are here: Census.govBusiness & IndustryFederal, State, & Local GovernmentsQuarterly Survey of Public PensionsHow the Data are Collected › Data Processing
Skip top of page navigation

Data Processing

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 quarter/prior quarter edits compare by item code the data reported for the current quarter with data reported for the prior quarter. If data falls 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. There are also questionnaires that are not returned despite efforts to gain a response. Imputation is the process of filling in missing or invalid data with reasonable values in order to have a complete data set. Usable replies are received from at least 80 percent of the systems canvassed. Effective in the second quarter of 2013, the Quarterly Survey of Public Pensions (QSPP) improved upon item imputation method to fill in missing data based on grouping similar pension systems together. Both partial and full nonrespondents were imputed using either a mean growth rate, median growth rate, or direct substitution. These methods are applied to certain variables based on research conducted in 2013. A bridge study which reviews the imputation methodology in detail is forthcoming.


[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.
Source: U.S. Census Bureau | Quarterly Survey of Public Pensions | 1 (888) 529-1963 | govs.pensions@census.gov |  Last Revised: June 26, 2014