/************************************************************************************************/ /* Stata User File for H110B 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 */ /* (H110B.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 H110B.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\H110B.DO */ /* The program below will output the Stata dataset H110B.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H110B.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 int DVDATEYR 44-47 byte DVDATEMM 48-49 byte DVDATEDD 50-51 byte GENDENT 52-53 byte DENTHYG 54-55 byte DENTTECH 56-57 byte DENTSURG 58-59 byte ORTHODNT 60-61 byte ENDODENT 62-63 byte PERIODNT 64-65 byte DENTYPE 66-67 byte EXAMINE 68-69 byte CLENTETH 70-71 byte JUSTXRAY 72-73 byte FLUORIDE 74-75 byte SEALANT 76-77 byte FILLINGX 78-79 byte FILLING 80-81 byte INLAY 82-83 byte CROWNSX 84-85 byte CROWNS 86-87 byte ROOTCANX 88-89 byte ROOTCANL 90-91 byte GUMSURGX 92-93 byte GUMSURG 94-95 byte RECLVIS 96-97 byte EXTRACT 98-99 byte IMPLANTX 100-101 byte IMPLANT 102-103 byte ABSCESS 104-105 byte ORALSURX 106-107 byte ORALSURG 108-109 byte BRIDGESX 110-111 byte BRIDGES 112-113 byte DENTUREX 114-115 byte DENTURES 116-117 byte REPAIR 118-119 byte ORTHDONX 120-121 byte ORTHDONT 122-123 byte WHITENX 124-125 byte WHITEN 126-127 byte TMDTMJ 128-129 byte DENTPROX 130-131 byte DENTPROC 132-133 str DENTOTHX 134-158 str DENTOTHR 159-183 byte DENTMED 184-185 byte FFDVTYPE 186-187 byte FFBEF07 188-189 byte FFTOT08 190-191 double DVSF07X 192-199 double DVMR07X 200-206 double DVMD07X 207-213 double DVPV07X 214-220 double DVVA07X 221-227 double DVTR07X 228-234 double DVOF07X 235-240 double DVSL07X 241-247 double DVWC07X 248-253 double DVOR07X 254-260 double DVOU07X 261-266 double DVOT07X 267-273 double DVXP07X 274-281 double DVTC07X 282-289 byte IMPFLAG 290-290 double PERWT07F 291-302 int VARSTR 303-306 byte VARPSU 307-307 using H110B.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 DVDATEYR "EVENT DATE - YEAR"; label variable DVDATEMM "EVENT DATE - MONTH"; label variable DVDATEDD "EVENT DATE - DAY"; label variable GENDENT "GENERAL DENTIST SEEN"; label variable DENTHYG "DENTAL HYGIENIST SEEN"; label variable DENTTECH "DENTAL TECHNICIAN SEEN"; label variable DENTSURG "DENTAL SURGEON SEEN"; label variable ORTHODNT "ORTHODONTIST SEEN"; label variable ENDODENT "ENDODONTIST SEEN"; label variable PERIODNT "PERIODONTIST SEEN"; label variable DENTYPE "OTHER DENTAL SPECIALIST SEEN"; label variable EXAMINE "GENERAL EXAM OR CONSULTATION"; label variable CLENTETH "CLEANING, PROPHYLAXIS, OR POLISHING"; label variable JUSTXRAY "X-RAYS, RADIOGRAPHS OR BITEWINGS"; label variable FLUORIDE "FLUORIDE TREATMENT"; label variable SEALANT "SEALANT APPLICATION"; label variable FILLINGX "EDITED FILLING"; label variable FILLING "FILLINGS"; label variable INLAY "INLAYS"; label variable CROWNSX "EDITED CROWNS"; label variable CROWNS "CROWNS OR CAPS"; label variable ROOTCANX "EDITED ROOTCANL"; label variable ROOTCANL "ROOT CANAL"; label variable GUMSURGX "EDITED GUMSURG"; label variable GUMSURG "PERIODONTAL SCALING, ROOT PLANING OR GUM"; label variable RECLVIS "PERIODONTAL RECALL VISIT"; label variable EXTRACT "EXTRACTION, TOOTH PULLED"; label variable IMPLANTX "EDITED IMPLANT"; label variable IMPLANT "IMPLANTS"; label variable ABSCESS "ABSCESS OR INFECTION TREATMENT"; label variable ORALSURX "EDITED ORALSURG"; label variable ORALSURG "ORAL SURGERY"; label variable BRIDGESX "EDITED BRIDGES"; label variable BRIDGES "BRIDGES"; label variable DENTUREX "EDITED DENTURES"; label variable DENTURES "DENTURES OR PARTIAL DENTURES"; label variable REPAIR "REPAIR OF BRIDGES/DENTURES OR RELINING"; label variable ORTHDONX "EDITED ORTHDONT"; label variable ORTHDONT "ORTHODONTIA, BRACES OR RETAINERS"; label variable WHITENX "EDITED WHITEN"; label variable WHITEN "BONDING, WHITENING, OR BLEACHING"; label variable TMDTMJ "TREATMENT FOR TMD OR TMJ"; label variable DENTPROX "EDITED DENTPROC"; label variable DENTPROC "OTHER DENTAL PROCEDURES"; label variable DENTOTHX "EDITED DENTOTHR"; label variable DENTOTHR "OTHER SPECIFIED DENTAL PROCEDURES"; label variable DENTMED "RECEIVED MEDICINE INCLUDING FREE SAMPLE"; label variable FFDVTYPE "FLAT FEE BUNDLE"; label variable FFBEF07 "TOTAL # OF VISITS IN FF BEFORE 2007"; label variable FFTOT08 "TOTAL # OF VISITS IN FF AFTER 2007"; label variable DVSF07X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable DVMR07X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable DVMD07X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable DVPV07X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable DVVA07X "AMOUNT PAID, VETERANS (IMPUTED)"; label variable DVTR07X "AMOUNT PAID, TRICARE/CHAMPVA (IMPUTED)"; label variable DVOF07X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable DVSL07X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable DVWC07X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable DVOR07X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable DVOU07X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable DVOT07X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable DVXP07X "SUM OF DVSF07X-DVOT07X (IMPUTED)"; label variable DVTC07X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT07F "EXPENDITURE FILE PERSON WEIGHT, 2007"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2007"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2007"; *DEFINE VALUE LABELS FOR REPORTS; label define H110B0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H110B0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H110B0018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2007 "2007" ; label define H110B0019X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0020X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0021X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0022X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0023X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0024X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0025X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0026X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0027X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0028X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0029X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0030X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0031X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0032X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0034X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H110B0035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0038X -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 H110B0039X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H110B0040X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0046X 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 H110B0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0056X 11 "PANEL 11" 12 "PANEL 12" ; label define H110B0057X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0058X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0059X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0060X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0061X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0062X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0063X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0064X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H110B0065X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value ABSCESS H110B0001X; label value BRIDGES H110B0002X; label value BRIDGESX H110B0003X; label value CLENTETH H110B0004X; label value CROWNS H110B0005X; label value CROWNSX H110B0006X; label value DENTHYG H110B0007X; label value DENTMED H110B0008X; label value DENTPROC H110B0009X; label value DENTPROX H110B0010X; label value DENTSURG H110B0011X; label value DENTTECH H110B0012X; label value DENTURES H110B0013X; label value DENTUREX H110B0014X; label value DENTYPE H110B0015X; label value DVDATEDD H110B0016X; label value DVDATEMM H110B0017X; label value DVDATEYR H110B0018X; label value DVMD07X H110B0019X; label value DVMR07X H110B0020X; label value DVOF07X H110B0021X; label value DVOR07X H110B0022X; label value DVOT07X H110B0023X; label value DVOU07X H110B0024X; label value DVPV07X H110B0025X; label value DVSF07X H110B0026X; label value DVSL07X H110B0027X; label value DVTC07X H110B0028X; label value DVTR07X H110B0029X; label value DVVA07X H110B0030X; label value DVWC07X H110B0031X; label value DVXP07X H110B0032X; label value ENDODENT H110B0033X; label value EVENTRN H110B0034X; label value EXAMINE H110B0035X; label value EXTRACT H110B0036X; label value FFBEF07 H110B0037X; label value FFDVTYPE H110B0038X; label value FFTOT08 H110B0039X; label value FILLING H110B0040X; label value FILLINGX H110B0041X; label value FLUORIDE H110B0042X; label value GENDENT H110B0043X; label value GUMSURG H110B0044X; label value GUMSURGX H110B0045X; label value IMPFLAG H110B0046X; label value IMPLANT H110B0047X; label value IMPLANTX H110B0048X; label value INLAY H110B0049X; label value JUSTXRAY H110B0050X; label value ORALSURG H110B0051X; label value ORALSURX H110B0052X; label value ORTHDONT H110B0053X; label value ORTHDONX H110B0054X; label value ORTHODNT H110B0055X; label value PANEL H110B0056X; label value PERIODNT H110B0057X; label value RECLVIS H110B0058X; label value REPAIR H110B0059X; label value ROOTCANL H110B0060X; label value ROOTCANX H110B0061X; label value SEALANT H110B0062X; label value TMDTMJ H110B0063X; label value WHITEN H110B0064X; label value WHITENX H110B0065X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H110B, replace; #delimit cr * data file is stored in H110B.dta * log file is stored in H110B.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 H110B.LOG and a data file named H110B.DTA. If these files (H110B.DTA and H110B.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. ************************************************************************************************/