/************************************************************************************************/ /* Stata User File for H51B 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 */ /* (H51B.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 H51B.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\H51B.DO */ /* The program below will output the Stata dataset H51B.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H51B.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 IMPLANT 100-101 byte ABSCESS 102-103 byte ORALSURX 104-105 byte ORALSURG 106-107 byte BRIDGESX 108-109 byte BRIDGES 110-111 byte DENTUREX 112-113 byte DENTURES 114-115 byte REPAIR 116-117 byte ORTHDONX 118-119 byte ORTHDONT 120-121 byte WHITEN 122-123 byte TMDTMJ 124-125 byte DENTPROX 126-127 byte DENTPROC 128-129 str DENTOTHX 130-154 str DENTOTHR 155-179 byte DENTINJ 180-181 byte DENTMED 182-183 byte FFDVTYPE 184-185 byte FFBEF00 186-187 byte FFTOT01 188-189 double DVSF00X 190-196 double DVMR00X 197-203 double DVMD00X 204-210 double DVPV00X 211-217 double DVVA00X 218-224 double DVTR00X 225-231 double DVOF00X 232-238 double DVSL00X 239-245 double DVWC00X 246-251 double DVOR00X 252-258 double DVOU00X 259-265 double DVOT00X 266-272 double DVXP00X 273-280 double DVTC00X 281-288 byte IMPFLAG 289-289 double PERWT00F 290-301 byte VARSTR00 302-303 byte VARPSU00 304-305 using H51B.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 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 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 DENTINJ "VISIT BECAUSE OF ACCIDENT OR INJURY"; label variable DENTMED "RECEIVED MEDICINE INCLUDING FREE SAMPLE"; label variable FFDVTYPE "FLAT FEE BUNDLE"; label variable FFBEF00 "TOTAL # OF VISITS IN FF BEFORE 2000"; label variable FFTOT01 "TOTAL # OF VISITS IN FF AFTER 2000"; label variable DVSF00X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable DVMR00X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable DVMD00X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable DVPV00X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable DVVA00X "AMOUNT PAID, VETERANS (IMPUTED)"; label variable DVTR00X "AMOUNT PAID, TRICARE (IMPUTED)"; label variable DVOF00X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable DVSL00X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable DVWC00X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable DVOR00X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable DVOU00X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable DVOT00X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable DVXP00X "SUM OF DVSF00X-DVOT00X (IMPUTED)"; label variable DVTC00X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT00F "FINAL PERSON LEVEL WEIGHT, 2000"; label variable VARSTR00 "VARIANCE ESTIMATION STRATUM, 2000"; label variable VARPSU00 "VARIANCE ESTIMATION PSU, 2000"; *DEFINE VALUE LABELS FOR REPORTS; label define H51B0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H51B0019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H51B0020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 2000 "2000" ; label define H51B0021X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0022X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0023X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0024X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0025X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0026X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0027X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0028X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0029X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0030X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0031X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0032X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0033X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0034X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0036X 1 "ROUND 1" 2 "ROUND 2" 3 "ROUND 3" 4 "ROUND 4" 5 "ROUND 5" ; label define H51B0037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0039X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0040X -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 H51B0041X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H51B0042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0048X 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 H51B0049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0056X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0057X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0058X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0059X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0060X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0061X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0062X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0063X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H51B0064X -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 H51B0001X; label value BRIDGES H51B0002X; label value BRIDGESX H51B0003X; label value CLENTETH H51B0004X; label value CLENTETX H51B0005X; label value CROWNS H51B0006X; label value CROWNSX H51B0007X; label value DENTHYG H51B0008X; label value DENTINJ H51B0009X; label value DENTMED H51B0010X; label value DENTPROC H51B0011X; label value DENTPROX H51B0012X; label value DENTSURG H51B0013X; label value DENTTECH H51B0014X; label value DENTURES H51B0015X; label value DENTUREX H51B0016X; label value DENTYPE H51B0017X; label value DVDATEDD H51B0018X; label value DVDATEMM H51B0019X; label value DVDATEYR H51B0020X; label value DVMD00X H51B0021X; label value DVMR00X H51B0022X; label value DVOF00X H51B0023X; label value DVOR00X H51B0024X; label value DVOT00X H51B0025X; label value DVOU00X H51B0026X; label value DVPV00X H51B0027X; label value DVSF00X H51B0028X; label value DVSL00X H51B0029X; label value DVTC00X H51B0030X; label value DVTR00X H51B0031X; label value DVVA00X H51B0032X; label value DVWC00X H51B0033X; label value DVXP00X H51B0034X; label value ENDODENT H51B0035X; label value EVENTRN H51B0036X; label value EXAMINE H51B0037X; label value EXTRACT H51B0038X; label value FFBEF00 H51B0039X; label value FFDVTYPE H51B0040X; label value FFTOT01 H51B0041X; label value FILLING H51B0042X; label value FILLINGX H51B0043X; label value FLUORIDE H51B0044X; label value GENDENT H51B0045X; label value GUMSURG H51B0046X; label value GUMSURGX H51B0047X; label value IMPFLAG H51B0048X; label value IMPLANT H51B0049X; label value INLAY H51B0050X; label value JUSTXRAY H51B0051X; label value ORALSURG H51B0052X; label value ORALSURX H51B0053X; label value ORTHDONT H51B0054X; label value ORTHDONX H51B0055X; label value ORTHODNT H51B0056X; label value PERIODNT H51B0057X; label value RECLVIS H51B0058X; label value REPAIR H51B0059X; label value ROOTCANL H51B0060X; label value ROOTCANX H51B0061X; label value SEALANT H51B0062X; label value TMDTMJ H51B0063X; label value WHITEN H51B0064X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H51B, replace; #delimit cr * data file is stored in H51B.dta * log file is stored in H51B.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 H51B.LOG and a data file named H51B.DTA. If these files (H51B.DTA and H51B.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. ************************************************************************************************/