Data Cleaning Procedures for the 1993 Robert Wood Johnson Foundation Employer Health Insurance Survey

by Euller, Roald; Long, Stephen H.; Marquis, M. Susan; Robert Wood Johnson Foundation; Rand Corporation

• ISBN13: 9780833025227
• ISBN10: 0833025228
• Format: Paperback
• Copyright: 1997-06-01
• Publisher: Rand Corp

Summary

RAND designed the survey to assist states in defining problems with their employment-based health insurance markets and in analyzing the impacts of policy options. This report briefly describes the survey, provides an overview of the objectives in editing the data and imputing for missing or edited values, and describes the specific cleaning procedures used.

Table of Contents

Preface	p. iii
Figure and Tables	p. vii
Introduction	p. 1
Purpose of This Report	p. 1
Background on the Survey	p. 1
Purposes of Editing and Imputing	p. 3
Methods	p. 5
Editing	p. 5
Outlier Values	p. 5
Inconsistent Responses	p. 6
Imputing	p. 7
Table Lookup	p. 7
Hot Deck Using Previously Processed Records	p. 8
Hot Deck Using Full Donor Pool	p. 8
Regression Model	p. 9
Private Versus Public Establishments	p. 9
Imputation of Establishment-Level Variables to Private Employers	p. 11
Total Employees	p. 11
Employee Characteristics	p. 14
Employer Characteristics	p. 14
Payroll	p. 14
Imputation of Health Insurance Plan-Level Variables to Private Employers	p. 16
Plan Type	p. 16
Enrollment	p. 16
Cost Sharing	p. 18
Benefits	p. 19
Premiums	p. 19
Employer share of premiums	p. 23
Percentage of family enrollment	p. 23
Imputation of Missing Data to Public Employers	p. 25
Table of Contents provided by Syndetics. All Rights Reserved.