/************************************************************************************************/ /* Stata User File for H197F Data */ /* */ /* This file contains information and a sample Stata program to create a permanent */ /* Stata dataset for users who want to use Stata in processing the MEPS data provided */ /* in this PUF release. Stata (StataCorp) has the capability to produce */ /* appropriate standard errors for estimates from a survey with a complex sample */ /* design such as the Medical Expenditure Panel Survey (MEPS). */ /* The input file for creating a permanent Stata dataset is the ASCII data file */ /* (H197F.DAT) supplied in this PUF release, which in turn can be extracted from the */ /* .EXE file. After entering the Stata interactive environment access the Stata DO-File */ /* editor by clicking on the appropriate icon in the command line at the top of the */ /* screen. Copy and paste the following Stata commands into the editor and save as a */ /* DO file. A DO file is a Stata program which may then be executed using the DO command. */ /* For example, if the DO file is named H197F.DO and is located in the directory */ /* C:\MEPS\PROG, then the file may be executed by typing the following command into */ /* the Stata command line: */ /* do C:\MEPS\PROG\H197F.DO */ /* The program below will output the Stata dataset H197F.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H197F.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-5 int PID 6-8 str DUPERSID 9-16 str EVNTIDX 17-28 byte EVENTRN 29-29 str FFEEIDX 30-41 byte PANEL 42-43 byte MPCDATA 44-44 int OPDATEYR 45-48 byte OPDATEMM 49-50 byte SEETLKPV 51-52 byte SEEDOC 53-54 byte DRSPLTY 55-56 byte MEDPTYPE 57-58 byte VSTCTGRY 59-60 byte VSTRELCN 61-62 byte LABTEST 63-64 byte SONOGRAM 65-66 byte XRAYS 67-68 byte MAMMOG 69-70 byte MRI 71-72 byte EKG 73-74 byte RCVVAC 75-76 byte OTHSVCE 77-78 byte SURGPROC 79-80 byte MEDPRESC 81-82 byte FFOPTYPE 83-84 double OPXP17X 85-93 double OPTC17X 94-103 double OPFSF17X 104-111 double OPFMR17X 112-119 double OPFMD17X 120-127 double OPFPV17X 128-135 double OPFVA17X 136-143 double OPFTR17X 144-151 double OPFOF17X 152-157 double OPFSL17X 158-164 double OPFWC17X 165-173 double OPFOR17X 174-181 double OPFOU17X 182-188 double OPFOT17X 189-196 double OPFXP17X 197-205 double OPFTC17X 206-215 double OPDSF17X 216-222 double OPDMR17X 223-229 double OPDMD17X 230-236 double OPDPV17X 237-244 double OPDVA17X 245-251 double OPDTR17X 252-258 double OPDOF17X 259-263 double OPDSL17X 264-269 double OPDWC17X 270-276 double OPDOR17X 277-284 double OPDOU17X 285-290 double OPDOT17X 291-297 double OPDXP17X 298-305 double OPDTC17X 306-313 byte IMPFLAG 314-314 double PERWT17F 315-326 int VARSTR 327-330 byte VARPSU 331-331 using H197F.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "PERSON NUMBER"; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable EVNTIDX "EVENT ID"; label variable EVENTRN "EVENT ROUND NUMBER"; label variable FFEEIDX "FLAT FEE ID"; label variable PANEL "PANEL NUMBER"; label variable MPCDATA "MPC DATA FLAG"; label variable OPDATEYR "EVENT DATE - YEAR"; label variable OPDATEMM "EVENT DATE - MONTH"; label variable SEETLKPV "DID P VISIT PROV IN PERSON OR TELEPHONE"; label variable SEEDOC "DID P TALK TO MD THIS VISIT/PHONE CALL"; label variable DRSPLTY "OPAT DOCTOR S SPECIALTY"; label variable MEDPTYPE "TYPE OF MED PERSON P TALKED TO ON VST DT"; label variable VSTCTGRY "BEST CATEGORY FOR CARE P RECV ON VST DT"; label variable VSTRELCN "THIS VST/PHONE CALL RELATED TO SPEC COND"; label variable LABTEST "THIS VISIT DID P HAVE LAB TESTS"; label variable SONOGRAM "THIS VISIT DID P HAVE SONOGRAM OR ULTRSD"; label variable XRAYS "THIS VISIT DID P HAVE X-RAYS"; label variable MAMMOG "THIS VISIT DID P HAVE A MAMMOGRAM"; label variable MRI "THIS VISIT DID P HAVE AN MRI/CATSCAN"; label variable EKG "THIS VISIT DID P HAVE AN EKG, EEG OR ECG"; label variable RCVVAC "THIS VISIT DID P RECEIVE A VACCINATION"; label variable OTHSVCE "THIS VISIT DID P HAVE OTH DIAG TEST/EXAM"; label variable SURGPROC "WAS SURG PROC PERFORMED ON P THIS VISIT"; label variable MEDPRESC "ANY MEDICINE PRESCRIBED FOR P THIS VISIT"; label variable FFOPTYPE "FLAT FEE BUNDLE"; label variable OPXP17X "TOT EXP FOR EVENT (OPFXP17X + OPDXP17X)"; label variable OPTC17X "TOTAL CHG FOR EVENT (OPFTC17X+OPDTC17X)"; label variable OPFSF17X "FACILITY AMT PD, FAMILY (IMPUTED)"; label variable OPFMR17X "FACILITY AMT PD, MEDICARE (IMPUTED)"; label variable OPFMD17X "FACILITY AMT PD, MEDICAID (IMPUTED)"; label variable OPFPV17X "FACILITY AMT PD, PRIV INSUR (IMPUTED)"; label variable OPFVA17X "FAC AMT PD,VETERANS/CHAMPVA(IMPUTED)"; label variable OPFTR17X "FACILITY AMT PD,TRICARE(IMPUTED)"; label variable OPFOF17X "FACILITY AMT PD, OTH FEDERAL (IMPUTED)"; label variable OPFSL17X "FACILITY AMT PD, STATE/LOC GOV (IMPUTED)"; label variable OPFWC17X "FACILITY AMT PD, WORKERS COMP (IMPUTED)"; label variable OPFOR17X "FACILITY AMT PD, OTH PRIV (IMPUTED)"; label variable OPFOU17X "FACILITY AMT PD, OTH PUB (IMPUTED)"; label variable OPFOT17X "FACILITY AMT PD, OTH INSUR (IMPUTED)"; label variable OPFXP17X "FACILITY SUM PAYMENTS OPFSF17X-OPFOT17X"; label variable OPFTC17X "TOTAL FACILITY CHARGE (IMPUTED)"; label variable OPDSF17X "DOCTOR AMOUNT PAID, FAMILY (IMPUTED)"; label variable OPDMR17X "DOCTOR AMOUNT PAID, MEDICARE (IMPUTED)"; label variable OPDMD17X "DOCTOR AMOUNT PAID, MEDICAID (IMPUTED)"; label variable OPDPV17X "DOCTOR AMT PD, PRIVATE INSUR (IMPUTED)"; label variable OPDVA17X "DR AMT PD,VETERANS/CHAMPVA(IMPUTED)"; label variable OPDTR17X "DOCTOR AMT PD,TRICARE(IMPUTED)"; label variable OPDOF17X "DOCTOR AMT PAID, OTH FEDERAL (IMPUTED)"; label variable OPDSL17X "DOCTOR AMT PD, STATE/LOC GOV (IMPUTED)"; label variable OPDWC17X "DOCTOR AMOUNT PD, WORKERS COMP (IMPUTED)"; label variable OPDOR17X "DOCTOR AMT PD, OTH PRIVATE (IMPUTED)"; label variable OPDOU17X "DOCTOR AMT PD, OTH PUBLIC (IMPUTED)"; label variable OPDOT17X "DOCTOR AMT PAID, OTH INSUR (IMPUTED)"; label variable OPDXP17X "DOCTOR SUM PAYMENTS OPDSF17X-OPDOT17X"; label variable OPDTC17X "TOTAL DOCTOR CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT17F "EXPENDITURE FILE PERSON WEIGHT, 2017"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2017"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2017"; *DEFINE VALUE LABELS FOR REPORTS; label define H197F0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 ALLERGY/IMMUNOLOGY" 10 "10 GERIATRICS (ELDERLY)" 11 "11 GYNECOLOGY/OBSTETRICS" 12 "12 HEMATOLOGY (BLOOD)" 13 "13 HOSPITAL RESIDENCE" 14 "14 INTERNAL MEDICINE" 15 "15 NEPHROLOGY (KIDNEYS)" 16 "16 NEUROLOGY" 18 "18 ONCOLOGY" 19 "19 OPHTHALMOLOGY" 2 "2 ANESTHESIOLOGY" 20 "20 ORTHOPEDICS" 21 "21 OSTEOPATHY" 22 "22 OTORHINOLARYNGOLOGY" 23 "23 PATHOLOGY" 24 "24 PEDIATRICIAN" 25 "25 PHYSICAL MEDICINE/REHAB" 26 "26 PLASTIC SURGERY" 27 "27 PROCTOLOGY" 28 "28 PSYCHIATRY" 29 "29 PULMONARY" 3 "3 CARDIOLOGY (HEART)" 30 "30 RADIOLOGY" 31 "31 RHEUMATOLOGY (ARTHRITIS)" 32 "32 THORACIC SURGERY" 33 "33 UROLOGY" 4 "4 DERMATOLOGY (SKIN)" 5 "5 ENDOCRINOLOGY/METABOLISM" 6 "6 FAMILY PRACTICE" 7 "7 GASTROENTEROLOGY" 8 "8 GENERAL PRACTICE" 9 "9 GENERAL SURGERY" 91 "91 OTHER DR SPECIALTY" ; label define H197F0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0003X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H197F0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FLAT FEE STEM" 2 "2 FLAT FEE LEAF" ; label define H197F0005X 0 "0 NOT ELIGIBLE FOR IMPUTATION" 1 "1 COMPLETE HC DATA" 2 "2 COMPLETE MPC DATA" 3 "3 FULLY IMPUTED" 4 "4 PARTIALLY IMPUTED" 5 "5 CAPITATION IMPUTATION" ; label define H197F0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197F0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 CHIROPRACTOR" 10 "10 PSYCHOLOGIST" 11 "11 SOCIAL WORKER" 12 "12 TECHNICIAN" 14 "14 ACUPUNCTURIST" 15 "15 MASSAGE THERAPIST" 16 "16 HOMEOPATHIC/NATURAPATHIC/HERBALIST" 17 "17 OTHER ALTERNATIVE/COMPLEMENTARY CARE PRO" 2 "2 DENTIST/DENTAL CARE PERSON" 3 "3 MIDWIFE" 4 "4 NURSE/NURSE PRACTITIONER" 5 "5 OPTOMETRIST" 6 "6 PODIATRIST" 7 "7 PHYSICIAN'S ASSISTANT" 8 "8 PHYSICAL THERAPIST" 9 "9 OCCUPATIONAL THERAPIST" 91 "91 OTHER" ; label define H197F0010X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H197F0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H197F0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2017 "2017" ; label define H197F0014X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0015X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0016X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0017X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0030X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0031X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0032X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0033X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0034X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0035X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0036X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0037X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0038X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0039X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0040X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0041X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0042X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0043X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197F0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0045X 21 "PANEL 21" 22 "PANEL 22" ; label define H197F0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197F0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 SAW PROVIDER" 2 "2 TELEPHONE CALL" ; label define H197F0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; label define H197F0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 GENERAL CHECKUP" 10 "10 LASER EYE SURGERY" 2 "2 DIAGNOSIS OR TREATMENT" 3 "3 EMERGENCY (E.G., ACCIDENT OR INJURY)" 4 "4 PSYCHOTHERAPY/MENTAL HEALTH COUNSELING" 5 "5 FOLLOW-UP OR POST-OPERATIVE VISIT" 6 "6 IMMUNIZATIONS OR SHOTS" 7 "7 VISION EXAM" 8 "8 PREGNANCY-RELATED (INC PRENATAL/ DELV)" 9 "9 WELL CHILD EXAM" 91 "91 OTHER" ; label define H197F0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197F0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 NO SERVICES RECEIVED" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value DRSPLTY H197F0001X; label value EKG H197F0002X; label value EVENTRN H197F0003X; label value FFOPTYPE H197F0004X; label value IMPFLAG H197F0005X; label value LABTEST H197F0006X; label value MAMMOG H197F0007X; label value MEDPRESC H197F0008X; label value MEDPTYPE H197F0009X; label value MPCDATA H197F0010X; label value MRI H197F0011X; label value OPDATEMM H197F0012X; label value OPDATEYR H197F0013X; label value OPDMD17X H197F0014X; label value OPDMR17X H197F0015X; label value OPDOF17X H197F0016X; label value OPDOR17X H197F0017X; label value OPDOT17X H197F0018X; label value OPDOU17X H197F0019X; label value OPDPV17X H197F0020X; label value OPDSF17X H197F0021X; label value OPDSL17X H197F0022X; label value OPDTC17X H197F0023X; label value OPDTR17X H197F0024X; label value OPDVA17X H197F0025X; label value OPDWC17X H197F0026X; label value OPDXP17X H197F0027X; label value OPFMD17X H197F0028X; label value OPFMR17X H197F0029X; label value OPFOF17X H197F0030X; label value OPFOR17X H197F0031X; label value OPFOT17X H197F0032X; label value OPFOU17X H197F0033X; label value OPFPV17X H197F0034X; label value OPFSF17X H197F0035X; label value OPFSL17X H197F0036X; label value OPFTC17X H197F0037X; label value OPFTR17X H197F0038X; label value OPFVA17X H197F0039X; label value OPFWC17X H197F0040X; label value OPFXP17X H197F0041X; label value OPTC17X H197F0042X; label value OPXP17X H197F0043X; label value OTHSVCE H197F0044X; label value PANEL H197F0045X; label value RCVVAC H197F0046X; label value SEEDOC H197F0047X; label value SEETLKPV H197F0048X; label value SONOGRAM H197F0049X; label value SURGPROC H197F0050X; label value VSTCTGRY H197F0051X; label value VSTRELCN H197F0052X; label value XRAYS H197F0053X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H197F, replace; #delimit cr * data file is stored in H197F.dta * log file is stored in H197F.log log close /************************************************************************************************ NOTES: 1. This program has been tested on Stata Version 10 (for Windows). 2. This program will create a permanent Stata dataset. All additional analyses can be run using this dataset. In addition to the dataset, this program creates a log file named H197F.LOG and a data file named H197F.DTA. If these files (H197F.DTA and H197F.LOG) already exist in the working directory, they will be replaced when this program is executed. 3. If the program ends prematurely, the log file will remain open. Before running this program again, the user should enter the following Stata command: log close 4. The cd command assigns C:\MEPS\DATA as the working directory and location of the input ASCII and output .DTA and .LOG files and can be modified by the user as necessary. 5. Stata commands end with a carriage return by default. The command #delimit ; temporarily changes the command ending delimiter from a carriage return to a semicolon. 6. The infix command assumes that the input variables are numeric unless the variable name is prefaced by str. For example, DUPERSID is the a string (or character) variable. ************************************************************************************************/