/************************************************************************************************/ /* Stata User File for H213B 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 */ /* (H213B.DAT) supplied in this PUF release. */ /* 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 H213B.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\H213B.DO */ /* The program below will output the Stata dataset H213B.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H213B.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-7 int PID 8-10 str DUPERSID 11-20 str EVNTIDX 21-36 byte EVENTRN 37-37 str FFEEIDX 38-51 byte PANEL 52-53 int DVDATEYR 54-57 byte DVDATEMM 58-59 byte GENDENT_M18 60-61 byte DENTHYG_M18 62-63 byte DNSPCLST_M18 64-65 byte DENTYPE_M18 66-67 byte PEDDENT_M18 68-69 byte EXAMINE_M18 70-71 byte CLENTETH_M18 72-73 byte JUSTXRAY_M18 74-75 byte FLUORIDE_M18 76-77 byte SEALANT_M18 78-79 byte FILLINGX 80-81 byte FILLING_M18 82-83 byte ROOTCANX 84-85 byte ROOTCANL_M18 86-87 byte GUMSURGX 88-89 byte GUMSURG_M18 90-91 byte IMPLANTX 92-93 byte IMPLANT_M18 94-95 byte ORALSURX 96-97 byte ORALSURG_M18 98-99 byte BRIDGESX 100-101 byte BRIDGES_M18 102-103 byte ORTHDONX 104-105 byte ORTHDONT_M18 106-107 byte DENTPROX 108-109 byte DENTPROC 110-111 str DENTOTHX 112-136 byte FFDVTYPE 137-138 int FFBEF19 139-141 int FFTOT20 142-144 double DVSF19X 145-152 double DVMR19X 153-159 double DVMD19X 160-166 double DVPV19X 167-174 double DVVA19X 175-181 double DVTR19X 182-188 double DVOF19X 189-195 double DVSL19X 196-201 double DVWC19X 202-207 double DVOT19X 208-214 double DVXP19X 215-222 double DVTC19X 223-230 byte IMPFLAG 231-231 double PERWT19F 232-243 int VARSTR 244-247 byte VARPSU 248-248 using H213B.dat; *DEFINE VARIABLE LABELS; label variable DUID "PANEL # + ENCRYPTED DU IDENTIFIER"; 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 DVDATEYR "EVENT DATE - YEAR"; label variable DVDATEMM "EVENT DATE - MONTH"; label variable GENDENT_M18 "GENERAL DENTIST SEEN"; label variable DENTHYG_M18 "DENTAL HYGIENIST SEEN"; label variable DNSPCLST_M18 "DENTAL SPECIALIST SEEN"; label variable DENTYPE_M18 "OTHER DENTAL SPECIALIST SEEN"; label variable PEDDENT_M18 "PEDIATRIC DENTIST SEEN"; label variable EXAMINE_M18 "GENERAL EXAM, CHECKUP OR CONSULTATION"; label variable CLENTETH_M18 "CLEANING, PROPHYLAXIS, POLISHING OR PERIODONTAL RECALL"; label variable JUSTXRAY_M18 "X-RAYS, RADIOGRAPHS OR BITEWINGS"; label variable FLUORIDE_M18 "FLUORIDE TREATMENT"; label variable SEALANT_M18 "SEALANT APPLICATION"; label variable FILLINGX "EDITED FILLING_M18"; label variable FILLING_M18 "FILLINGS, INLAYS, CROWNS OR CAPS"; label variable ROOTCANX "EDITED ROOTCANL_M18"; label variable ROOTCANL_M18 "ROOT CANAL"; label variable GUMSURGX "EDITED GUMSURG_M18"; label variable GUMSURG_M18 "PERIODONTAL SCALING, ROOT PLANING OR GUM SURGERY"; label variable IMPLANTX "EDITED IMPLANT_M18"; label variable IMPLANT_M18 "IMPLANTS"; label variable ORALSURX "EDITED ORALSURG_M18"; label variable ORALSURG_M18 "EXTRACTION, TOOTH PULLED OR OTH ORAL SURGERY"; label variable BRIDGESX "EDITED BRIDGES_M18"; label variable BRIDGES_M18 "FIXED OR RELINING/REPAIR OF BRIDGES/DENTURES, REMOVABLE DENTURES"; label variable ORTHDONX "EDITED ORTHDONT_M18"; label variable ORTHDONT_M18 "ORTHODONTIA, BRACES OR RETAINERS"; label variable DENTPROX "EDITED DENTPROC"; label variable DENTPROC "OTHER DENTAL PROCEDURES"; label variable DENTOTHX "OTHER SPECIFY DENTAL PROCEDURES EDITED"; label variable FFDVTYPE "FLAT FEE BUNDLE"; label variable FFBEF19 "TOTAL # OF VISITS IN FF BEFORE 2019"; label variable FFTOT20 "TOTAL # OF VISITS IN FF AFTER 2019"; label variable DVSF19X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable DVMR19X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable DVMD19X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable DVPV19X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable DVVA19X "AMOUNT PAID, VETERANS/CHAMPVA(IMPUTED)"; label variable DVTR19X "AMOUNT PAID, TRICARE(IMPUTED)"; label variable DVOF19X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable DVSL19X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable DVWC19X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable DVOT19X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable DVXP19X "SUM OF DVSF19X-DVOT19X (IMPUTED)"; label variable DVTC19X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT19F "EXPENDITURE FILE PERSON WEIGHT, 2019"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2019"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2019"; *DEFINE VALUE LABELS FOR REPORTS; label define H213B0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" ; label define H213B0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 2019 "2019" ; label define H213B0011X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H213B0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0013X -1 "-1 INAPPLICABLE" -15 "-15 CANNOT BE COMPUTED" -7 "-7 REFUSED" -8 "-8 DK" 0 "0" ; label define H213B0014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 FLAT FEE STEM" 2 "2 FLAT FEE LEAF" ; label define H213B0015X -1 "-1 INAPPLICABLE" -15 "-15 CANNOT BE COMPUTED" -7 "-7 REFUSED" -8 "-8 DK" 0 "0" ; label define H213B0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0021X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0022X 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 H213B0023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0024X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0026X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0028X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0029X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0030X 23 "PANEL 23" 24 "PANEL 24" ; label define H213B0031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0032X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H213B0034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value BRIDGESX H213B0001X; label value BRIDGES_M18 H213B0002X; label value CLENTETH_M18 H213B0003X; label value DENTHYG_M18 H213B0004X; label value DENTPROC H213B0005X; label value DENTPROX H213B0006X; label value DENTYPE_M18 H213B0007X; label value DNSPCLST_M18 H213B0008X; label value DVDATEMM H213B0009X; label value DVDATEYR H213B0010X; label value EVENTRN H213B0011X; label value EXAMINE_M18 H213B0012X; label value FFBEF19 H213B0013X; label value FFDVTYPE H213B0014X; label value FFTOT20 H213B0015X; label value FILLINGX H213B0016X; label value FILLING_M18 H213B0017X; label value FLUORIDE_M18 H213B0018X; label value GENDENT_M18 H213B0019X; label value GUMSURGX H213B0020X; label value GUMSURG_M18 H213B0021X; label value IMPFLAG H213B0022X; label value IMPLANTX H213B0023X; label value IMPLANT_M18 H213B0024X; label value JUSTXRAY_M18 H213B0025X; label value ORALSURG_M18 H213B0026X; label value ORALSURX H213B0027X; label value ORTHDONT_M18 H213B0028X; label value ORTHDONX H213B0029X; label value PANEL H213B0030X; label value PEDDENT_M18 H213B0031X; label value ROOTCANL_M18 H213B0032X; label value ROOTCANX H213B0033X; label value SEALANT_M18 H213B0034X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H213B, replace; #delimit cr * data file is stored in H213B.dta * log file is stored in H213B.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 H213B.LOG and a data file named H213B.DTA. If these files (H213B.DTA and H213B.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. ************************************************************************************************/