/*****************************************************************************/ /* 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="PMED99.DAT" /LRECL=539. 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 RXR2FLAG 45-46 RXBEGDD 47-48 RXBEGMM 49-50 RXBEGYR 51-54 RXNAME 55-104 (A) RXHHNAME 105-134 (A) RXNDC 135-145 (A) RXQUANTY 146-152 (2) RXFORM 153-202 (A) RXFRMUNT 203-252 (A) RXSTRENG 253-302 (A) RXUNIT 303-352 (A) RXUNITOS 353-402 (A) PHARTP1 403-404 PHARTP2 405-406 PHARTP3 407-408 PHARTP4 409-410 PHARTP5 411-412 PHARTP6 413-414 PHARTP7 415-416 RXFLG 417-417 PCIMPFLG 418-418 CLMOMFLG 419-419 INPCFLG 420-420 DIABFLG 421-421 SAMPLE 422-422 RXICD1X 423-425 (A) RXICD2X 426-428 (A) RXICD3X 429-431 (A) RXCCC1X 432-434 (A) RXCCC2X 435-437 (A) RXCCC3X 438-440 (A) RXSF99X 441-447 (2) RXMR99X 448-454 (2) RXMD99X 455-461 (2) RXPV99X 462-468 (2) RXVA99X 469-474 (2) RXCH99X 475-480 (2) RXOF99X 481-485 (2) RXSL99X 486-491 (2) RXWC99X 492-497 (2) RXOT99X 498-503 (2) RXOR99X 504-509 (2) RXOU99X 510-515 (2) RXXP99X 516-522 (2) PERWT99F 523-534 (6) VARSTR99 535-537 VARPSU99 538-539 . 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' RXR2FLAG 'FLAG FOR PANEL 3 R2 EVENT IN 1999' 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)' RXFRMUNT 'UNIT OF MEAS FORM Rx/PRESC MED (IMPUTED)' RXSTRENG 'STRENGTH OF Rx/PRESCR MED DOSE (IMPUTED)' RXUNIT 'UNIT OF MEAS STRENGTH OF Rx (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 IMPUTATION SOURCE ON PC DONOR REC' PCIMPFLG 'TYPE OF HC TO PC PRESCRIPTION MATCH' CLMOMFLG 'CHGE/PYMNT, Rx CLAIM FILING, OMTYPE STAT' 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' RXSF99X 'AMOUNT PAID, SELF OR FAMILY (IMPUTED)' RXMR99X 'AMOUNT PAID, MEDICARE (IMPUTED)' RXMD99X 'AMOUNT PAID, MEDICAID (IMPUTED)' RXPV99X 'AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)' RXVA99X 'AMOUNT PAID, VETERANS (IMPUTED)' RXCH99X 'AMOUNT PAID, CHAMPUS/CHAMPVA (IMPUTED)' RXOF99X 'AMOUNT PAID, OTHER FEDERAL (IMPUTED)' RXSL99X 'AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)' RXWC99X 'AMOUNT PAID, WORKERS COMP (IMPUTED)' RXOT99X 'AMOUNT PAID, OTHER INSURANCE (IMPUTED)' RXOR99X 'AMOUNT PAID, OTHER PRIVATE (IMPUTED)' RXOU99X 'AMOUNT PAID, OTHER PUBLIC (IMPUTED)' RXXP99X 'SUM OF PAYMENTS RXSF99X-RXOU99X(IMPUTED)' PERWT99F 'FINAL PERSON LEVEL WEIGHT, 1999' VARSTR99 'VARIANCE ESTIMATION STRATUM, 1999' VARPSU99 'VARIANCE ESTIMATION PSU, 1999' . VALUE LABELS CLMOMFLG 1 '1 C+P=N,FILER=PHARMACY' 2 '2 C+P=N,FILER=NEITHER' 3 '3 C+P=Y,FILER=UNK/INAP' 4 '4 C+P=Y,FILER=FAMILY' 5 '5 C+P=Y,FILER=PHARMACY,OM=2,3' 6 '6 C+P=Y,FILER=NEITHER,OM=2,3' / DIABFLG 0 '0 NO' 1 '1 YES' / INPCFLG 0 '0 NO' 1 '1 YES' / PCIMPFLG 1 '1 EXACT MATCH TO PC Rx FOR PID' 2 '2 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' / RXCCC1X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / RXCCC2X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / RXCCC3X '-1' '-1 INAPPLICABLE' '-7' '-7 REFUSED' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / RXFLG 1 '1 NO IMPUTATION' 2 '2 IMPUTED FROM OTHER PC RECORD' 3 '3 IMPUTED FR SECONDARY SRC, BUT ORIG REPORTED' / RXICD1X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / RXICD2X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / RXICD3X '-1' '-1 INAPPLICABLE' '-8' '-8 DK' '-9' '-9 NOT ASCERTAINED' / RXR2FLAG -1 '-1 NO R2 CROSSOVER PROBLEM' 1 '1 PANEL 3 R2 EVENT IN 1999' / SAMPLE 0 '0 NO' 1 '1 YES' . EXECUTE.