/************************************************************************************************/ /* Stata User File for H239B 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 */ /* (H239B.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 H239B.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\H239B.DO */ /* The program below will output the Stata dataset H239B.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H239B.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 EXAMINEX 70-71 byte CLENTETX 72-73 byte JUSTXRYX 74-75 byte FLUORIDX 76-77 byte SEALANTX 78-79 byte FILLINGX 80-81 byte ROOTCANX 82-83 byte GUMSURGX 84-85 byte IMPLANTX 86-87 byte ORALSURX 88-89 byte BRIDGESX 90-91 byte ORTHDONX 92-93 byte DENTPROX 94-95 str DENTOTHX 96-120 byte FFDVTYPE 121-122 int FFBEF22 123-125 int FFTOT23 126-128 double DVSF22X 129-136 double DVMR22X 137-144 double DVMD22X 145-151 double DVPV22X 152-159 double DVVA22X 160-166 double DVTR22X 167-173 double DVOF22X 174-180 double DVSL22X 181-187 double DVWC22X 188-193 double DVOT22X 194-200 double DVXP22X 201-208 double DVTC22X 209-216 byte IMPFLAG 217-217 double PERWT22F 218-230 int VARSTR 231-234 byte VARPSU 235-235 using H239B.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 EXAMINEX "GENERAL EXAM, CHECKUP OR CONSULTATION - EDITED"; label variable CLENTETX "CLEANING, PROPHYLAXIS, POLISHING OR PERIODONTAL RECALL - EDITED"; label variable JUSTXRYX "X-RAYS, RADIOGRAPHS OR BITEWINGS - EDITED"; label variable FLUORIDX "FLUORIDE TREATMENT - EDITED"; label variable SEALANTX "SEALANT APPLICATION - EDITED"; label variable FILLINGX "FILLINGS, INLAYS, CROWNS OR CAPS - EDITED"; label variable ROOTCANX "ROOT CANAL - EDITED"; label variable GUMSURGX "PERIODONTAL SCALING, ROOT PLANING OR GUM SURGERY - EDITED"; label variable IMPLANTX "IMPLANTS - EDITED"; label variable ORALSURX "EXTRACTION, TOOTH PULLED OR OTH ORAL SURGERY - EDITED"; label variable BRIDGESX "FIXED OR RELINING/REPAIR OF BRIDGES/DENTURES, REMOVABLE DENTURES - EDITED"; label variable ORTHDONX "ORTHODONTIA, BRACES OR RETAINERS - EDITED"; label variable DENTPROX "OTHER DENTAL PROCEDURES - EDITED"; label variable DENTOTHX "OTHER SPECIFY DENTAL PROCEDURES - EDITED"; label variable FFDVTYPE "FLAT FEE BUNDLE"; label variable FFBEF22 "TOTAL # OF VISITS IN FF BEFORE 2022"; label variable FFTOT23 "TOTAL # OF VISITS IN FF AFTER 2022"; label variable DVSF22X "AMOUNT PAID, FAMILY (IMPUTED)"; label variable DVMR22X "AMOUNT PAID, MEDICARE (IMPUTED)"; label variable DVMD22X "AMOUNT PAID, MEDICAID (IMPUTED)"; label variable DVPV22X "AMOUNT PAID, PRIVATE INSURANCE (IMPUTED)"; label variable DVVA22X "AMOUNT PAID, VETERANS/CHAMPVA (IMPUTED)"; label variable DVTR22X "AMOUNT PAID, TRICARE (IMPUTED)"; label variable DVOF22X "AMOUNT PAID, OTHER FEDERAL (IMPUTED)"; label variable DVSL22X "AMOUNT PAID, STATE & LOCAL GOV (IMPUTED)"; label variable DVWC22X "AMOUNT PAID, WORKERS COMP (IMPUTED)"; label variable DVOT22X "AMOUNT PAID, OTHER INSURANCE (IMPUTED)"; label variable DVXP22X "SUM OF DVSF22X - DVOT22X (IMPUTED)"; label variable DVTC22X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPFLAG "IMPUTATION STATUS"; label variable PERWT22F "EXPENDITURE FILE PERSON WEIGHT, 2022"; label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2022"; label variable VARPSU "VARIANCE ESTIMATION PSU, 2022"; *DEFINE VALUE LABELS FOR REPORTS; label define H239B0001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" ; label define H239B0008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 2022 "2022" ; label define H239B0009X 1 "1 ROUND 1" 2 "2 ROUND 2" 3 "3 ROUND 3" 4 "4 ROUND 4" 5 "5 ROUND 5" 6 "6 ROUND 6" 7 "7 ROUND 7" 8 "8 ROUND 8" 9 "9 ROUND 9" ; label define H239B0010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0011X -1 "-1 INAPPLICABLE" -15 "-15 CANNOT BE COMPUTED" -7 "-7 REFUSED" -8 "-8 DK" 0 "0" ; label define H239B0012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 FLAT FEE STEM" 2 "2 FLAT FEE LEAF" ; label define H239B0013X -1 "-1 INAPPLICABLE" -15 "-15 CANNOT BE COMPUTED" -7 "-7 REFUSED" -8 "-8 DK" 0 "0" ; label define H239B0014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0018X 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 H239B0019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0021X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0023X 24 "24 PANEL 24" 26 "26 PANEL 26" 27 "27 PANEL 27" ; label define H239B0024X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; label define H239B0026X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" 1 "1 YES" 2 "2 NO" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value BRIDGESX H239B0001X; label value CLENTETX H239B0002X; label value DENTHYG_M18 H239B0003X; label value DENTPROX H239B0004X; label value DENTYPE_M18 H239B0005X; label value DNSPCLST_M18 H239B0006X; label value DVDATEMM H239B0007X; label value DVDATEYR H239B0008X; label value EVENTRN H239B0009X; label value EXAMINEX H239B0010X; label value FFBEF22 H239B0011X; label value FFDVTYPE H239B0012X; label value FFTOT23 H239B0013X; label value FILLINGX H239B0014X; label value FLUORIDX H239B0015X; label value GENDENT_M18 H239B0016X; label value GUMSURGX H239B0017X; label value IMPFLAG H239B0018X; label value IMPLANTX H239B0019X; label value JUSTXRYX H239B0020X; label value ORALSURX H239B0021X; label value ORTHDONX H239B0022X; label value PANEL H239B0023X; label value PEDDENT_M18 H239B0024X; label value ROOTCANX H239B0025X; label value SEALANTX H239B0026X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H239B, replace; #delimit cr * data file is stored in H239B.dta * log file is stored in H239B.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 H239B.LOG and a data file named H239B.DTA. If these files (H239B.DTA and H239B.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. ************************************************************************************************/