Skip to main content
U.S. flag
Health and Human Services Logo

An official website of the Department of Health & Human Services

menu-iconMore mobile-close-icon
mobile-back-btn-icon Back
  • menu-iconMenu
  • mobile-search-icon
AHRQ: Agency for Healthcare Research and Quality
  • Search All AHRQ Sites
  • Careers
  • Contact Us
  • Español
  • FAQs
  • Email Updates
MEPS Home Medical Expenditure Panel Survey
Font Size:
Contact MEPS FAQ Site Map  
S
M
L
XL
 
MEPS HC-112: 2007 Medical Conditions
November 2009
Agency for Healthcare Research and Quality
Center for Financing, Access, and Cost Trends
540 Gaither Road
Rockville, MD 20850
(301) 427-1406

Table of Contents

A. Data Use Agreement
B. Background
1.0 Household Component
2.0 Medical Provider Component
3.0 Survey Management and Data Collection
C. Technical and Programming Information
1.0 General Information
2.0 Data File Information
2.1 Codebook Structure
2.2 Reserved Codes
2.3 Codebook Format
2.4 Variable Naming
2.5 File Contents
2.5.1 Identifier Variables (DUID-CONDRN)
2.5.2 Medical Condition Variables (PRIOLIST-CCCODEX)
2.5.2.1 Priority Conditions and Injuries
2.5.2.2 Date Priority Condition Began/Accident Occurred
2.5.2.3 Round-Specific Questions for Priority Conditions and Injuries
2.5.2.4 Considerations for Making Estimates Using the MEPS Conditions File
2.5.2.4.1 Conditions File vs. Priority Conditions
2.5.2.4.2 Sources for Conditions on the MEPS Conditions File
2.5.2.5 Treatment of Data from Rounds Not Occurring in 2007
2.5.2.6 Rounds in Which Conditions Were Reported/Selected (CRND1 – CRND5)
2.5.2.7 Disability Flag Variables
2.5.2.8 Diagnosis Condition and Procedure Codes
2.5.2.9 Clinical Classification Codes
2.5.3 Utilization Variables (OBNUM – RXNUM)
3.0 Sample Weight (PERWT07F)
3.1 Overview
3.2 Details on Person Weight Construction
3.2.1 MEPS Panel 11 Weight
3.2.2 MEPS Panel 12 Weight
3.2.3 The Final Weight for 2007
3.2.4 Coverage
3.3 Using MEPS Data for Trend Analysis
4.0 Merging/Linking MEPS Data Files
4.1 National Health Interview Survey
4.2 Longitudinal Analysis
_._ References
_._ Appendix 1: Variable-Source Crosswalk
_._ Appendix 2: Condition, Procedure and Clinical Classification Code Frequencies
_._ Appendix 3: Clinical Classification Code to ICD-9-CM Code Crosswalk
_._ Appendix 4: List of Priority Conditions

A. Data Use Agreement

Individual identifiers have been removed from the micro-data contained in these files. Nevertheless, under sections 308 (d) and 903 (c) of the Public Health Service Act (42 U.S.C. 242m and 42 U.S.C. 299 a-1), data collected by the Agency for Healthcare Research and Quality (AHRQ) and/or the National Center for Health Statistics (NCHS) may not be used for any purpose other than for the purpose for which they were supplied; any effort to determine the identity of any reported cases is prohibited by law.

Therefore in accordance with the above referenced Federal Statute, it is understood that:

  1. No one is to use the data in this data set in any way except for statistical reporting and analysis; and

  2. If the identity of any person or establishment should be discovered inadvertently, then (a) no use will be made of this knowledge, (b) the Director Office of Management AHRQ will be advised of this incident, (c) the information that would identify any individual or establishment will be safeguarded or destroyed, as requested by AHRQ, and (d) no one else will be informed of the discovered identity; and

  3. No one will attempt to link this data set with individually identifiable records from any data sets other than the Medical Expenditure Panel Survey or the National Health Interview Survey.

By using these data you signify your agreement to comply with the above stated statutorily based requirements with the knowledge that deliberately making a false statement in any matter within the jurisdiction of any department or agency of the Federal Government violates Title 18 part 1 Chapter 47 Section 1001 and is punishable by a fine of up to $10,000 or up to 5 years in prison.

The Agency for Healthcare Research and Quality requests that users cite AHRQ and the Medical Expenditure Panel Survey as the data source in any publications or research based upon these data.

Return To Table Of Contents

B. Background

1.0 Household Component

The Medical Expenditure Panel Survey (MEPS) provides nationally representative estimates of health care use, expenditures, sources of payment, and health insurance coverage for the U.S. civilian non-institutionalized population. The MEPS Household Component (HC) also provides estimates of respondents’ health status, demographic and socio-economic characteristics, employment, access to care, and satisfaction with health care. Estimates can be produced for individuals, families, and selected population subgroups. The panel design of the survey, which includes 5 Rounds of interviews covering 2 full calendar years, provides data for examining person level changes in selected variables such as expenditures, health insurance coverage, and health status. Using computer assisted personal interviewing (CAPI) technology, information about each household member is collected, and the survey builds on this information from interview to interview. All data for a sampled household are reported by a single household respondent.

The MEPS-HC was initiated in 1996. Each year a new panel of sample households is selected. Because the data collected are comparable to those from earlier medical expenditure surveys conducted in 1977 and 1987, it is possible to analyze long-term trends. Each annual MEPS-HC sample size is about 15,000 households. Data can be analyzed at either the person or event level. Data must be weighted to produce national estimates.

The set of households selected for each panel of the MEPS HC is a subsample of households participating in the previous year’s National Health Interview Survey (NHIS) conducted by the National Center for Health Statistics. The NHIS sampling frame provides a nationally representative sample of the U.S. civilian non-institutionalized population and reflects an oversample of blacks and Hispanics. In 2006, the NHIS implemented a new sample design, which included Asian persons in addition to households with black and Hispanic persons in the oversampling of minority populations. MEPS further oversamples additional policy relevant sub-groups such as low income households. The linkage of the MEPS to the previous year’s NHIS provides additional data for longitudinal analytic purposes.

Return To Table Of Contents

2.0 Medical Provider Component

Upon completion of the household CAPI interview and obtaining permission from the household survey respondents, a sample of medical providers are contacted by telephone to obtain information that household respondents can not accurately provide. This part of the MEPS is called the Medical Provider Component (MPC) and information is collected on dates of visit, diagnosis and procedure codes, charges and payments. The Pharmacy Component (PC), a subcomponent of the MPC, does not collect charges or diagnosis and procedure codes but does collect drug detail information, including National Drug Code (NDC) and medicine name, as well as date filled and sources and amounts of payment. The MPC is not designed to yield national estimates. It is primarily used as an imputation source to supplement/replace household reported expenditure information.

Return To Table Of Contents

3.0 Survey Management and Data Collection

MEPS HC and MPC data are collected under the authority of the Public Health Service Act. Data are collected under contract with Westat, Inc. Data sets and summary statistics are edited and published in accordance with the confidentiality provisions of the Public Health Service Act and the Privacy Act. The National Center for Health statistics (NCHS) provides consultation and technical assistance.

As soon as data collection and editing are completed, the MEPS survey data are released to the public in staged releases of summary reports, micro data files, and tables via the MEPS Web site: www.meps.ahrq.gov. Selected data can be analyzed through MEPSnet, an on-line interactive tool designed to give data users the capability to statistically analyze MEPS data in a menu-driven environment.

Additional information on MEPS is available from the MEPS project manager or the MEPS public use data manager at the Center for Financing, Access, and Cost Trends, Agency for Healthcare Research and Quality, 540 Gaither Road, Rockville, MD 20850 (301-427-1406).

Return To Table Of Contents

C. Technical and Programming Information

1.0 General Information

This documentation describes the data contained in MEPS Public Use Release HC-112, which is one in a series of public use data files to be released from the 2007 Medical Expenditure Panel Survey Household Component (MEPS HC).

Released in ASCII (with related SAS and SPSS programming statements and data user information) and SAS formats, this public use file provides information on household-reported medical conditions collected on a nationally representative sample of the civilian noninstitutionalized population of the United States for calendar year 2007 MEPS HC. The file contains 70 variables and has a logical record length of 174 with an additional 2-byte carriage return/line feed at the end of each record.

This documentation offers a brief overview of the types and levels of data provided and the content and structure of the files. It contains the following sections:

Data File Information
Survey Sample Information
Merging/Linking MEPS Data Files
Appendices
       Variable to Source Crosswalk
       Detailed ICD-9-CM Condition, Procedure, and Clinical Classification Code Frequencies
       Clinical Classification Code to ICD-9-CM Code Crosswalk
       List of Priority Conditions

A codebook of all the variables included in the 2007 Medical Conditions File is provided in an accompanying file.

For more information on MEPS survey design, see Cohen 1997; Cohen 1997; and Cohen 1996. A copy of the survey instrument used to collect the information on this file is available on the MEPS Website: www.meps.ahrq.gov.

Return To Table Of Contents

2.0 Data File Information

This file contains 94,246 records. Each record represents one medical condition reported by a household survey respondent who resides in an eligible responding household and who has a positive person or family weight.

There were substantial conditions-related design changes made to the MEPS HC instrument in Panel 12 that were not implemented in Panel 11. Starting in Panel 12 Round 1, a new section, Priority Conditions Enumeration (PE), was added. The PE section asks a series of questions regarding whether the person has ever been diagnosed with a specified priority condition (e.g., diabetes). If the answer is yes, then CAPI automatically creates a condition record that is flagged as a priority condition (PRIOLIST = 1). Respondents may also report medical conditions in the Condition Enumeration (CE), medical events, and Disability Days (DD) section. In Panel 11, the interviewer manually identified whether a condition collected in the CE, events, or DD sections was a priority condition based on a list provided in the help text. In addition to changing the method of assigning priority condition status from manual to automated, the list of priority conditions changed in Panel 12. See Appendix 4 for details.

The Conditions (CN) section was also significantly revised. In Panel 12, round-specific questions (e.g., "is the person still being treated for the condition" (STILTR#)) and some injury follow-up questions (e.g., "did the injury occur inside or outside of the house" (INOUTHH)) were no longer collected.

To account for the differences in the two panels’ designs, variables collected in Panel 11 but not Panel 12 will be set to Inapplicable (-1) on all Panel 12 records. Similarly, variables collected in Panel 12 but not Panel 11 will be set to Inapplicable (-1) on all Panel 11 records. See section 2.5 for information about specific variables.

Records meeting one of the following criteria are included on the file:

In Panel 12:

  • All current conditions where one of the following is true:
  • All Round 1 and Round 2 conditions;
  • Round 3 conditions that were linked to a 2007 event;
  • Round 3 conditions that were due to an accident or injury and began before 2008;
  • All Round 3 priority condition records where the age of diagnosis is less than or equal to the person’s age as of 12/31/2007 or where the age of diagnosis is refused, don’t know, or not ascertained; or
  • Round 3 conditions where 50 percent or more of person’s reference period occurred in 2007.

In Panel 11:

  • All Round 4 and Round 5 conditions;
  • Round 1, Round 2, and Round 3 conditions that meet at least one of the following two criteria:
  • The condition was linked to a 2007 event;
  • The condition was a priority condition;
  • Round 3 conditions that were due to an accident or injury;
  • Round 3 conditions that were not previously delivered in the FY 2006 Conditions PUF (HC-104). This includes:
  • Round 3 conditions created after the delivery of the FY 2006 Conditions File due to Round 4 and Round 5 comments processing;
  • Round 3 conditions where the person did not have a positive person or family weight in FY 2006 but has a positive person or family weight in FY 2007; and
  • Round 3 conditions where fifty percent or more of person’s reference period occurred in 2007.

For each variable on the file, the codebook provides both weighted and unweighted frequencies. Because the conditions identified in this file are derived from self-reports, these data cannot be used to make estimates of disease, prevalence of health conditions, or mortality/morbidity. However, data users can make estimates of treated prevalence.

Data from this file can be merged with 2007 MEPS person-level data to append person-level characteristics such as demographic or health insurance characteristics to each record by using DUPERSID (see Section 4.0 for details). Since each record represents a single condition reported by a household respondent, some household respondents may have multiple medical conditions and thus will be represented on multiple records on this file. Other household respondents may have reported no medical conditions and thus will have no records on this file. Still other respondents may have reported a medical condition that did not meet the criteria above and thus will have no records on this file. Data from this file also can be merged to 2007 MEPS Event Files (HC-110A through HC-110H) by using the link files provided in HC-110I. (See HC-110I for details.)

Return To Table Of Contents

2.1 Codebook Structure

The codebook and data file lists variables in the following order:

Unique person identifiers
Unique condition identifiers
Medical condition variables
Utilization variables
Weight and variance estimation variables

Note that the person identifier is unique within this data year.

Return To Table Of Contents

2.2 Reserved Codes

The following reserved code values are used:

Value Definition
-1 INAPPLICABLE Question was not asked due to skip pattern
-7 REFUSED Question was asked and respondent refused to answer question
-8 DK Question was asked and respondent did not know answer
-9 NOT ASCERTAINED        Interviewer did not record the data

Return To Table Of Contents

2.3 Codebook Format

This codebook describes an ASCII data set and provides the following programming identifiers for each variable:

Identifier Description
Name Variable name (maximum of 8 characters)
Description        Variable descriptor (maximum of 40 characters)
Format Number of bytes
Type Type of data: numeric (indicated by NUM) or character (indicated by CHAR)
Start Beginning column position of variable in record
End Ending column position of variable in record

Return To Table Of Contents

2.4 Variable Naming

In general, variable names reflect the content of the variable, with an 8-character limitation. For questions asked in a specific round, the end digit in the variable name reflects the round in which the question was asked. Edited variables end in an "X" and are so noted in the variable label. (CONDIDX, which is an encrypted identifier variable, also ends in an "X".)

Variables contained in this delivery were derived either from the questionnaire itself or from the CAPI. The source of each variable is identified in Appendix 1 "Variable to Source Crosswalk." Sources for each variable are indicated in one of three ways: (1) variables derived from CAPI or assigned in sampling are so indicated; (2) variables collected at one or more specific questions have those numbers and questionnaire sections indicated in the "SOURCE" column; and (3) variables constructed from multiple questions using complex algorithms are labeled "Constructed" in the "SOURCE" column.

Return To Table Of Contents

2.5 File Contents

2.5.1 Identifier Variables (DUID-CONDRN)

The definitions of Dwelling Units (DUs) and Group Quarters in the MEPS HC are generally consistent with the definitions employed for the National Health Interview Survey (NHIS). The dwelling unit ID (DUID) is a 5-digit random number assigned after the case was sampled for MEPS. The person number (PID) uniquely identifies each person within the dwelling unit. The variable DUPERSID uniquely identifies each person represented on the file and is the combination of the variables DUID and PID. CONDN indicates the condition number as it was reported during the interview for an individual respondent (e.g., condition number 1, 2, 3, etc.) plus a control digit. The current range for CONDN is 10 – 418 and the largest range of records for any person on the file is 1 - 35. Note that this discrepancy is expected, as condition numbers are not sequentially assigned by the CAPI. In other words, if CONDN is set to 10 for a person's first condition, then CONDN might be set to 17 for the person's second condition. CONDIDX uniquely identifies each condition (i.e., each record on the file) and is the combination of DUPERSID and the condition number CONDN. For CONDIDX, the condition number is padded with leading zeroes to ensure consistent length.

PANEL is a constructed variable used to specify the panel number for the interview in which the condition was reported. PANEL will indicate either Panel 11 or Panel 12.

CONDRN indicates the round in which the condition was first reported. For a small number of cases, conditions that actually began in an earlier round were not reported by respondents until subsequent rounds of data collection. During file construction, editing was performed for these cases in order to reconcile the round in which a condition began and the round in which the condition was first reported.

Return To Table Of Contents

2.5.2 Medical Condition Variables (PRIOLIST-CCCODEX)

This file contains variables describing medical conditions reported by respondents in several sections of the MEPS questionnaire, including the Condition Enumeration section, all questionnaire sections collecting information about health provider visits, prescription medications, and disability days (see Variable-Source Crosswalk in Appendix 1 for details).

Return To Table Of Contents

2.5.2.1 Priority Conditions and Injuries

Certain conditions were a priori designated as "priority conditions" (PRIOLIST=1) due to their prevalence, expense, or relevance to policy. Due to the design changes implemented in Panel 12, the list of priority conditions differs between Panels 11 and 12. In both Panels, some were long-term, life-threatening conditions, such as cancer, diabetes, emphysema, high cholesterol, hypertension, ischemic heart disease, and stroke. Others were chronic manageable conditions, including arthritis and asthma. In addition, Alzheimer’s disease or other dementias, as well as depression and anxiety disorders, were included in the priority list for Panel 11. The only mental health condition on the Panel 12 priority conditions list is attention deficit hyperactivity disorder/attention deficit disorder. For a complete listing of priority conditions for both panels, see Appendix 4.

In Panel 11, priority conditions were identified as such in the field by MEPS interviewers. Occasionally, priority conditions were not identified as such due to interviewer misinterpretation. Consequently, these records are missing the followup questions described below. Likewise, some conditions were inaccurately identified as priority conditions. These records do have follow-up questions even though they are not priority conditions. In Panel 12, priority conditions were flagged as such by CAPI, thus preventing inaccurate identification.

When a condition was first mentioned, respondents were asked whether it was due to an accident or injury (INJURY=1). In Panel 11, some injuries are also priority conditions (e.g., back pain). In Panel 12, only non-priority conditions (i.e., conditions reported in a section other than PE) are eligible to be injuries. The interviewer is prevented from selecting priority conditions as injuries.

Return To Table Of Contents

2.5.2.2 Date or Age Priority Condition Began/Accident Occurred

The day, month, and year a priority condition began (CONDBEGD, CONDBEGM, and CONDBEGY) are collected in Panel 11 only for conditions that appear on the priority list and are not accident/injury conditions. The day, month, and year an accident or injury occurred (ACCDENTD, ACCDENTM, and ACCDENTY) are collected in both Panels 11 and 12 only for accident/injury conditions, including, in Panel 11 only, accident/injury conditions that are also priority conditions.

In Panel 12, if the respondent did not know the accident year, or refused to provide it, or if the year was not ascertained (ACCDENTY in (-7, -8, -9)), a follow-up question gathered whether the accident occurred before or after January 1 of the reference year (ACCDNJAN). If the respondent replied that the accident occurred after January 1 of the reference year (ACCDNJAN = 2), then the reference year was used to set the accident year and ACCDNJAN was reset to Inapplicable (-1).

The age of diagnosis (AGEDIAG) was collected for all priority conditions, except joint pain, beginning in Panel 12.

To ensure confidentiality, the condition and accident years were bottom-coded to 1922 and age of diagnosis was top-coded to 85. This corresponds with the date of birth bottom-coding and age top-coding in person-level PUFs.

Return To Table Of Contents

2.5.2.3 Round-Specific Questions for Priority Conditions and Injuries

Most round-specific questions were omitted beginning in Panel 12. Therefore, all Panel 12 records have these variables set to Inapplicable (-1) unless otherwise noted.

The Round 1 and 2 round-specific data for the second-year panel (Panel 11) were released on the 2006 Conditions PUF. During the development of the 2007 Conditions PUF, these variables (e.g., SEEDREV1) were set to Inapplicable (-1). Because all Panel 12 records have all round-specific variables set to Inapplicable (-1) and all Panel 11 records have the Round 1 and 2 round-specific variables set to Inapplicable (-1), these variables, excluding CRND#, have been dropped from this file.

When a respondent first reported a condition on the priority list (PRIOLIST=1) or a condition caused by an accident or injury (INJURY=1), the interviewer asked a series of questions regarding health care utilization for that condition and the effect of that condition on the person’s overall health. The names of these variables end in 1, 2, 3, 4, or 5 indicating the round in which they were asked. The following questions were asked in the round in which the respondent first reported a priority condition or a condition resulting from an injury:

  1. Whether the respondent ever saw or talked to a doctor about the condition (SEEDREV3 – SEEDREV5);
  2. Whether the person was still being treated for the condition (STILTR3-STILTR5);
  3. How seriously the condition affected the person’s overall health and well-being since it began (OVRALL3-OVRALL5);
  4. Whether the health care provider recommended further treatment or consultation for the condition (FURTCA3 – FURTCA5);
  5. How much of the recommended follow-up care the person received for the condition (all, some, none, or still being treated) (FOLOCA3 – FOLOCA5);
  6. Whether the person saw or talked to a doctor about the condition during the reference period (SEEDREF3 – SEEDREF5). This variable was constructed for priority conditions only.

When a respondent reported a condition that resulted from an accident or injury (INJURY=1), the following information was obtained from respondents during the round in which the injury was first reported:

  1. Whether the accident/injury occurred at work (ACCDNWRK) – respondents aged 15 and younger were not asked this question and the condition was coded ACCDNWRK = -1;
  2. Where the accident/injury happened (ACDNTLOC);
  3. If the accident/injury occurred at home, was it inside or outside the house (INOUTHH);
  4. Whether the accident involved a motor vehicle, weapon other than a gun, poison, fire, drowning or near-drowning, sports injury, a non-sports related fall, something else (VEHICLE, WEAPON, POISON, FIREBURN, DROWN, SPORTS, FALL, ACDNTOTH);
  5. Whether the person has fully recovered from the accident/injury (RECOVER).

Note that ACCDNWRK was collected in Panel 12.

Prior to 2007, the variable indicating whether the accident involved a gun (GUN) was included in this file. Beginning in 2007, this variable was removed to provide increased confidentiality.

For Panel 12 cancer conditions collected in the PE section, a follow-up question is asked when the cancer is first reported to determine whether the cancer is in remission/under control (REMISSN). This variable is set to Inapplicable (-1) on all Panel 11 records.

For Panel 11 priority conditions only, additional information was obtained in rounds subsequent to the one in which the condition was first reported. This information was obtained only if the condition was experienced or there was an event, a prescribed medication, or a disability day associated with the condition in that round. If this occurred, the condition was "selected" for follow-up questions for the round.

For priority conditions selected in rounds after they were first reported, the following questions were asked in that round:

  1. Whether the respondent saw or talked to a doctor about the condition since the start of the reference period (SEEDREV3 - SEEDREV5);
  2. Whether the person was still being treated for the condition (STILTR3 – STILTR5);
  3. How seriously the condition affected the person’s overall health and well-being since the start of the reference period. (OVRALL3 – OVRALL5);
  4. Whether the person saw or talked to a doctor about the condition during the reference period (SEEDREF3 – SEEDREF5).

Return To Table Of Contents

2.5.2.4 Considerations for Making Estimates Using the MEPS Conditions File

2.5.2.4.1 Conditions File vs. Priority Conditions

It should be noted that priority conditions reported in the Priority Conditions (PC) section of the MEPS questionnaire in Panel 11 do not directly relate to those listed as priority conditions on the Medical Conditions PUF. Unlike those on this file, the conditions identified in the PC section of the instrument in Panel 11 were not added to the condition roster. Chronic conditions asked about in the PC section were asked in the context of "has person ever been told by a doctor or other health care professional that they have (condition)?", while the priority conditions on the Conditions PUF refer to those experienced by the respondent during a specific reference period. Some of those round-specific conditions were then determined to be a priority due to their prevalence, expense, or relevance to policy. There may be logical inconsistencies between items in the Panel 11 version of PC section and conditions on the Conditions PUF because they were asked in reference to different time periods.

Researchers should use their judgment in using this variable and related information, keeping in mind that the Panel 11 PRIOLIST flag is a manual process and due to human error some information may be missing or inaccurately reported.

Panel 12 priority conditions created in the Priority Condition Enumeration (PE) section were also asked in the context of "has person ever been told by a doctor or other health care professional that they have (condition)?" If the response is Yes (1), then a condition record is generated. Note that priority conditions are included in the Conditions PUF only if the condition is current. A current condition is defined as a condition linked to an event or disability day or a condition the person is currently experiencing (i.e., a condition selected in the CE section). These changes are reflected in Appendix 3.

Return To Table Of Contents

2.5.2.4.2 Sources for Conditions on the MEPS Conditions File

Conditions can be added to the MEPS condition roster in several ways. In Panel 12 only, a condition can be reported in the Priority Condition Enumeration (PE) section in which persons are asked if they have ever been diagnosed with specific conditions. In both panels, the condition can be identified as the reason reported by the household respondent for a particular medical event (hospital stay, outpatient visit, emergency room visit, home health episode, prescribed medication purchase, or medical provider visit). The condition may be reported as the reason for one or more episodes of disability days. Finally, the condition may be reported by the household level respondent as a condition "bothering" the person during the reference period (see question CE03).

Researchers need to be certain that they select the condition records appropriate for their analysis. There is no attempt made to reconcile the condition file and the responses to questions in the Panel 11 version of the Priority Conditions section of the instrument. Two common ways of using condition information are 1) identifying persons through the PC section as "persons who reported ever having condition _____" or 2) identifying persons who had a specific condition named as a reason for one or more medical events (treated prevalence). Researchers are cautioned to use discretion in constructing other condition variables.

Return To Table Of Contents

2.5.2.5 Treatment of Data from Rounds Not Occurring in 2007

For Panel 11, Rounds 1 and 2 occurred in 2006 and conditions reported during these rounds are not included on this file unless the condition was identified as a priority condition (see the discussion of PRIORFLG below) or was related to a 2007 event. Note that if, in Rounds 3, 4, and 5 of Panel 11, the person "selects" a Round 1 or 2 condition as a serious condition experienced during the current round or the reason for a reported disability day, this condition does not appear on the 2007 file unless it is also a priority condition or is related to a 2007 event. For Panel 12, Rounds 4 and 5 occurred in 2008 and conditions reported during these rounds are not included on this file. Therefore, round-specific variables for Rounds 1 and 2 of Panel 11 are assigned an inapplicable code (-1) on all of the condition records for respondents in Panel 11, and round-specific variables for Rounds 4 and 5 of Panel 12 are assigned an inapplicable code
(-1) on all of the condition records for respondents in Panel 12. Round-specific data for Rounds 4 and 5 pertain only to Panel 11; round-specific data for Rounds 1 and 2 pertain only to Panel 12, and both panels provide data from Round 3. (Note: Use PANEL to identify whether Round 3 variables were collected in Panel 11 or Panel 12.)

Conditions in this 2007 file first reported in Rounds 1 or 2 of Panel 11 that are priority conditions OR conditions resulting from an injury have round-specific data for those rounds included on the 2006 Medical Conditions File (HC-104). The variables PRIORFLG and INJURFLG indicate if the condition is "Not a priority/injury condition" (0), if "Additional information is included on the 2006 Medical Conditions File" (1), or if "All priority/injury information is included on the current file" (2). For a small number of records, additional round-specific data cannot be located on the file from the previous year. For 5 conditions from Panel 11 Rounds 1 and 2, round-specific information cannot be located in the 2007 Medical Conditions File as noted above, and additional round-specific information is not included on the 2006 Medical Conditions File. This situation occurs when a record is unweighted and therefore not included on the file in one year but is assigned a positive weight and included on the file in the subsequent year. The situation can also occur when a condition is incorrectly identified as not a priority condition in one year but is later updated to be a priority condition in the subsequent year.

Note: Priority conditions are generally chronic conditions. Even though a person may not have reported an event, prescribed medicine, or disability day in 2007 due to the condition, or reported generally experiencing the condition in 2007; analysts should consider that the person is probably still experiencing the condition. If a Panel 11 person reported a priority condition in Round 1 or 2 and did not have an event, a prescribed medicine, or a disability day for the condition in Round 3, 4, or 5, round-specific variables for Rounds 3, 4, and 5 are coded as –1. The only information provided on the current 2007 file for such conditions are the ICD9CODX, ICD9PROX, CCCODEX, and non-round-specific variables. These records are identified by PRIORFLG=1. Round-specific data from Rounds 1 and 2 for these records are available in the 2006 Medical Conditions File.

Return To Table Of Contents

2.5.2.6 Rounds in Which Conditions Were Reported/Selected (CRND1 – CRND5)

A set of constructed variables (CRND1 – CRND5) indicates the round in which the condition was first reported, and the subsequent round(s) in which the condition was selected. The condition may be reported or selected when the person reports an event, prescription medication, or disability day that occurred due to the condition, or the condition may be selected as a serious condition that is not linked to any events, prescription medications, or disability days. For example, consider a condition for which CRND1 = 0, CRND2 = 1, and CRND3 = 1. For all conditions in Panel 11 and non-priority conditions in Panel 12, this sequence of CRND indicators on a condition record implies that the condition was not present during Round 1 (CRND1 = 0), was first mentioned during Round 2, and was selected during Round 3. For Panel 12 priority conditions, it is necessary to look at CONDRN rather than CRND# to determine in which round the condition was first reported. In addition to the scenario above, this sequence of CRND indicators may imply that the condition was reported in the PE section in Round 1 but not connected with an event, prescribed medicine, or disability day and not reported as a serious condition; and was selected during Rounds 2 and 3.

Note that, in Panel 11, it is possible for a pregnancy condition to exist without a CRND in the round in which the condition was reported. This may occur if the person is selected in the Condition Enumeration (CE) section when the respondent is asked whether any women in the household are pregnant but the woman had no events, prescribed medicines, or disability days connected to that condition. In such a situation, CRND# would be set to 0 in the round in which the condition was first reported. Due to age-related confidentiality concerns, pregnancy conditions for women under 16 and over 44 where there is no CRND in the round in which the condition was reported have CRND# updated to 1 for that round.

Return To Table Of Contents

2.5.2.7 Disability Flag Variables

This file contains three flag variables indicating whether a condition is associated with a missed work day (MISSWORK), a missed school day (MISSSCHL), or a day spent in bed (INBEDFLG). Due to the MEPS instrument design, there is no link indicating the specific number of disability days associated with a particular medical condition.

Return To Table Of Contents

2.5.2.8 Diagnosis Condition and Procedure Codes

The medical conditions and procedures reported by the Household Component respondent were recorded by the interviewer as verbatim text, which was then coded by professional coders to fully-specified ICD-9-CM codes, including medical condition and V codes (see Health Care Financing Administration, 1980). Although codes were verified and error rates did not exceed 2.5 percent for any coder, analysts should not presume this level of precision in the data; the ability of household respondents to report condition data that can be coded accurately should not be assumed (see Cox and Iachan, 1987; Edwards, et al, 1994; and Johnson and Sanchez, 1993). Some condition information is collected in the Medical Provider Component of MEPS. However, since it is not available for everyone in the sample, it is not used to supplement, replace, or verify household reported condition data.

Professional coders followed specific guidelines in coding missing values to the ICD-9-CM diagnosis condition and procedure variables. The ICD-9-CM diagnosis condition variable (ICD9CODX) was coded -9 where the verbatim text fell into one of three categories: (1) the text indicated that the condition was unknown (e.g., DK); (2) the text indicated the condition could not be diagnosed by a doctor (e.g., doctor doesn’t know); or (3) the specified condition was not codeable and a procedure could not be discerned from the text. ICD9CODX was coded -1 where the verbatim text strictly denoted a procedure and not a condition. The ICD-9-CM procedure variable (ICD9PROX) was coded -9 where the verbatim text strictly denoted a procedure, but the text was not specific enough to assign a procedure code. ICD9PROX was set to -1 where the text strictly specified a condition and not a procedure.

In order to preserve confidentiality, nearly all of the diagnosis condition codes provided on this file have been collapsed from fully-specified codes to 3-digit code categories. Table 1 in Appendix 2 provides unweighted and weighted frequencies for all ICD-9-CM condition code values reported on the file. In this table, values that reflect this collapsing have an asterisk in the label indicating that the 3-digit category includes all the subclassifications within that category. For example, the ICD9CODX value of 034 "Strep Throat/Scarlet Fev *" includes the fully-specified subclassifications 034.0 and 034.1; the value 296 "Affective Psychoses*" includes the fully-specified subclassifications 296.0 through 296.99. Less than 1 percent of the records on this file were edited further by collapsing two or more 3-digit codes into one 3-digit code.

Similarly, most of the procedure codes were collapsed from fully-specified codes to 2-digit category codes. Table 2 in Appendix 2 provides unweighted and weighted frequencies for ICD9PROX, and this type of collapsing is identified by an asterisk in the variable label. For example, the ICD9PROX value of 81 "Joint Repair*" includes subclassifications 81.0 through 81.99. Less than 1 percent of records were further edited to combine two or more 2-digit categories.

Note that, for conditions related to certain medical events, the ICD-9-CM codes on this file are also released in the Prescribed Medicines, Emergency Room Visits, Office-based Medical Provider Visits, Outpatient Department Visits, and Inpatient Hospital Stays Event Files. Because the ICD-9-CM codes have been collapsed, it is possible for there to be duplicate ICD-9-CM condition or procedure codes linked to a single medical event when different fully-specified codes are collapsed into the same code. For information on merging data on this file with the 2007 MEPS Event Files (HC-110A through HC-110H) refer to the link files provided in HC-110I, and see HC-110I for details.

In a small number of cases, diagnosis condition and procedure codes were further recoded to -9 if they denoted a pregnancy for a person younger than 16 or older than 44. There were 17 records recoded in this manner on the 2007 Medical Conditions File. The person’s age was determined by linking the 2007 Medical Conditions File to the 2006 and 2007 Person-Level Use PUFs. If the person’s age is under 16 or over 44 in the round in which the condition or procedure was reported, the appropriate condition or procedure code was recoded to -9.

Users should note that because of the design of the survey, most deliveries (i.e., births) are coded as pregnancies. For more accurate estimates for deliveries, analysts should use RSNINHOS "Reason Entered Hospital" found on the Hospital Inpatient Stays Public Use File (HC-110D).

Conditions and procedures were reported in the same sections of the HC questionnaire (see Variable-Source Crosswalk in Appendix 1). Labels for all values of the variables ICD9CODX and ICD9PROX, as shown in Tables 1 and 2, are provided in the SAS programming statements included in this release (see the H112SU.TXT file).

Return To Table Of Contents

2.5.2.9 Clinical Classification Codes

ICD-9-CM condition codes have been aggregated into clinically meaningful categories that group similar conditions (CCCODEX). CCCODEX was generated using Clinical Classification Software (formerly known as Clinical Classifications for Health Care Policy Research (CCHPR)), which aggregates conditions and V-codes into mutually exclusive categories, most of which are clinically homogeneous (Elixhauser, et al, 2000). Appendix 3 lists the ICD-9-CM codes that have been aggregated for each clinical classification category.

The reported ICD-9-CM condition code values were mapped to the appropriate clinical classification category prior to being collapsed to 3-digit ICD-9-CM condition codes. The result is that every record which has an ICD-9-CM diagnosis code also has a clinical classification code.

As with ICD9CODX and ICD9PROX, professional coders followed specific guidelines in setting CCCODEX to a missing value. CCCODEX was coded -9 where the verbatim text fell into one of three categories: (1) the text indicated that the condition was unknown (e.g., DK); (2) the text indicated the condition could not be diagnosed by a doctor (e.g., doctor doesn’t know); or (3) the specified condition was not codeable and a procedure could not be discerned from the text. CCCODEX was coded -1 where the verbatim text strictly denotes a procedure and not a condition.

A small number (less than 1 percent) of clinical classification codes have been edited for confidentiality purposes. Table 3 in Appendix 2 provides weighted and unweighted frequencies for CCCODEX. Labels for all values of the variable CCCODEX, as shown in Table 3, are provided in the SAS programming statements included in this release (see the H112SU.TXT file).

In a small number of cases, clinical classification codes were further recoded to -9 if they denoted a pregnancy for a person younger than 16 or older than 44. There were 17 records recoded in this manner on the 2007 Medical Conditions File. The person’s age was determined by linking the 2007 Medical Conditions File to the 2006 and 2007 Person-Level Use PUFs. If the person’s age is under 16 or over 44 in the round in which the condition was reported, the appropriate clinical classification code was recoded to -9.

Note that, prior to 2004, the range for the variable CCCODEX was 001 through 260. In 2004, revisions to the coding of mental disorders were implemented. The codes 650 through 663 replace 065 through 075 in 2004. Beginning in 2007, the mental disorders code were reorganized again. Alcohol and substance abuse disorders were broken into separate categories, and miscellaneous mental disorders was renumbered.

Analysts should use the clinical classification codes listed in the Conditions PUF document (HC-112) and the Appendix to the Event Files (HC-110I) document when analyzing MEPS conditions data. Although there is a list of clinical classification codes and labels on the Healthcare Cost and Utilization Project (HCUP) Website, if updates to these codes and/or labels are made on the HCUP Website after the release of the 2007 MEPS PUFs, these updates will not be reflected in the 2007 MEPS data.

Return To Table Of Contents

2.5.3 Utilization Variables (OBNUM – RXNUM)

The variables OBNUM, OPNUM, HHNUM, IPNUM, ERNUM, and RXNUM indicate the total number of 2007 events that can be linked to each condition record on the current file, i.e., office-based, outpatient, home health, inpatient hospital stays, emergency room visits, and prescribed medicines, respectively.

These counts of events were derived from Expenditure Event Public Use Files (HC-110G, HC-110F, HC-110H, HC-110D, HC-110E, and HC-110A). Events associated with conditions include all utilization that occurred between January 1, 2007 and December 31, 2007.

Because persons can be seen for more than one condition per visit, these frequencies will not match the person or event-level utilization counts. For example, if a person had one inpatient hospital stay and was treated for a fractured hip, a fractured shoulder and a concussion, each of these conditions has a unique record in this file and IPNUM=1 for each record. By summing IPNUM for these records, the total inpatient hospital stays would be three when actually there was only one inpatient hospital stay for that person and three conditions were treated. These variables are useful for determining the number of inpatient hospital stays for head injuries, hip fractures, etc.

Return To Table Of Contents

3.0 Survey Sample Information

3.1 Overview

There is a single full year person-level weight (PERWT07F) assigned to each record for each key, in-scope person who responded to MEPS for the full period of time that he or she was in-scope during 2007. A key person either was a member of an NHIS household at the time of the NHIS interview, or became a member of a family associated with such a household after being out-of-scope at the time of the NHIS (the latter circumstance includes newborns as well as persons returning from military service, an institution, or living outside the United States). A person is in-scope whenever he or she is a member of the civilian noninstitutionalized portion of the U.S. population.

There has been an important change in the MEPS sample design that is worth noting. The MEPS sample of households for Round 1 of a given MEPS panel is a subsample of the responding households to the previous year’s National Health Interview Survey (NHIS). A new NHIS sample design was implemented in 2006 with a new sample of PSUs and segments, independent of the sample design used from 1995-2005. Thus, MEPS Panel 12 households fielded initially in 2007, selected from the 2006 NHIS household respondents, are from a sample design independent of those sampled for MEPS Panel 11 from among 2005 NHIS household respondents. As a result, with two national samples of PSUs and segments fielded for MEPS and with a somewhat reduced sample size for Panel 12, the amount of clustering is reduced with the expectation of some increase in precision for 2007 MEPS estimates. There will also be more degrees of freedom due to more variance strata available for variance estimation purposes. The trade-off for these expected increases in precision and degrees of freedom is that it is more expensive to field a sample that is less concentrated. In 2008 both MEPS panels will have been sampled from the new NHIS sample design, with corresponding reductions in survey costs, precision, and degrees of freedom.

Return To Table Of Contents

3.2 Details on Person Weight Construction

The person-level weight PERWT07F was developed in several stages. Person-level weights for Panels 11 and 12 were created separately. The weighting process for each panel included an adjustment for nonresponse over time and calibration to independent population figures. The calibration was initially accomplished separately for each panel by raking the corresponding sample weights to Current Population Survey (CPS) population estimates based on five variables. The five variables used in the establishment of the initial person-level control figures were: census region (Northeast, Midwest, South, West); MSA status (MSA, non-MSA); race/ethnicity (Hispanic, non-Hispanic with black as sole reported race, non-Hispanic with Asian as sole reported race, and other); sex; and age. A 2007 composite weight was then formed by multiplying each weight from Panel 11 by the factor .56 and each weight from Panel 12 by the factor .44. The choice of factors reflected the relative sample sizes of the two panels, helping to limit the variance of estimates obtained from pooling the two samples. The composite weight was again raked to the same set of CPS-based control totals. When poverty status information derived from income variables became available, a final raking was undertaken on the previously established weight variable. Control totals were established using poverty status (five categories: below poverty, from 100 to 125 percent of poverty, from 125 to 200 percent of poverty, from 200 to 400 percent of poverty, at least 400 percent of poverty) as well as the original five variables used in the previous calibrations.

Return To Table Of Contents

3.2.1 MEPS Panel 11 Weight

The person-level weight for MEPS Panel 11 was developed using the 2006 full year weight for an individual as a "base" weight for survey participants present in 2006. For key, in-scope respondents who joined an RU some time in 2007 after being out-of-scope in 2006, the 2006 family weight associated with the family the person joined served as a "base" weight. The weighting process included an adjustment for nonresponse over Rounds 4 and 5 as well as raking to population control figures for December 2007. These control figures were derived by scaling back the population totals obtained from the March 2008 CPS to correspond to a national estimate for the civilian noninstitutionalized population provided by the Census Bureau for December 2007. Variables used in the establishment of person-level control figures included: census region (Northeast, Midwest, South, West); MSA status (MSA, non-MSA); race/ethnicity (Hispanic, black but non-Hispanic, Asian but non-Hispanic, and other); sex; and age. Overall, the weighted population estimate for the civilian noninstitutionalized population on December 31, 2007 is 297,823,930. Key, responding persons not in-scope on December 31, 2007 but in-scope earlier in the year retained, as their final Panel 11 weight, the weight after the nonresponse adjustment.

Return To Table Of Contents

3.2.2 MEPS Panel 12 Weight

The person-level weight for MEPS Panel 12 was developed using the MEPS Round 1 person-level weight as a "base" weight. For key, in-scope respondents who joined an RU after Round 1, the Round 1 family weight served as a "base" weight. The weighting process included an adjustment for nonresponse over Round 2 and the 2007 portion of Round 3 as well as raking to the same population control figures for December 2007 used for the MEPS Panel 11 weights. The same five variables employed for Panel 11 raking (census region, MSA status, race/ethnicity, sex, and age) were used for Panel 12 raking. Similarly, for Panel 12, key, responding persons not in-scope on December 31, 2007 but in-scope earlier in the year retained, as their final Panel 12 weight, the weight after the nonresponse adjustment.

Note that the MEPS Round 1 weights incorporated the following components: the original household probability of selection for the NHIS; ratio-adjustment to NHIS-based national population estimates at the household (occupied dwelling unit) level; adjustment for nonresponse at the dwelling unit level for Round 1; and poststratification to figures at the family and person level obtained from the March CPS data base of the corresponding year (i.e., 2006 for Panel 11 and 2007 for Panel 12).

Return To Table Of Contents

3.2.3 The Final Weight for 2007

Variables used in the establishment of person-level control figures included: poverty status (below poverty, from 100 to 125 percent of poverty, from 125 to 200 percent of poverty, from 200 to 400 percent of poverty, at least 400 percent of poverty); census region (Northeast, Midwest, South, West); MSA status (MSA, non-MSA); race/ethnicity (Hispanic, non-Hispanic with black as sole reported race, non-Hispanic with Asian as sole reported race, and other); sex; and age. Overall, the weighted population estimate for the civilian noninstitutionalized population for December 31, 2007 is 297,823,930 (PERWT07F>0 and INSC1231=1). In addition, the weights of two groups of persons who were out-of-scope on December 31, 2007 were poststratified. Specifically, the weights of those who were in-scope some time during the year, out-of-scope on December 31, and entered a nursing home during the year were poststratified to a corresponding control total obtained from the 1996 MEPS Nursing Home Component. Those who died while in-scope during 2007 were poststratified to corresponding estimates derived using data obtained from the Medicare Current Beneficiary Survey (MCBS) and Vital Statistics information provided by the National Center for Health Statistics (NCHS). Separate control totals were developed for the "65 and older" and "under 65" civilian noninstitutionalized populations. The sum of the person-level weights across all persons assigned a positive person level weight is 301,309,149.

Return To Table Of Contents

3.2.4 Coverage

The target population for MEPS in this file is the 2007 U.S. civilian noninstitutionalized population. However, the MEPS sampled households are a subsample of the NHIS households interviewed in 2005 (Panel 11) and 2006 (Panel 12). New households created after the NHIS interviews for the respective Panels and consisting exclusively of persons who entered the target population after 2005 (Panel 11) or after 2006 (Panel 12) are not covered by MEPS. Neither are previously out-of-scope persons who join an existing household but are unrelated to the current household residents. Persons not covered by a given MEPS panel thus include some members of the following groups: immigrants; persons leaving the military; U.S. citizens returning from residence in another country; and persons leaving institutions. The set of uncovered persons constitutes only a small segment of the MEPS target population.

Return To Table Of Contents

3.3 Using MEPS Data for Trend Analysis

MEPS began in 1996, and the utility of the survey for analyzing health care trends expands with each additional year of data. However, it is important to consider a variety of factors when examining trends over time using MEPS. Statistical significance tests should be conducted to assess the likelihood that observed trends may be attributable to sampling variation. The length of time being analyzed should also be considered. In particular, large shifts in survey estimates over short periods of time (e.g. from one year to the next) that are statistically significant should be interpreted with caution, unless they are attributable to known factors such as changes in public policy, economic conditions, or MEPS survey methodology. Looking at changes over longer periods of time can provide a more complete picture of underlying trends. Analysts may wish to consider using techniques to smooth or stabilize analyses of trends using MEPS data such as comparing pooled time periods (e.g. 1996-97 versus 2004-05), working with moving averages, or using modeling techniques with several consecutive years of MEPS data to test the fit of specified patterns over time. Finally, researchers should be aware of the impact of multiple comparisons on Type I error. Without making appropriate allowance for multiple comparisons, undertaking numerous statistical significance tests of trends increases the likelihood of concluding that a change has taken place when one has not.

Return To Table Of Contents

4.0 Merging/Linking MEPS Data Files

Data from the current file can be used alone or in conjunction with other files. Merging characteristics of interest from person-level files expands the scope of potential estimates. See HC-110I for instructions on merging the Condition File to the Medical Event Files. Person-level characteristics can be merged to this Conditions File using the following procedure:

  1. Sort the person-level file by person identifier, DUPERSID. Keep only DUPERSID and the variables to be merged onto the Conditions File.
  2. Sort the Conditions File by person identifier, DUPERSID.
  3. Merge both files by DUPERSID, and output all records in the Conditions File.
  4. If PERS contains the person-level variables, and COND is the Conditions File, the following code can be used to add person-level variables to the person’s conditions in the condition-level file.

PROC SORT DATA=PERS(KEEP=DUPERSID AGE SEX EDUCLEVL)
OUT=PERSX; BY DUPERSID;
RUN;

PROC SORT DATA=COND; BY DUPERSID;
RUN;

DATA COND;
MERGE COND (IN=A) PERSX(IN=B); BY DUPERSID;
IF A;
RUN;

Return To Table Of Contents

4.1 National Health Interview Survey

Data from this file can be used alone or in conjunction with other files for different analytic purposes. Each MEPS panel can also be linked back to the previous years’ National Health Interview Survey public use data files. For information on obtaining MEPS/NHIS link files please see www.meps.ahrq.gov/data_stats/more_info_download_data_files.jsp.

Return To Table Of Contents

4.2 Longitudinal Analysis

For Panels 1 through 8, panel-specific files (called Longitudinal Weight Files) containing estimation variables to facilitate longitudinal analysis are available for downloading in the data section of the MEPS Web site. To create longitudinal files for these panels, it is necessary to link data from two subsequent annual files that contain data for the first and second years of the panel, respectively. Starting with Panel 9, it is not necessary to link files for longitudinal analysis because Longitudinal Data Files have been constructed and are available for downloading on the Web.

Return To Table Of Contents

References

Cohen, S. B. (1997). A Sample Design of the 1996 Medical Expenditure Panel Survey Household Component, Rockville (MD): Agency for Healthcare Research and Quality; 1997. MEPS Methodology Report, No. 2. AHCPR Pub. No. 97-0027.

Cohen, J. W. (1997). A Design and Methods of the Medical Expenditure Panel Survey Household Component. Rockville (MD): Agency for Healthcare Research and Quality; 1997. MEPS Methodology Report, No.1. AHCPR Pub. No. 97-0026.

Cohen, S. B. (1996). The Redesign of the Medical Expenditure Panel Survey: A Component of the DHHS Survey Integration Plan. Proceedings of the COPAFS Seminar on Statistical Methodology in the Public Service.

Cox, B. and Iachan, R. (1987). A Comparison of Household and Provider Reports of Medical Conditions. Journal of the American Statistical Association 82(400): 1013-18.

Edwards, W. S., Winn, D. M., Kurlantzick, V., et al. Evaluation of National Health Interview Survey Diagnostic Reporting. National Center for Health Statistics, Vital Health 2(120). 1994.

Elixhauser, A., Steiner, C. A., Whittington, C. A., and McCarthy, E. Clinical Classifications for health policy research: Hospital inpatient statistics, 1995. Healthcare Cost and Utilization project, HCUP-3 research Note. Rockville, MD: Agency for Healthcare Research and Quality; 2000. AHCPR Pub. No. 98-0049.

Health Care Financing Administration (1980). International Classification of Diseases, 9th Revision, Clinical Modification (ICD-CM). Vol. 1. (Department of Health and Human Services Pub. No (PHS) 80-1260). Department of Health and Human Services: U.S. Public Health Services.

Johnson, Ayah E., and Sanchez, Maria Elena. (1993), "Household and Medical Reports on Medical Conditions: National Medical Expenditure Survey." Journal of Economic and Social Measurement, 19, 199-223.

Return To Table Of Contents

Appendix 1. Variable-Source Crosswalk

UNIQUE IDENTIFIER VARIABLES

VARIABLE LABEL SOURCE1
DUID Dwelling Unit ID Assigned In Sampling
PID Person Number Assigned In Sampling
DUPERSID Person ID (DUID + PID) Assigned In Sampling
CONDN Condition Number CAPI Derived
CONDIDX Condition ID CAPI Derived
PANEL Panel Number Constructed
CONDRN Condition Round Number CAPI Derived

Return To Table Of Contents

MEDICAL CONDITION VARIABLES

VARIABLE LABEL SOURCE1
PRIOLIST Is Condition On Priority List CN02
CONDBEGD Date Condition Started -- Day CN05
CONDBEGM Date Condition Started -- Month CN05
CONDBEGY Date Condition Started -- Year CN05
SEEDREV3 RD3: Ever Seen Dr For Cond CN03, CN17
SEEDREV4 RD4: Ever Seen Dr For Cond CN03, CN17
SEEDREV5 RD5: Ever Seen Dr For Cond CN03, CN17
STILTR3 RD3: Is Pers Still Treated For Cond CN11, CN18
STILTR4 RD4: Is Pers Still Treated For Cond CN11, CN18
STILTR5 RD5: Is Pers Still Treated For Cond CN11, CN18
OVRALL3 RD3: How Cond Affect Overall Health CN13, CN19
OVRALL4 RD4: How Cond Affect Overall Health CN13, CN19
OVRALL5 RD5: How Cond Affect Overall Health CN13, CN19
FURTCA3 RD3: Further Treatment Recommended CN14
FURTCA4 RD4: Further Treatment Recommended CN14
FURTCA5 RD5: Further Treatment Recommended CN14
FOLOCA3 RD3: Rcv FollowUp Care For Condition CN15
FOLOCA4 RD4: Rcv FollowUp Care For Condition CN15
FOLOCA5 RD5: Rcv FollowUp Care For Condition CN15
SEEDREF3 RD3: Saw Dr In Reference Period CN03, CN17
SEEDREF4 RD4: Saw Dr In Reference Period CN03, CN17
SEEDREF5 RD5: Saw Dr In Reference Period CN03, CN17
AGEDIAG Age When Diagnosed PE section
REMISSN Is Cancer in Remission/Under Control PE25
CRND1 Has Condition Information In Round Constructed
CRND2 Has Condition Information In Round Constructed
CRND3 Has Condition Information In Round Constructed
CRND4 Has Condition Information In Round Constructed
CRND5 Has Condition Information In Round Constructed
PRIORFLG Location Of Rnd Specific Priority Info Constructed
INJURY Was Condition Due To Accident/Injury CN02
ACCDENTD Date Of Accident -- Day CN06
ACCDENTM Date Of Accident -- Month CN06
ACCDENTY Date Of Accident -- Year CN06
ACCDNJAN Accident/Injury Occur Before/After Jan 1 CN06A
ACCDNWRK Did Accident Occur At Work CN07
ACDNTLOC Where Did Accident Happen CN08
INOUTHH Was Accident Inside/Outside The House CN09
VEHICLE Was A Motor Vehicle Involved CN10
WEAPON Was Some Other Weapon Involved CN10
POISON Was Poison/Poisonous Substance Involved CN10
FIREBURN Was Fire/Burning Involved CN10
DROWN Was Drowning/Near-Drowning Involved CN10
SPORTS Was It A Sports Injury CN10
FALL Was It A Fall CN10
ACDNTOTH Was Something Else Involved CN10
RECOVER Fully Recovered From Condition CN12
INJURFLG Location Of Rnd Specific Injury Info Constructed
MISSWORK Flag Associated With Missed Work Days DD03
MISSSCHL Flag Associated With Missed School Days DD06
INBEDFLG Flag Associated With Bed Days DD09
ICD9CODX ICD-9-CM Code For Condition - Edited CE05, HS04, ER04,
OP09, MV09, HH05,
PM09 (Edited)
ICD9PROX ICD-9-CM Code For Procedure - Edited CE05, HS04, ER04,
OP09, MV09, HH05,
PM09 (Edited)
CCCODEX Clinical Classification Code - Edited Constructed/Edited

Return To Table Of Contents

UTILIZATION VARIABLES

VARIABLE LABEL SOURCE1
HHNUM # Home Health Events Assoc. w/ Condition Constructed
IPNUM # Inpatient Events Assoc. w/ Condition Constructed
OPNUM # Outpatient Events Assoc. w/ Condition Constructed
OBNUM # Office-Based Events Assoc. w/ Condition Constructed
ERNUM # ER Events Assoc. w/ Condition Constructed
RXNUM # Prescribed Medicines Assoc. w/ Cond. Constructed

Return To Table Of Contents

WEIGHTS AND VARIANCE ESTIMATION VARIABLES

VARIABLE LABEL SOURCE1
PERWT07F Expenditure File Person Weight, 2007 Constructed
VARSTR Variance Estimation Stratum, 2007 Constructed
VARPSU Variance Estimation PSU, 2007 Constructed

1See the README file in the Survey Instruments section of the MEPS home page for information on the MEPS HC questionnaire sections (e.g., CN, DD) shown in the Source column.

Return To Table Of Contents

Appendix 2: Condition, Procedure and Clinical Classification Code Frequencies (link to separate file)

Appendix 3: Clinical Classification Code to ICD-9-CM Code Crosswalk (link to separate file)

Appendix 4: List of Priority Conditions

PANEL 11

A. LONG-TERM, LIFE THREATENING CONDITIONS:

Cancer (of any body part)
cancer
tumor
malignancy
malignant tumor
carcinoma
sarcoma
lymphoma
Hodgkin’s disease
leukemia
melanoma
metastasis
neuroma
adenoma

Diabetes
diabetes
diabetes mellitus
high blood sugar
juvenile diabetes (Type I diabetes)
adult-onset diabetes (Type II diabetes)
diabetic neuropathy

Emphysema
emphysema
chronic obstructive pulmonary disease (COPD)
chronic bronchitis (MUST use the word ("chronic", only for adults)
chronic obstructive bronchitis (MUST use the word "chronic", only for adults)
smoker’s cough

High Cholesterol
high cholesterol
high or elevated triglycerides
hyperlipidemia
hypercholesterolemia

HIV/AIDS
HIV
AIDS

Hypertension
hypertension
high blood pressure

Ischemic Heart Disease
ischemic heart disease (MUST use the word "ischemic")
angina
angina pectoris
coronary artery disease
blocked, obstructed, or occluded coronary arteries
arteriosclerosis
myocardial infarction
heart attack

Stroke
stroke
cerebral hemorrhage
cerebral aneurysm
transient ischemic accident
transient ischemic attack
apoplexy
carotid artery blockage
arterial thrombosis in brain
blood clot in brain

B. CHRONIC, MANAGEABLE CONDITIONS:

Arthritis
anything with the word "arthritis"
rheumatoid arthritis
degenerative arthritis
osteoarthritis
bursitis
rheumatism

Asthma
anything with the word ‘asthma’ or ‘asthmatic’

Gall Bladder Disease
gall bladder disease, trouble, attacks, infection, or problems
gallstones

Stomach Ulcers
stomach ulcer
duodenal ulcer
peptic ulcer
bleeding ulcer
ulcerated stomach
perforated ulcer

Back Problems of Any Kind
back problems or pain of any kind (lower or upper back)
sore, hurt, injured, or stiff back
backache
anything with the words ‘vertebra’, ‘vertebrae’, ‘lumbar’, ‘spine’, or ‘spinal’
strained or pulled muscle in back
sprained back
muscle spasms
back spasms
bad back
lumbago
sciatica or sciatic nerve problems
disc problems: herniated, ruptured, slipped, compressed, extruded, dislocated, deteriorated, or misaligned discs

C. MENTAL HEALTH ISSUES:

Alzheimer’s Disease and Other Dementias
anything with the words ‘Alzheimer’s’ or ‘dementia’
organic brain syndrome

Depression and Anxiety Disorders
depression (including severe, chronic, or major depression)
dysthymia
dysthymic disorder
bipolar disorder
manic depression or manic depressive illness
anxiety attacks
panic attacks
anxiety
nerves
nervous condition
nervous breakdown

PANEL 12

Hypertension/High Blood Pressure
Coronary Heart Disease
Angina/Angina Pectoris
Heart Attack/Myocardial Infarction (MI)
Other Heart Disease (not coronary heart disease, angina, or heart attack)
Stroke/Transient Ischemic Attack (TIA)/Mini-stroke
Emphysema
Chronic Bronchitis
High Cholesterol
Cancer/Malignancy
Diabetes/Sugar Diabetes
Joint Pain
Arthritis
Asthma
Attention Deficit Hyperactivity Disorder (ADHD)/Attention Deficit Disorder (ADD)

Return To Table Of Contents

MEPS HOME . CONTACT MEPS . MEPS FAQ . MEPS SITE MAP . MEPS PRIVACY POLICY . ACCESSIBILITY . VIEWERS & PLAYERS . COPYRIGHT
Back to topGo back to top
Back to Top Go back to top

Connect With Us

Facebook Twitter You Tube LinkedIn

Sign up for Email Updates

To sign up for updates or to access your subscriber preferences, please enter your email address below.

Agency for Healthcare Research and Quality

5600 Fishers Lane
Rockville, MD 20857
Telephone: (301) 427-1364

  • Careers
  • Contact Us
  • Español
  • FAQs
  • Accessibility
  • Disclaimers
  • EEO
  • Electronic Policies
  • FOIA
  • HHS Digital Strategy
  • HHS Nondiscrimination Notice
  • Inspector General
  • Plain Writing Act
  • Privacy Policy
  • Viewers & Players
  • U.S. Department of Health & Human Services
  • The White House
  • USA.gov