/************************************************************************************************/ /* Stata User File for HC10CF1 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 */ /* (HC10CF1.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 HC10CF1.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\HC10CF1.DO */ /* The program below will output the Stata dataset HC10CF1.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using HC10CF1.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 FFID11X 30-40 byte OMTYPE1X 41-42 byte OMTYPE1 43-44 str OMOTHOX 45-69 str OMOTHOS 70-94 byte FFOMTYPX 95-96 byte FFOM96 97-98 byte FFTOT96 99-100 byte FFBEF96 101-102 byte FFOM97 103-104 byte FFTOT97 105-106 double OMSF96X 107-113 double OMMR96X 114-120 double OMMD96X 121-128 double OMPV96X 129-136 double OMVA96X 137-144 double OMCH96X 145-150 double OMOF96X 151-158 double OMSL96X 159-165 double OMWC96X 166-171 double OMOR96X 172-178 double OMOU96X 179-184 double OMOT96X 185-190 double OMXP96X 191-198 double OMTC96X 199-206 byte IMPOMSLF 207-207 byte IMPOMMCR 208-208 byte IMPOMMCD 209-209 byte IMPOMPRV 210-210 byte IMPOMVA 211-211 byte IMPOMCHM 212-212 byte IMPOMOFD 213-213 byte IMPOMSTL 214-214 byte IMPOMWCP 215-215 byte IMPOMOPR 216-216 byte IMPOMOPU 217-217 byte IMPOMOTH 218-218 byte IMPOMCHG 219-219 double WTDPER96 220-231 byte VARPSU96 232-233 int VARSTR96 234-236 using HC10CF1.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 FFID11X "FLAT FEE ID"; label variable OMTYPE1X "OTHER MEDICAL EXPENSE TYPE - EDITED"; label variable OMTYPE1 "OTHER MEDICAL EXPENSE TYPE"; label variable OMOTHOX "OMTYPE OTHER SPECIFY, EDITED"; label variable OMOTHOS "OMTYPE OTHER SPECIFY"; label variable FFOMTYPX "ED FLAT FEE STEM-LEAF INDICATOR"; label variable FFOM96 "TOTAL #OM EVENTS IN FF - 1996"; label variable FFTOT96 "#VISITS IN FLAT FEE (ALL EVENTS) - 1996"; label variable FFBEF96 "#VISITS IN FF (ALL EVENTS) BEFORE 1996"; label variable FFOM97 "#OM EVENTS IN FLAT FEE: RD3, 1997"; label variable FFTOT97 "#VISITS IN FF (ALL EVENTS) -1997 THRU R3"; label variable OMSF96X "AMOUNT PAID,FAMILY (IMPUTED)"; label variable OMMR96X "AMOUNT PAID,MEDICARE(IMPUTED)"; label variable OMMD96X "AMOUNT PAID,MEDICAID (IMPUTED)"; label variable OMPV96X "AMOUNT PAID,PRIVATE INSURANCE (IMPUTED)"; label variable OMVA96X "AMOUNT PAID,VETERANS(IMPUTED)"; label variable OMCH96X "AMOUNT PAID,CHAMPUS/CHAMPVA (IMPUTED)"; label variable OMOF96X "AMOUNT PAID,OTHER FEDERAL (IMPUTED)"; label variable OMSL96X "AMOUNT PAID,STATE & LOCAL GOV (IMPUTED)"; label variable OMWC96X "AMOUNT PAID,WORKERS COMP (IMPUTED)"; label variable OMOR96X "AMOUNT PAID,OTHER PRIVATE (IMPUTED)"; label variable OMOU96X "AMOUNT PAID,OTHER PUBLIC (IMPUTED)"; label variable OMOT96X "AMOUNT PAID,OTHER INSURANCE (IMPUTED)"; label variable OMXP96X "SUM OF OMSF96X-OMOT96X (IMPUTED)"; label variable OMTC96X "HHLD REPORTED TOTAL CHARGE (IMPUTED)"; label variable IMPOMSLF "IMPUTATION FLAG FOR OMSF96X"; label variable IMPOMMCR "IMPUTATION FLAG FOR OMMR96X"; label variable IMPOMMCD "IMPUTATION FLAG FOR OMMD96X"; label variable IMPOMPRV "IMPUTATION FLAG FOR OMPV96X"; label variable IMPOMVA "IMPUTATION FLAG FOR OMVA96X"; label variable IMPOMCHM "IMPUTATION FLAG FOR OMCH96X"; label variable IMPOMOFD "IMPUTATION FLAG FOR OMOF96X"; label variable IMPOMSTL "IMPUTATION FLAG FOR OMSL96X"; label variable IMPOMWCP "IMPUTATION FLAG FOR OMWC96X"; label variable IMPOMOPR "IMPUTATION FLAG FOR OMOR96X"; label variable IMPOMOPU "IMPUTATION FLAG FOR OMOU96X"; label variable IMPOMOTH "IMPUTATION FLAG FOR OMOT96X"; label variable IMPOMCHG "IMPUTATION STATUS OF OMTC96X"; label variable WTDPER96 "POVERTY/MORTALITY ADJUSTED PERS LEVL WGT"; label variable VARPSU96 "VARIANCE ESTIMATION PSU 1996"; label variable VARSTR96 "VARIANCE ESTIMATION STRATUM"; *DEFINE VALUE LABELS FOR REPORTS; label define HC10CF10001X 1 "1 ROUND 1" 2 "2 ROUND 2" 3 "3 ROUND 3" ; label define HC10CF10002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO FLAT FEE VISITS PRIOR TO 1996" ; label define HC10CF10003X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0 NO EVENTS IN 1997" 1 "1 NUMBER OF EVENTS" ; label define HC10CF10004X -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 HC10CF10005X -1 "-1 INAPPLICABLE" -9 "-9 NOT ASCERTAINED" 0 "0 NO EVENTS IN 1997" 1 "1 NUMBER OF EVENTS" ; label define HC10CF10006X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10007X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10008X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10009X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10010X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10011X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10012X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10013X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10014X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10015X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10016X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10017X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10018X -1 "-1 INAPPLICABLE" 0 "0 UNIMPUTED" 1 "1 IMPUTED" ; label define HC10CF10019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10021X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10024X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10026X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10028X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10029X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10030X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 GLASSES OR CONTACT LENSES" 10 "10 DISPOSABLE SUPPLIES" 11 "11 ALTERATIONS/MODIFICATIONS" 2 "2 INSULIN" 3 "3 DIABETIC EQUIPMENT/SUPPLIES" 4 "4 AMBULANCE SERVICES" 5 "5 ORTHOPEDIC ITEMS" 6 "6 HEARING DEVICES" 7 "7 PROSTHESIS" 8 "8 BATHROOM AIDS" 9 "9 MEDICAL EQUIPMENT" 91 "91 OTHER" ; label define HC10CF10031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 GLASSES OR CONTACT LENSES" 10 "10 DISPOSABLE SUPPLIES" 11 "11 ALTERATIONS/MODIFICATIONS" 2 "2 INSULIN" 3 "3 DIABETIC EQUIPMENT/SUPPLIES" 4 "4 AMBULANCE SERVICES" 5 "5 ORTHOPEDIC ITEMS" 6 "6 HEARING DEVICES" 7 "7 PROSTHESIS" 8 "8 BATHROOM AIDS" 9 "9 MEDICAL EQUIPMENT" 91 "91 OTHER" ; label define HC10CF10032X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC10CF10034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value EVENTRN HC10CF10001X; label value FFBEF96 HC10CF10002X; label value FFOM97 HC10CF10003X; label value FFOMTYPX HC10CF10004X; label value FFTOT97 HC10CF10005X; label value IMPOMCHG HC10CF10006X; label value IMPOMCHM HC10CF10007X; label value IMPOMMCD HC10CF10008X; label value IMPOMMCR HC10CF10009X; label value IMPOMOFD HC10CF10010X; label value IMPOMOPR HC10CF10011X; label value IMPOMOPU HC10CF10012X; label value IMPOMOTH HC10CF10013X; label value IMPOMPRV HC10CF10014X; label value IMPOMSLF HC10CF10015X; label value IMPOMSTL HC10CF10016X; label value IMPOMVA HC10CF10017X; label value IMPOMWCP HC10CF10018X; label value OMCH96X HC10CF10019X; label value OMMD96X HC10CF10020X; label value OMMR96X HC10CF10021X; label value OMOF96X HC10CF10022X; label value OMOR96X HC10CF10023X; label value OMOT96X HC10CF10024X; label value OMOU96X HC10CF10025X; label value OMPV96X HC10CF10026X; label value OMSF96X HC10CF10027X; label value OMSL96X HC10CF10028X; label value OMTC96X HC10CF10029X; label value OMTYPE1 HC10CF10030X; label value OMTYPE1X HC10CF10031X; label value OMVA96X HC10CF10032X; label value OMWC96X HC10CF10033X; label value OMXP96X HC10CF10034X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save HC10CF1, replace; #delimit cr * data file is stored in HC10CF1.dta * log file is stored in HC10CF1.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 HC10CF1.LOG and a data file named HC10CF1.DTA. If these files (HC10CF1.DTA and HC10CF1.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. ************************************************************************************************/