Skip to content

Latest commit

 

History

History
62 lines (37 loc) · 3.31 KB

README.md

File metadata and controls

62 lines (37 loc) · 3.31 KB
Raw

Medical Expenditure Panel Survey data

https://meps.ahrq.gov/mepsweb/

The Medical Expenditure Panel Survey (MEPS) data consists of large scale surveys of families and individuals, medical providers, and employers, and collects data on health services used, costs & frequency of services, demographics, health status and conditions, etc., of the respondents.

Source / Data Set Description:

2015 full Year Consolidated Data File: Contains MEPS survey data for calendar year 2015 obtained in rounds 3, 4, and 5 of Panel 19, and rounds 1, 2, and 3 of Panel 20. See the "Data" table for data files in different formats.

Information on the variables in the data can be found in the corresponding Codebook and also from IPUMS (selecting a variable will bring up a description).

Data Use Agreement

As the user of the data it is your responsibility to read and abide by any copyright/usage rules and restrictions as stated on the MEPS web site before downloading the data.

Download instructions

In order to use the MEPS datasets with AIX360, please follow the following directions to download the datafiles and convert into csv files.

Follow either set of instructions below for using R or SPSS. Further instructions for SAS, and Stata, are available at the AHRQ MEPS Github repository.

  • Generating CSV files with R

    In the current folder run the R script generate_data.R. R can be downloaded from CRAN. If you are working on Mac OS X the easiest way to get the R command line support is by installing it with Homebrew brew install R.

    cd aix360/data/meps_data
Rscript generate_data.R

    Example output:

    Loading required package: foreign

trying URL 'https://meps.ahrq.gov/mepsweb/data_files/pufs/h181ssp.zip'
Content type 'application/zip' length 13303652 bytes (12.7 MB)
==================================================
downloaded 12.7 MB

Loading dataframe from file: h181.ssp
Exporting dataframe to file: h181.csv

  • Generating CSV files with SPSS

    The instructions below require the use of SPSS.

    • Download the Data File, ASCII format
    • Extract the file h181.dat from downloaded zip archive
    • Convert the file to comma-delimited format, h181.csv, and save in this folder.
      • To convert the .dat file into csv format,download one of the programming statements files, such as the SPSS Programming Statements file.
      • Edit this file to change the FILE HANDLE name to the complete path/name of the downloaded data file, execute the SPSS programming statements to load the data, and 'save as' a comma-delimited file called 'h181.csv' in the current folder.