Use, expenditures, and population dollars

These MEPS summary tables provide statistics on health care utilization and expenditures. Types of data available include number of people, percentage of people with an expense, total expenditures, mean and median expenditures per person, total number of health care events, mean number of events per person, and mean spending per event. Data can be grouped by event type (such as prescription medicines or dental visits), by source of payment (such as Medicare or Medicaid), or by demographic characteristics (such as age, race, or sex).

Use the options below to select a statistic of interest, the data view ("Trends over time" or "Cross-sectional"), data years, and grouping variables. If you select "Trends over time", you can choose a range of years. The "Cross-sectional" view displays a single year, which can be stratified by up to two grouping variables. Once a grouping variable is selected, a dropdown menu will appear, enabling selection of specific levels in each group.

After you select the available options, the table will automatically be updated. The data can be viewed as a plot under the "Plot" tab, with line graphs for trends over time and grouped bar graphs for the cross-sectional view. The "Code" tab displays R and SAS code needed to replicate the data shown in the table. The generated table, plot, and codes can be downloaded with the download button under each tab. To view standard errors in the table or 95% confidence intervals in the plot, select the "Show standard errors" checkbox.

(Standard errors are approximately zero for control totals)
Select data view:
Select years
Updating, please wait...
Loading data...
No non-missing data available for selections. Please try again.
Download code

To run the code, first download and unzip the required public use data files from the MEPS data files page, and save them to your computer. More information on downloading and analyzing MEPS data in R, SAS, and Stata can be found at the AHRQ GitHub site External Link. Note that some standard error estimates may differ between R and SAS, since SAS doesn't support any options to adjust for lonely PSUs.

The following code can be used to generate the selected estimates, where the SAS transport data files (.ssp) have been saved to the folder 'C:\MEPS'. For trend estimates, example code is shown for the most recent year selected:


      

Notes

This tool is provided as a convenience. It is the responsibility of the user to review results for statistical significance and overall reasonableness.

About the data

The MEPS Household Component collects data on all members of sample households who are in-scope for the survey. These data can be used to produce nationally representative estimates of medical conditions, health status, use of medical care services, charges and payments, access to care, satisfaction with care, health insurance coverage, income, and employment. The target population represented in the tables and figures is persons in the U.S. civilian non-institutionalized population for all or part of the year.

Suggested citation