/************************************************************************************************/ /* Stata User File for H26B 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 */ /* (H26B.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 H26B.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\H26B.DO */ /* The program below will output the Stata dataset H26B.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H26BF1.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 RECLVISX 96-97 byte RECLVIS 98-99 byte EXTRACT 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 WHITEN 124-125 byte TMDTMJ 126-127 byte DENTPROX 128-129 byte DENTPROC 130-131 str DENTOTHX 132-156 str DENTOTHR 157-181 byte DENTINJ 182-183 byte DENTMED 184-185 byte FFDVTYPE 186-187 byte FFBEF98 188-189 byte FFTOT99 190-191 double DVSF98X 192-198 double DVMR98X 199-204 double DVMD98X 205-211 double DVPV98X 212-218 double DVVA98X 219-225 double DVCH98X 226-231 double DVOF98X 232-238 double DVSL98X 239-245 double DVWC98X 246-251 double DVOR98X 252-258 double DVOU98X 259-265 double DVOT98X 266-272 double DVXP98X 273-279 double DVTC98X 280-286 double WTDPER98 287-298 int VARSTR98 299-301 byte VARPSU98 302-303 using H26BF1.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 RECLVISX "EDITED RECLVIS"; label variable RECLVIS "PERIODONTAL RECALL VISIT"; label variable EXTRACT "EXTRACTION, TOOTH PULLED"; label variable IMPLANT "IMPLANTS"; label variable ABSCESS "ABCESS 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 "RECEIVE MEDICINE INCLUDING FREE SAMPLE"; label variable FFDVTYPE "FLAT FEE BUNDLE"; label variable FFBEF98 "TOTAL # OF VISITS IN FF BEFORE 1998"; label variable FFTOT99 "TOTAL # OF VISITS IN FF AFTER 1998"; label variable DVSF98X "AMOUNT PAID,FAMILY (IMPUTED)"; label variable DVMR98X "AMOUNT PAID,MEDICARE (IMPUTED)"; label variable DVMD98X "AMOUNT PAID,MEDICAID (IMPUTED)"; label variable DVPV98X "AMOUNT PAID,PRIVATE INSURANCE (IMPUTED)"; label variable DVVA98X "AMOUNT PAID,VETERANS (IMPUTED)"; label variable DVCH98X "AMOUNT PAID,CHAMPUS/CHAMPVA (IMPUTED)"; label variable DVOF98X "AMOUNT PAID,OTHER FEDERAL (IMPUTED)"; label variable DVSL98X "AMOUNT PAID,STATE & LOCAL GOV (IMPUTED)"; label variable DVWC98X "AMOUNT PAID,WORKERS COMP (IMPUTED)"; label variable DVOR98X "AMOUNT PAID, OTHER PRIVATE (IMPUTED)"; label variable DVOU98X "AMOUNT PAID, OTHER PUBLIC (IMPUTED)"; label variable DVOT98X "AMOUNT PAID,OTHER INSURANCE (IMPUTED)"; label variable DVXP98X "SUM OF DVSF98X-DVOT98X (IMPUTED)"; label variable DVTC98X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable WTDPER98 "POVERTY/MORTALITY/NH ADJ PERS LVL WGT 98"; label variable VARSTR98 "VARIANCE ESTIMATION STRATUM,1998"; label variable VARPSU98 "VARIANCE ESTIMATION PSU,1998"; *DEFINE VALUE LABELS FOR REPORTS; label define H26BF10001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10018X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H26BF10020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H26BF10021X -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1998 "1998" ; label define H26BF10022X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10023X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10024X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10025X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10026X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10027X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10028X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10029X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10030X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10031X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10032X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10033X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10034X -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H26BF10035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10036X 1 "1" 2 "2" 3 "3" 4 "4" 5 "5" ; label define H26BF10037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10039X -1 "-1 INAPPLICABLE" -8 "-8 DK" 0 "0" ; label define H26BF10040X -1 "-1 INAPPLICABLE" 1 "1 FLAT FEE STEM" 2 "2 FLAT FEE LEAF" ; label define H26BF10041X -1 "-1 INAPPLICABLE" -8 "-8 DK" 0 "0" ; label define H26BF10042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10047X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10048X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10049X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10050X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10051X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10052X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10053X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10054X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10055X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10056X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10057X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10058X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10059X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10060X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10061X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10062X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10063X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" ; label define H26BF10064X -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 H26BF10001X; label value BRIDGES H26BF10002X; label value BRIDGESX H26BF10003X; label value CLENTETH H26BF10004X; label value CLENTETX H26BF10005X; label value CROWNS H26BF10006X; label value CROWNSX H26BF10007X; label value DENTHYG H26BF10008X; label value DENTINJ H26BF10009X; label value DENTMED H26BF10010X; label value DENTPROC H26BF10011X; label value DENTPROX H26BF10012X; label value DENTSURG H26BF10013X; label value DENTTECH H26BF10014X; label value DENTURES H26BF10015X; label value DENTUREX H26BF10016X; label value DENTYPE H26BF10017X; label value DVCH98X H26BF10018X; label value DVDATEDD H26BF10019X; label value DVDATEMM H26BF10020X; label value DVDATEYR H26BF10021X; label value DVMD98X H26BF10022X; label value DVMR98X H26BF10023X; label value DVOF98X H26BF10024X; label value DVOR98X H26BF10025X; label value DVOT98X H26BF10026X; label value DVOU98X H26BF10027X; label value DVPV98X H26BF10028X; label value DVSF98X H26BF10029X; label value DVSL98X H26BF10030X; label value DVTC98X H26BF10031X; label value DVVA98X H26BF10032X; label value DVWC98X H26BF10033X; label value DVXP98X H26BF10034X; label value ENDODENT H26BF10035X; label value EVENTRN H26BF10036X; label value EXAMINE H26BF10037X; label value EXTRACT H26BF10038X; label value FFBEF98 H26BF10039X; label value FFDVTYPE H26BF10040X; label value FFTOT99 H26BF10041X; label value FILLING H26BF10042X; label value FILLINGX H26BF10043X; label value FLUORIDE H26BF10044X; label value GENDENT H26BF10045X; label value GUMSURG H26BF10046X; label value GUMSURGX H26BF10047X; label value IMPLANT H26BF10048X; label value INLAY H26BF10049X; label value JUSTXRAY H26BF10050X; label value ORALSURG H26BF10051X; label value ORALSURX H26BF10052X; label value ORTHDONT H26BF10053X; label value ORTHDONX H26BF10054X; label value ORTHODNT H26BF10055X; label value PERIODNT H26BF10056X; label value RECLVIS H26BF10057X; label value RECLVISX H26BF10058X; label value REPAIR H26BF10059X; label value ROOTCANL H26BF10060X; label value ROOTCANX H26BF10061X; label value SEALANT H26BF10062X; label value TMDTMJ H26BF10063X; label value WHITEN H26BF10064X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H26BF1, replace; #delimit cr * data file is stored in H26BF1.dta * log file is stored in H26BF1.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 H26B.LOG and a data file named H26B.DTA. If these files (H26B.DTA and H26B.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. ************************************************************************************************/