Skip Navigation U.S. Department of Health and Human Services www.hhs.gov
Agency for Healthcare Research Quality www.ahrq.gov
AHRQ Home | Questions? | Contact Us | Site Map | What's New | Browse | Información en español | E-mail Updates   E-mail Updates
www.ahrq.gov
MEPS Home Medical Expenditure Panel Survey
Font Size:
Contact MEPS FAQ Espanol Site Map
 
S
M
L
XL
 
spacer
 MEPS Home
 About MEPS
 :: Survey Background
 :: Workshops & Events
 :: Data Release Schedule
 Survey Components
 :: Household
 :: Insurance/Employer
 :: Medical Provider
 :: Survey Questionnaires
 Data and Statistics
 :: Data Overview
 :: MEPS Topics
 :: Publications Search
 :: Summary Data Tables
 :: MEPSnet Query Tools
 :: Data Files
 :: Data Centers
 Communication
 :: What's New
 :: Mailing List
 :: Discussion Forum
 :: Participants' Corner

 

 
Variable Locator Tool
Variable Locator Home > View File List > View File Details
Details for File HC110A

Search for Variables in This File | Show in Excel Format | Show in CSV Format | Show in Rich Text Format
Select a link above to open the file with the default application or save it to disk. Saved files may be opened using multiple software options.

File Attribute Attribute Value
File Name  HC110A
File Type  Events
Title  HC-110A 2007 Prescribed Medicines
Description  This file is one in a series of public use event files from the 2007 Medical Expenditure Panel Survey Household Component (MEPS HC) and Medical Provider Component (MPC). Released as an ASCII data file and SAS transport file (with SAS and SPSS user statements) this public use file provides detailed information on household-reported prescribed medicines for a nationally representative sample of the civilian noninstitutionalized population of the United States and can be used to make estimates of prescribed medicine utilization and expenditures for calendar year 2007. Each record represents one household-reported prescribed medicine that was purchased during calendar year 2007. These data were collected during the 2007 portion of Round 3 and Rounds 4 and 5 for Panel 11, as well as Rounds 1, 2 and the 2008 portion of Round 3 for Panel 12 of the MEPS HC. Each record on this event file represents a unique prescribed medicine event that is, a prescribed medicine reported as being purchased or otherwise obtained by t
Data Year(s)  2007
Records  300099
Population 
Status  Complete
Web Page http://www.meps.ahrq.gov/mepsweb/data_stats/download_data_files_detail.jsp?cboPufNumber=HC-110A


Select the name to display variable details; select column headings to sort the list.
Name Position Label Category
CLMOMFLG 30 CHGE/PYMNT, Rx CLAIM FILING, OMTYPE STAT Event Description
DUID 1 DWELLING UNIT ID Identifiers
DUPERSID 71 PERSON ID (DUID + PID) Identifiers
INPCFLG 31 PID HAS AT LEAST 1 RECORD IN PC Event Description
LINKIDX 4 ID FOR LINKAGE TO COND/OTH EVENT FILES Identifiers
PANEL 5 PANEL NUMBER Survey Administration and Eligibility Status
PCIMPFLG 29 TYPE OF HC TO PC PRESCRIPTION MATCH Event Description
PERWT07F 68 FINAL PERSON LEVEL WEIGHT, 2007 Sampling Weights and Variance Estimation
PHARTP1 16 TYPE OF PHARMACY PROV - 1ST Event Description
PHARTP10 25 TYPE OF PHARMACY PROV - 10TH Event Description
PHARTP11 26 TYPE OF PHARMACY PROV - 11TH Event Description
PHARTP12 27 TYPE OF PHARMACY PROV - 12TH Event Description
PHARTP2 17 TYPE OF PHARMACY PROV - 2ND Event Description
PHARTP3 18 TYPE OF PHARMACY PROV - 3RD Event Description
PHARTP4 19 TYPE OF PHARMACY PROV - 4TH Event Description
PHARTP5 20 TYPE OF PHARMACY PROV - 5TH Event Description
PHARTP6 21 TYPE OF PHARMACY PROV - 6TH Event Description
PHARTP7 22 TYPE OF PHARMACY PROV - 7TH Event Description
PHARTP8 23 TYPE OF PHARMACY PROV - 8TH Event Description
PHARTP9 24 TYPE OF PHARMACY PROV - 9TH Event Description
PID 2 PERSON NUMBER Identifiers
PREGCAT 39 MULTUM PREGNANCY CATEGORY Event Description
PURCHRD 6 ROUND Rx/PRESCR MED OBTAINED/PURCHASED Event Description
RXBEGMM 7 MONTH PERSON STARTED TAKING MEDICINE Event Description
RXBEGYRX 8 YEAR PERSON STARTED TAKING MEDICINE Event Description
RXCCC1X 36 MODIFIED CLINICAL CLASS CODE Event Description
RXCCC2X 37 MODIFIED CLINICAL CLASS CODE Event Description
RXCCC3X 38 MODIFIED CLINICAL CLASS CODE Event Description
RXFLG 28 NDC IMPUTATION SOURCE ON PC DONOR REC Event Description
RXFORM 12 FORM OF Rx/PRESCRIBED MEDICINE (IMPUTED) Event Description
RXFRMUNT 13 UNIT OF MEAS FORM Rx/PRESC MED (IMPUTED) Event Description
RXICD1X 33 3 DIGIT ICD-9 CONDITION CODE Event Description
RXICD2X 34 3 DIGIT ICD-9 CONDITION CODE Event Description
RXICD3X 35 3 DIGIT ICD-9 CONDITION CODE Event Description
RXMD07X 57 AMOUNT PAID, MEDICAID (IMPUTED) Event-level Expenditures
RXMR07X 56 AMOUNT PAID, MEDICARE (IMPUTED) Event-level Expenditures
RXNAME 9 MEDICATION NAME (IMPUTED) Event Description
RXNDC 10 NATIONAL DRUG CODE (IMPUTED) Event Description
RXOF07X 61 AMOUNT PAID, OTHER FEDERAL (IMPUTED) Event-level Expenditures
RXOR07X 65 AMOUNT PAID, OTHER PRIVATE (IMPUTED) Event-level Expenditures
RXOT07X 64 AMOUNT PAID, OTHER INSURANCE (IMPUTED) Event-level Expenditures
RXOU07X 66 AMOUNT PAID, OTHER PUBLIC (IMPUTED) Event-level Expenditures
RXPV07X 58 AMOUNT PAID, PRIVATE INSURANCE (IMPUTED) Event-level Expenditures
RXQUANTY 11 QUANTITY OF Rx/PRESCR MED (IMPUTED) Event Description
RXRECIDX 3 UNIQUE Rx/PRESCRIBED MEDICINE IDENTIFIER Identifiers
RXSF07X 55 AMOUNT PAID, SELF OR FAMILY (IMPUTED) Event-level Expenditures
RXSL07X 62 AMOUNT PAID, STATE & LOCAL GOV (IMPUTED) Event-level Expenditures
RXSTRENG 14 STRENGTH OF Rx/PRESCR MED DOSE (IMPUTED) Event Description
RXSTRUNT 15 UNIT OF MEAS STRENGTH OF Rx (IMPUTED) Event Description
RXTR07X 60 AMOUNT PAID, TRICARE (IMPUTED) Event-level Expenditures
RXVA07X 59 AMOUNT PAID, VETERANS (IMPUTED) Event-level Expenditures
RXWC07X 63 AMOUNT PAID, WORKERS COMP (IMPUTED) Event-level Expenditures
RXXP07X 67 SUM OF PAYMENTS RXSF07X-RXOU07X(IMPUTED) Event Description
SAMPLE 32 HOUSEHLD RCVD FREE SAMPLE OF Rx IN ROUND Event Description
TC1 40 MULTUM THERAPEUTIC CLASS #1 Event Description
TC1S1 41 MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC1 Event Description
TC1S1_1 42 MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S1 Event Description
TC1S1_2 43 MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S1 Event Description
TC1S2 44 MULTUM THERAPEUTIC SUB-CLASS #2 FOR TC1 Event Description
TC1S2_1 45 MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S2 Event Description
TC1S3 46 MULTUM THERAPEUTIC SUB-CLASS #3 FOR TC1 Event Description
TC1S3_1 47 MULTUM THERAPEUT SUB-SUB-CLASS FOR TC1S3 Event Description
TC2 48 MULTUM THERAPEUTIC CLASS #2 Event Description
TC2S1 49 MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC2 Event Description
TC2S1_1 50 MULTUM THERAPEUT SUB-SUB-CLASS FOR TC2S1 Event Description
TC2S1_2 51 MULTUM THERAPEUT SUB-SUB-CLASS FOR TC2S1 Event Description
TC2S2 52 MULTUM THERAPEUTIC SUB-CLASS #2 FOR TC2 Event Description
TC3 53 MULTUM THERAPEUTIC CLASS #3 Event Description
TC3S1 54 MULTUM THERAPEUTIC SUB-CLASS #1 FOR TC3 Event Description
VARPSU 70 VARIANCE ESTIMATION PSU, 2007 Sampling Weights and Variance Estimation
VARSTR 69 VARIANCE ESTIMATION STRATUM, 2007 Sampling Weights and Variance Estimation

   Page last revised:  January 31, 2012
MEPS HOME . CONTACT MEPS . MEPS FAQ . MEPS SITE MAP . MEPS PRIVACY POLICY . ACCESSIBILITY . COPYRIGHT