/************************************************************************************************/ /* Stata User File for H197G 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 */ /* (H197G.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 H197G.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\H197G.DO */ /* The program below will output the Stata dataset H197G.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H197G.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 MPCELIG 44-44 byte MPCDATA 45-45 int OBDATEYR 46-49 byte OBDATEMM 50-51 byte SEETLKPV 52-53 byte SEEDOC 54-55 byte DRSPLTY 56-57 byte MEDPTYPE 58-59 byte DOCATLOC 60-61 byte VSTCTGRY 62-63 byte VSTRELCN 64-65 byte LABTEST 66-67 byte SONOGRAM 68-69 byte XRAYS 70-71 byte MAMMOG 72-73 byte MRI 74-75 byte EKG 76-77 byte RCVVAC 78-79 byte OTHSVCE 80-81 byte SURGPROC 82-83 byte MEDPRESC 84-85 byte FFOBTYPE 86-87 byte FFBEF17 88-89 byte FFTOT18 90-91 double OBSF17X 92-99 double OBMR17X 100-107 double OBMD17X 108-115 double OBPV17X 116-123 double OBVA17X 124-131 double OBTR17X 132-138 double OBOF17X 139-145 double OBSL17X 146-153 double OBWC17X 154-160 double OBOR17X 161-168 double OBOU17X 169-176 double OBOT17X 177-184 double OBXP17X 185-192 double OBTC17X 193-201 byte IMPFLAG 202-202 double PERWT17F 203-214 int VARSTR 215-218 byte VARPSU 219-219 using H197G.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 MPCELIG "MPC ELIGIBILITY FLAG"; label variable MPCDATA "MPC DATA FLAG"; label variable OBDATEYR "EVENT DATE - YEAR"; label variable OBDATEMM "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 "MVIS DOCTOR S SPECIALTY"; label variable MEDPTYPE "TYPE OF MED PERSON P TALKED TO ON VST DT"; label variable DOCATLOC "ANY MD WORK AT LOCATION WHERE P SAW PROV"; 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 FFOBTYPE "FLAT FEE BUNDLE"; label variable FFBEF17 "TOTAL # OF VISITS IN FF BEFORE 2017"; label variable FFTOT18 "TOTAL # OF VISITS IN FF AFTER 2017"; label variable OBSF17X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable OBMR17X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable OBMD17X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable OBPV17X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable OBVA17X "AMOUNT PAID, VETERANS/CHAMPVA(IMPUTED)"; label variable OBTR17X "AMOUNT PAID, TRICARE(IMPUTED)"; label variable OBOF17X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable OBSL17X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable OBWC17X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable OBOR17X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable OBOU17X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable OBOT17X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable OBXP17X "SUM OF OBSF17X - OBOT17X (IMPUTED)"; label variable OBTC17X "HHLD REPORTED TOTAL 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 H197G0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197G0002X -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 H197G0003X -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 H197G0004X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H197G0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0006X -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 H197G0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0008X -1 "-1 INAPPLICABLE" 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 H197G0009X -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 H197G0010X -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 H197G0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197G0012X -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" 13 "13 RECEPTIONIST/CLERK/SECRETARY" 14 "14 ACUPUNCTURIST" 15 "15 MASSAGE THERAPIST" 16 "16 HOMEOPATHIC/NATUROPATHIC/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 H197G0013X 1 "1 HAS MPC DATA" 2 "2 NO MPC DATA" ; label define H197G0014X 1 "1 MPC ELIGIBLE" 2 "2 NOT MPC ELIGIBLE" ; label define H197G0015X -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 H197G0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H197G0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2017 "2017" ; label define H197G0018X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0019X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0020X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0021X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0022X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0023X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0024X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0025X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0026X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0027X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0028X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0029X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0030X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0031X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H197G0032X -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 H197G0033X 21 "PANEL 21" 22 "PANEL 22" ; label define H197G0034X -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 H197G0035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197G0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 SAW PROVIDER" 2 "2 TELEPHONE CALL" ; label define H197G0037X -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 H197G0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197G0039X -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 H197G0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H197G0041X -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 DOCATLOC H197G0001X; label value DRSPLTY H197G0002X; label value EKG H197G0003X; label value EVENTRN H197G0004X; label value FFBEF17 H197G0005X; label value FFOBTYPE H197G0006X; label value FFTOT18 H197G0007X; label value IMPFLAG H197G0008X; label value LABTEST H197G0009X; label value MAMMOG H197G0010X; label value MEDPRESC H197G0011X; label value MEDPTYPE H197G0012X; label value MPCDATA H197G0013X; label value MPCELIG H197G0014X; label value MRI H197G0015X; label value OBDATEMM H197G0016X; label value OBDATEYR H197G0017X; label value OBMD17X H197G0018X; label value OBMR17X H197G0019X; label value OBOF17X H197G0020X; label value OBOR17X H197G0021X; label value OBOT17X H197G0022X; label value OBOU17X H197G0023X; label value OBPV17X H197G0024X; label value OBSF17X H197G0025X; label value OBSL17X H197G0026X; label value OBTC17X H197G0027X; label value OBTR17X H197G0028X; label value OBVA17X H197G0029X; label value OBWC17X H197G0030X; label value OBXP17X H197G0031X; label value OTHSVCE H197G0032X; label value PANEL H197G0033X; label value RCVVAC H197G0034X; label value SEEDOC H197G0035X; label value SEETLKPV H197G0036X; label value SONOGRAM H197G0037X; label value SURGPROC H197G0038X; label value VSTCTGRY H197G0039X; label value VSTRELCN H197G0040X; label value XRAYS H197G0041X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H197G, replace; #delimit cr * data file is stored in H197G.dta * log file is stored in H197G.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 H197G.LOG and a data file named H197G.DTA. If these files (H197G.DTA and H197G.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. ************************************************************************************************/