/************************************************************************************************/ /* Stata User File for H85B 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 */ /* (H85B.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 H85B.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\H85B.DO */ /* The program below will output the Stata dataset H85B.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H85B.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 int DVDATEYR 42-45 byte DVDATEMM 46-47 byte DVDATEDD 48-49 byte GENDENT 50-51 byte DENTHYG 52-53 byte DENTTECH 54-55 byte DENTSURG 56-57 byte ORTHODNT 58-59 byte ENDODENT 60-61 byte PERIODNT 62-63 byte DENTYPE 64-65 byte EXAMINE 66-67 byte CLENTETX 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 REPAIRX 118-119 byte REPAIR 120-121 byte ORTHDONX 122-123 byte ORTHDONT 124-125 byte WHITENX 126-127 byte WHITEN 128-129 byte TMDTMJ 130-131 byte DENTPROX 132-133 byte DENTPROC 134-135 str DENTOTHX 136-160 str DENTOTHR 161-185 byte DENTMED 186-187 byte FFDVTYPE 188-189 byte FFBEF04 190-191 byte FFTOT05 192-193 double DVSF04X 194-201 double DVMR04X 202-208 double DVMD04X 209-215 double DVPV04X 216-222 double DVVA04X 223-229 double DVTR04X 230-235 double DVOF04X 236-241 double DVSL04X 242-248 double DVWC04X 249-255 double DVOR04X 256-262 double DVOU04X 263-268 double DVOT04X 269-275 double DVXP04X 276-283 double DVTC04X 284-291 byte IMPFLAG 292-292 double PERWT04F 293-304 int VARSTR 305-307 byte VARPSU 308-308 using H85B.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 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 CLENTETX "EDITED CLENTETH"; 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 REPAIRX "EDITED REPAIR"; 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 FFBEF04 "TOTAL # OF VISITS IN FF BEFORE 2004"; label variable FFTOT05 "TOTAL # OF VISITS IN FF AFTER 2004"; label variable DVSF04X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable DVMR04X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable DVMD04X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable DVPV04X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable DVVA04X "AMOUNT PAID, VETERANS (IMPUTED)"; label variable DVTR04X "AMOUNT PAID, TRICARE (IMPUTED)"; label variable DVOF04X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable DVSL04X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable DVWC04X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable DVOR04X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable DVOU04X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable DVOT04X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable DVXP04X "SUM OF DVSF04X-DVOT04X (IMPUTED)"; label variable DVTC04X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT04F "EXPENDITURE FILE PERSON WEIGHT, 2004"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2004"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2004"; *DEFINE VALUE LABELS FOR REPORTS; label define H85B0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H85B0018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H85B0019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2004 "2004" ; label define H85B0020X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0021X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0022X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0023X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0024X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0025X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0026X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0027X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0028X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0029X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0030X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0031X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0032X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0033X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0035X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H85B0036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0039X -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 H85B0040X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H85B0041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0047X 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 H85B0048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0056X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0057X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0058X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0059X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0060X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0061X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0062X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0063X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0064X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0065X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H85B0066X -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 H85B0001X; label value BRIDGES H85B0002X; label value BRIDGESX H85B0003X; label value CLENTETH H85B0004X; label value CLENTETX H85B0005X; label value CROWNS H85B0006X; label value CROWNSX H85B0007X; label value DENTHYG H85B0008X; label value DENTMED H85B0009X; label value DENTPROC H85B0010X; label value DENTPROX H85B0011X; label value DENTSURG H85B0012X; label value DENTTECH H85B0013X; label value DENTURES H85B0014X; label value DENTUREX H85B0015X; label value DENTYPE H85B0016X; label value DVDATEDD H85B0017X; label value DVDATEMM H85B0018X; label value DVDATEYR H85B0019X; label value DVMD04X H85B0020X; label value DVMR04X H85B0021X; label value DVOF04X H85B0022X; label value DVOR04X H85B0023X; label value DVOT04X H85B0024X; label value DVOU04X H85B0025X; label value DVPV04X H85B0026X; label value DVSF04X H85B0027X; label value DVSL04X H85B0028X; label value DVTC04X H85B0029X; label value DVTR04X H85B0030X; label value DVVA04X H85B0031X; label value DVWC04X H85B0032X; label value DVXP04X H85B0033X; label value ENDODENT H85B0034X; label value EVENTRN H85B0035X; label value EXAMINE H85B0036X; label value EXTRACT H85B0037X; label value FFBEF04 H85B0038X; label value FFDVTYPE H85B0039X; label value FFTOT05 H85B0040X; label value FILLING H85B0041X; label value FILLINGX H85B0042X; label value FLUORIDE H85B0043X; label value GENDENT H85B0044X; label value GUMSURG H85B0045X; label value GUMSURGX H85B0046X; label value IMPFLAG H85B0047X; label value IMPLANT H85B0048X; label value IMPLANTX H85B0049X; label value INLAY H85B0050X; label value JUSTXRAY H85B0051X; label value ORALSURG H85B0052X; label value ORALSURX H85B0053X; label value ORTHDONT H85B0054X; label value ORTHDONX H85B0055X; label value ORTHODNT H85B0056X; label value PERIODNT H85B0057X; label value RECLVIS H85B0058X; label value REPAIR H85B0059X; label value REPAIRX H85B0060X; label value ROOTCANL H85B0061X; label value ROOTCANX H85B0062X; label value SEALANT H85B0063X; label value TMDTMJ H85B0064X; label value WHITEN H85B0065X; label value WHITENX H85B0066X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H85B, replace; #delimit cr * data file is stored in H85B.dta * log file is stored in H85B.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 H85B.LOG and a data file named H85B.DTA. If these files (H85B.DTA and H85B.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. ************************************************************************************************/