/*****************************************************************************/ /* SPSS User Files are being provided for the convenience of analysts who */ /* may wish to use SPSS to analyze the MEPS data. However, users are */ /* cautioned that SPSS does not currently have the capability to produce */ /* appropriate standard errors for estimates from a survey with a complex */ /* sample design like the Medical Expenditure Panel Survey (MEPS). The */ /* annual national probability sample of households selected for the MEPS */ /* is a subsample of those participating in the National Health Interview */ /* Survey (NHIS) for the previous calendar year. The NHIS, an ongoing */ /* general health survey of the civilian noninstitutionalized population, */ /* is conducted by the National Center for Health Statistics, Centers for */ /* Disease Control and Prevention. The NHIS sample design, and thus that */ /* of the MEPS, uses complex sampling techniques including */ /* stratification, clustering, and differential sampling rates for the */ /* oversampling of selected subgroups of the population. Because of this */ /* sampling structure, software that accounts for this complex sample */ /* design must be used. Without the use of appropriate software that */ /* accounts for the complex sample design of the MEPS in conjunction with */ /* the survey's sampling weights (reflecting the survey's sample */ /* selection probabilities and nonresponse and other adjustments), the */ /* estimated standard errors of survey point estimates will generally be */ /* underestimated, and, thus, the inferential conclusions in an analysis */ /* (descriptive or analytical) may be misleading. It is recommended that */ /* sample survey software be used to analyze the MEPS data. Software for */ /* analysis of complex survey data include, for example, SUDAAN (Research */ /* Triangle Institute), STATA (Stata Corporation), VPLX (U.S. Bureau of */ /* the Census), and WESVAR (Westat, Inc.). A more comprehensive summary */ /* of software for the analysis of data from surveys with complex sample */ /* designs can be accessed through the website for the American */ /* Statistical Association's Survey Research Methods Section. Users may */ /* also reference the Agency for Healthcare Research and Quality (AHRQ) */ /* web document "Computing Standard Errors for Medical Expenditure Panel */ /* Survey (MEPS) Estimates." */ /*****************************************************************************/ FILE HANDLE INFILE NAME="PMED97.DAT" /LRECL=405. DATA LIST FILE=INFILE / DUID 1-5 PID 6-8 DUPERSID 9-16 (A) RXRECIDX 17-31 (A) LINKIDX 32-43 (A) PURCHRD 44-44 RXBEGDD 45-46 RXBEGMM 47-48 RXBEGYR 49-52 RXNAME 53-102 (A) RXHHNAME 103-132 (A) RXNDC 133-143 (A) RXQUANTY 144-150 (2) RXFORM 151-152 RXFORMOS 153-202 (A) RXSTRENG 203-214 (A) RXUNIT 215-216 RXUNITOS 217-266 (A) PHARTP1 267-268 PHARTP2 269-270 PHARTP3 271-272 PHARTP4 273-274 PHARTP5 275-276 PHARTP6 277-278 PHARTP7 279-280 RXFLG 281-281 PCIMPFLG 282-282 SELFFLG 283-283 INPCFLG 284-284 DIABFLG 285-285 SAMPLE 286-286 RXICD1X 287-289 (A) RXICD2X 290-292 (A) RXICD3X 293-295 (A) RXCCC1X 296-298 (A) RXCCC2X 299-301 (A) RXCCC3X 302-304 (A) NUMCOND 305-306 RXSF97X 307-313 (2) RXMR97X 314-320 (2) RXMD97X 321-327 (2) RXPV97X 328-334 (2) RXVA97X 335-340 (2) RXCH97X 341-346 (2) RXOF97X 347-351 (2) RXSL97X 352-357 (2) RXWC97X 358-363 (2) RXOT97X 364-369 (2) RXOR97X 370-375 (2) RXOU97X 376-381 (2) RXXP97X 382-388 (2) WTDPER97 389-400 (6) VARSTR97 401-403 VARPSU97 404-405 . VARIABLE LABEL DUID 'DWELLING UNIT ID' PID 'PERSON NUMBER' DUPERSID 'PERSON ID (DUID + PID)' RXRECIDX 'UNIQUE Rx/PRESCRIBED MEDICINE IDENTIFIER' LINKIDX 'ID FOR LINKAGE TO COND/OTH EVENT FILES' PURCHRD 'ROUND Rx/PRESCR MED OBTAINED/PURCHASED' RXBEGDD 'DAY PERSON STARTED TAKING MEDICINE' RXBEGMM 'MONTH PERSON STARTED TAKING MEDICINE' RXBEGYR 'YEAR PERSON STARTED TAKING MEDICINE' RXNAME 'MEDICATION NAME (IMPUTED)' RXHHNAME 'HC REPORTED MEDICATION NAME' RXNDC 'NATIONAL DRUG CODE (IMPUTED)' RXQUANTY 'QUANTITY OF Rx/PRESCR MED (IMPUTED)' RXFORM 'FORM OF Rx/PRESCRIBED MEDICINE (IMPUTED)' RXFORMOS 'OTH SPEC FORM OF Rx/PRESCR MED (IMPUTED)' RXSTRENG 'STRENGTH OF Rx/PRESCR MED DOSE (IMPUTED)' RXUNIT 'UNIT OF MEAS Rx/PRESC MED DOSE (IMPUTED)' RXUNITOS 'OTH SPEC UNIT MEAS Rx MED DOSE (IMPUTED)' PHARTP1 'TYPE OF PHARMACY PROV - 1ST' PHARTP2 'TYPE OF PHARMACY PROV - 2ND' PHARTP3 'TYPE OF PHARMACY PROV - 3RD' PHARTP4 'TYPE OF PHARMACY PROV - 4TH' PHARTP5 'TYPE OF PHARMACY PROV - 5TH' PHARTP6 'TYPE OF PHARMACY PROV - 6TH' PHARTP7 'TYPE OF PHARMACY PROV - 7TH' RXFLG 'NDC IMPUTE SCE ON PC DONOR REC (IMPUTED)' PCIMPFLG 'TYPE OF HC TO PC PRESCRIPTION MATCH' SELFFLG 'EVENT IS A SELF-FILER EVENT' INPCFLG 'PID HAS AT LEAST 1 RECORD IN PC' DIABFLG 'Rx INSULIN OR DIABETIC EQUIPMENT/SUPPLY' SAMPLE 'HOUSEHLD RCVD FREE SAMPLE OF Rx IN ROUND' RXICD1X '3 DIGIT ICD-9 CONDITION CODE' RXICD2X '3 DIGIT ICD-9 CONDITION CODE' RXICD3X '3 DIGIT ICD-9 CONDITION CODE' RXCCC1X 'MODIFIED CLINICAL CLASS CODE' RXCCC2X 'MODIFIED CLINICAL CLASS CODE' RXCCC3X 'MODIFIED CLINICAL CLASS CODE' NUMCOND 'TOT # COND RECS LINK TO EVNT' RXSF97X 'AMOUNT PAID, SELF OR FAMILY (IMPUTED)' RXMR97X 'AMOUNT PAID, MEDICARE (IMPUTED)' RXMD97X 'AMOUNT PAID, MEDICAID (IMPUTED)' RXPV97X 'AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)' RXVA97X 'AMOUNT PAID, VETERANS (IMPUTED)' RXCH97X 'AMOUNT PAID, CHAMPUS/CHAMPVA (IMPUTED)' RXOF97X 'AMOUNT PAID, OTHER FEDERAL (IMPUTED)' RXSL97X 'AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)' RXWC97X 'AMOUNT PAID, WORKERS COMP (IMPUTED)' RXOT97X 'AMOUNT PAID, OTHER INSURANCE (IMPUTED)' RXOR97X 'AMOUNT PAID, OTHER PRIVATE (IMPUTED)' RXOU97X 'AMOUNT PAID, OTHER PUBLIC (IMPUTED)' RXXP97X 'SUM OF PAYMENTS RXSF97X-RXOU97X(IMPUTED)' WTDPER97 'POVERTY/MORTALITY ADJUSTED PERS LEVL WGT' VARSTR97 'VARIANCE ESTIMATION STRATUM, 1997' VARPSU97 'VARIANCE ESTIMATION PSU, 1997' . VALUE LABELS DIABFLG 0 '0 NO' 1 '1 YES' / INPCFLG 0 '0 NO' 1 '1 YES' / NUMCOND 0 '0' 10 '10' 11 '11' 12 '12' 13 '13' 14 '14' 15 '15' 16 '16' 4 '4' 5 '5' 6 '6' 7 '7' 8 '8' 9 '9' / PCIMPFLG 0 '0 NONE' 1 '1 EXACT MATCH TO PC Rx FOR PID' 2 '2 REFILL OF EXACT MATCH TO PC Rx FOR PID' 3 '3 NOT EXACT MATCH TO PC Rx FOR PID' / PHARTP1 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PHARTP2 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PHARTP3 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PHARTP4 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PHARTP5 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PHARTP6 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PHARTP7 -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MAIL-ORDER' 2 '2 IN ANOTHER STORE' 3 '3 IN HMO/CLINIC/HOSPITAL' 4 '4 DRUG STORE' / PURCHRD 1 '1' 2 '2' 3 '3' 4 '4' 5 '5' / RXBEGDD -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' / RXBEGMM -1 '-1 INAPPLICABLE' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' / RXBEGYR -1 '-1 INAPPLICABLE' -14 '-14 NOT YET USED/TAKEN' -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 99 '99 HAS NOT YET TAKEN/USED' / RXCCC1X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' / RXCCC2X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' / RXCCC3X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' / RXCH97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXFLG 1 '1 NO IMPUTATION' 2 '2 IMPUTED FROM OTHER PC RECORD' 3 '3 IMPUTED FR SECONDARY SRC, BUT ORIG REPORTED' / RXFORM -7 '-7 REFUSED' -9 '-9 NOT ASCERTAINED' 1 '1 PILLS' 10 '10 PATCHES' 11 '11 TOPICAL GEL/JELLY' 12 '12 POWDER' 13 '13 LANCETS' 14 '14 GRAMS' 15 '15 OUNCES' 16 '16 SOLUTION' 17 '17 TEST STRIPS' 18 '18 SYRINGES' 19 '19 NEBULIZER' 2 '2 LIQUID' 20 '20 Z-PAK' 3 '3 DROPS' 4 '4 TOPICAL OINTMENT' 5 '5 SUPPOSITORIES' 6 '6 AEROSOL/SPRAY,INHALANT' 7 '7 SHAMPOO/SOAP' 8 '8 INJECTION' 9 '9 IV INJECTION' 91 '91 OTHER SPECIFY' / RXICD1X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' / RXICD2X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' / RXICD3X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' / RXMD97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXMR97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXOF97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXOR97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXOT97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXOU97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXPV97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXQUANTY -9 '-9 NOT ASCERTAINED' 0 '0' / RXSF97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXSL97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXUNIT -7 '-7 REFUSED' -8 '-8 DK' -9 '-9 NOT ASCERTAINED' 1 '1 MG' 10 '10 MG/MCG' 11 '11 MG/MG' 12 '12 MG/HR' 13 '13 MEG/ML' 14 '14 MCG/ML' 15 '15 U/GM' 16 '16 U/ML' 17 '17 IU' 2 '2 MCG' 3 '3 MEG' 4 '4 MG/ML' 5 '5 GM' 6 '6 GR' 7 '7 %' 8 '8 ML' 9 '9 COMPOUNDS' 91 '91 OTHER SPECIFY' / RXVA97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXWC97X -9 '-9 NOT ASCERTAINED' 0 '0' / RXXP97X -9 '-9 NOT ASCERTAINED' 0 '0' / SAMPLE 0 '0 NO' 1 '1 YES' / SELFFLG 0 '0 NON-SELF-FILER' 1 '1 SELF-FILER' . EXECUTE.