HEALTH INSURANCE REVISION EXTRACT FILES 1997 through 2004 CPS March Supplement Notes In March 2007, the Census Bureau released revised figures on health insurance coverage from the 2005 and 2006 CPS ASEC, reflecting a modification in the process that assigns employment-based and private direct-purchase health insurance coverage to non-policy holders (for more on the revision see: http://www.census.gov/hhes/www/hlthins/usernote/usernote3-21rev.html). In June 2007, the Census Bureau released a new historical data series that approximates the correction to the process that assigns coverage to non-policy holders. A working paper (found at: http://www.census.gov/hhes/www/hlthins/usernote/revhlth_paper.pdf) released at the same time describes the approximation technique and applies it to all years available: data files from 1997 to 2004. This guide is aimed at helping analysts who wish to use the Public-Use files from the Current Population Survey Annual Social and Economic Supplement (CPS ASEC) to produce similar revised estimates of health insurance coverage for years prior to the full correction. The following files are available either as SAS datasets (.sas7bdat) or as ASCII data files (.dat): 1. hi_pu_xtrct97 2. hi_pu_xtrct98 3. hi_pu_xtrct99 4. hi_pu_xtrct00 5. hi_pu_xtrct01 6. hi_pu_xtrct02 7. hi_pu_xtrct03 8. hi_pu_xtrct04 These datasets in conjunction with instructions contained in this README will allow for analysts to apply an estimation for producing revised estimates from 1997 through 2004. Revised datasets for 2005 and 2006 are available on the Ferrett FTP page located at: http://www.bls.census.gov/cps_ftp.html#cpsmarch (updated 4/2/2007). Each extract file listed above is designated by a two digit survey year identifying the corresponding CPS ASEC file to which the data should be merged (i.e. hi_pu_xtrct01 merges onto the 2001 datafile). Each dataset contains three variables, listed below: Variable Name Description H_SEQ - Household sequence number (unique to housing unit) ## This allows for merging onto CPS datafiles. ALLEMPL - Flag for employer-provided health insurance coverage 0 = No one in the household reported an employer-provided plan that covered the entire household 1 = Someone in the household reported an employer-provided plan that covered the entire household ALLPRIV - Flag for Private Direct-Purchase Health Insurance Coverage 0 = No one in the household reported a private direct-purchase plan that covered the entire household 1 = Someone in the household reported a private direct-purchase plan that covered the entire household MERGING THE DATA The extract files are household records, thus they are merged to the CPS data by the unique household sequence number H_SEQ. Everyone in the household will have the same values for the the new variables. Essentially, the SAS code should look like: PROC SORT DATA=cps02asec; BY H_SEQ; RUN: PROC SORT DATA=hi_pu_xtrct02; BY H_SEQ; RUN: DATA rev_cpsfile; MERGE cps02asec (in=a) hi_pu_xtrct02 (in=b); by H_SEQ; IF a and b; RUN; IDENTIFYING COVERAGE With the new flag variables from the extract files, there needs to be a modification of the conditions used to identify coverage status for any of the coverage types that are affected by the revision. The following chart acts as a supplement to the webpage that defines which variables should be used for certain health insurance coverage types (http://www.census.gov/hhes/www/hlthins/hlthinsrecodevar.html). |-------------------------------------------------------------------------------------------| | Coverage | Condition | |-------------------------------|-----------------------------------------------------------| | | | | | If | | Covered by some type of | COV_HI=1 or ALLEMPL=1 or ALLPRIV=1 or MCARE=1 | | Health Insurance | or MCAID=1 or CHAMP=1 | | | Then | | | Covered | | | Else | | | Uninsured | | | | |-------------------------------|-----------------------------------------------------------| | | | | | If | | Covered by Private Health | COV_HI=1 or ALLEMPL=1 or ALLPRIV=1 | | Insurance Status | | | | Then | | | Covered | | | Else | | | Not covered | | | | |-------------------------------|-----------------------------------------------------------| | | | | | If | | Covered by Employment-based | COV_GH=1 or CH_HI=2 or ALLEMPL=1 | | Health Insurance | | | | Then | | | Covered | | | Else | | | Not covered | | | | |-------------------------------|-----------------------------------------------------------| | | | | | If | | Covered by Direct-Purchase | PRIV=1 or DEPRIV=1 or ALLPRIV=1 or OTHSTYP1 in(12,13) | | Health Insurance | or OTHSTYP2 in(12,13) or OTHSTYP3 in(12,13) or | | (2001-Present) | OTHSTYP4 in(12,13) or OTHSTYP5 in(12,13) or | | | OTHSTYP6 in(12,13) or AHITYP1 in(12,13,15) or | | | AHITYP2 in(12,13,15) or AHITYP3 in(12,13,15) or | | | AHITYP4 in(12,13,15) or AHITYP5 in(12,13,15) or | | | AHITYP6 in(12,13,15) | | | Then | | | Covered | | | Else | | | Not covered | | | | |-------------------------------|-----------------------------------------------------------| | | | | | If | | Covered by Direct-Purchase | PRIV=1 or DEPRIV=1 or ALLPRIV=1 or OTHSTYP1 in(11,12) | | Health Insurance | or OTHSTYP2 in(11,12) or OTHSTYP3 in(11,12) or | | (2000) | OTHSTYP4 in(11,12) or OTHSTYP5 in(11,12) or | | | OTHSTYP6 in(11,12) or AHITYP1 in(11,12,14) or | | | AHITYP2 in(11,12,14) or AHITYP3 in(11,12,14) or | | | AHITYP4 in(11,12,14) or AHITYP5 in(11,12,14) or | | | AHITYP6 in(11,12,14) | | | Then | | | Covered | | | Else | | | Not covered | | | | |-------------------------------|-----------------------------------------------------------| | | | | | If | | Covered by Direct-Purchase | PRIV=1 or DEPRIV=1 or ALLPRIV=1 or OTHSTYP1 in(11,12) | | Health Insurance | or OTHSTYP2 in(11,12) or OTHSTYP3 in(11,12) or | | (1997-1999) | OTHSTYP4 in(11,12) or OTHSTYP5 in(11,12) or | | | OTHSTYP6 in(11,12) | | | Then | | | Covered | | | Else | | | Not covered | | | | |-------------------------------|-----------------------------------------------------------|