/************************************************************************************************/
/* Stata User File for H112 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 */
/* (H112.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 H112.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\H112.DO */
/* The program below will output the Stata dataset H112.DTA */
/************************************************************************************************/
#delimit ;
cd C:\MEPS\DATA;
log using H112.log, replace;
clear;
* INPUT ALL VARIABLES;
infix
str DUID 1-5
int PID 6-8
str DUPERSID 9-16
int CONDN 17-19
str CONDIDX 20-31
byte PANEL 32-33
byte CONDRN 34-34
byte PRIOLIST 35-35
byte CONDBEGD 36-37
byte CONDBEGM 38-39
int CONDBEGY 40-43
byte SEEDREV3 44-45
byte SEEDREV4 46-47
byte SEEDREV5 48-49
byte STILTR3 50-51
byte STILTR4 52-53
byte STILTR5 54-55
byte OVRALL3 56-57
byte OVRALL4 58-59
byte OVRALL5 60-61
byte FURTCA3 62-63
byte FURTCA4 64-65
byte FURTCA5 66-67
byte FOLOCA3 68-69
byte FOLOCA4 70-71
byte FOLOCA5 72-73
byte SEEDREF3 74-75
byte SEEDREF4 76-77
byte SEEDREF5 78-79
byte AGEDIAG 80-81
byte REMISSN 82-83
byte CRND1 84-85
byte CRND2 86-87
byte CRND3 88-88
byte CRND4 89-90
byte CRND5 91-92
byte PRIORFLG 93-93
byte INJURY 94-95
byte ACCDENTD 96-97
byte ACCDENTM 98-99
int ACCDENTY 100-103
byte ACCDNJAN 104-105
byte ACCDNWRK 106-107
byte ACDNTLOC 108-109
byte INOUTHH 110-111
byte VEHICLE 112-113
byte WEAPON 114-115
byte POISON 116-117
byte FIREBURN 118-119
byte DROWN 120-121
byte SPORTS 122-123
byte FALL 124-125
byte ACDNTOTH 126-127
byte RECOVER 128-129
byte INJURFLG 130-130
byte MISSWORK 131-132
byte MISSSCHL 133-134
byte INBEDFLG 135-136
str ICD9CODX 137-139
str ICD9PROX 140-141
str CCCODEX 142-144
byte HHNUM 145-146
byte IPNUM 147-147
int OPNUM 148-150
int OBNUM 151-153
byte ERNUM 154-155
byte RXNUM 156-157
double PERWT07F 158-169
int VARSTR 170-173
byte VARPSU 174-174
using H112.dat;
*DEFINE VARIABLE LABELS;
label variable DUID "DWELLING UNIT ID";
label variable PID "PERSON NUMBER";
label variable DUPERSID "PERSON ID (DUID + PID)";
label variable CONDN "CONDITION NUMBER";
label variable CONDIDX "CONDITION ID";
label variable PANEL "PANEL NUMBER";
label variable CONDRN "CONDITION ROUND NUMBER";
label variable PRIOLIST "IS CONDITION ON PRIORITY LIST";
label variable CONDBEGD "DATE CONDITION STARTED -- DAY";
label variable CONDBEGM "DATE CONDITION STARTED -- MONTH";
label variable CONDBEGY "DATE CONDITION STARTED -- YEAR";
label variable SEEDREV3 "RD3: EVER SEEN DR FOR COND";
label variable SEEDREV4 "RD4: EVER SEEN DR FOR COND";
label variable SEEDREV5 "RD5: EVER SEEN DR FOR COND";
label variable STILTR3 "RD3: IS PERS STILL TREATED FOR COND";
label variable STILTR4 "RD4: IS PERS STILL TREATED FOR COND";
label variable STILTR5 "RD5: IS PERS STILL TREATED FOR COND";
label variable OVRALL3 "RD3: HOW COND AFFECT OVERALL HEALTH";
label variable OVRALL4 "RD4: HOW COND AFFECT OVERALL HEALTH";
label variable OVRALL5 "RD5: HOW COND AFFECT OVERALL HEALTH";
label variable FURTCA3 "RD3: FURTHER TREATMENT RECOMMENDED";
label variable FURTCA4 "RD4: FURTHER TREATMENT RECOMMENDED";
label variable FURTCA5 "RD5: FURTHER TREATMENT RECOMMENDED";
label variable FOLOCA3 "RD3: RCV FOLLOWUP CARE FOR CONDITION";
label variable FOLOCA4 "RD4: RCV FOLLOWUP CARE FOR CONDITION";
label variable FOLOCA5 "RD5: RCV FOLLOWUP CARE FOR CONDITION";
label variable SEEDREF3 "RD3: SAW DR IN REFERENCE PERIOD";
label variable SEEDREF4 "RD4: SAW DR IN REFERENCE PERIOD";
label variable SEEDREF5 "RD5: SAW DR IN REFERENCE PERIOD";
label variable AGEDIAG "AGE WHEN DIAGNOSED";
label variable REMISSN "IS CANCER IN REMISSION/UNDER CONTROL";
label variable CRND1 "HAS CONDITION INFORMATION IN ROUND";
label variable CRND2 "HAS CONDITION INFORMATION IN ROUND";
label variable CRND3 "HAS CONDITION INFORMATION IN ROUND";
label variable CRND4 "HAS CONDITION INFORMATION IN ROUND";
label variable CRND5 "HAS CONDITION INFORMATION IN ROUND";
label variable PRIORFLG "LOCATION OF RND SPECIFIC PRIORITY INFO";
label variable INJURY "WAS CONDITION DUE TO ACCIDENT/INJURY";
label variable ACCDENTD "DATE OF ACCIDENT -- DAY";
label variable ACCDENTM "DATE OF ACCIDENT -- MONTH";
label variable ACCDENTY "DATE OF ACCIDENT -- YEAR";
label variable ACCDNJAN "ACCIDENT/INJURY OCCUR BEFORE/AFTER JAN 1";
label variable ACCDNWRK "DID ACCIDENT OCCUR AT WORK";
label variable ACDNTLOC "WHERE DID ACCIDENT HAPPEN";
label variable INOUTHH "WAS ACCIDENT INSIDE/OUTSIDE THE HOUSE";
label variable VEHICLE "WAS A MOTOR VEHICLE INVOLVED";
label variable WEAPON "WAS SOME OTHER WEAPON INVOLVED";
label variable POISON "WAS POISON/POISONOUS SUBSTANCE INVOLVED";
label variable FIREBURN "WAS FIRE/BURNING INVOLVED";
label variable DROWN "WAS DROWNING/NEAR-DROWNING INVOLVED";
label variable SPORTS "WAS IT A SPORTS INJURY";
label variable FALL "WAS IT A FALL";
label variable ACDNTOTH "WAS SOMETHING ELSE INVOLVED";
label variable RECOVER "FULLY RECOVERED FROM CONDITION";
label variable INJURFLG "LOCATION OF RND SPECIFIC INJURY INFO";
label variable MISSWORK "FLAG ASSOCIATED WITH MISSED WORK DAYS";
label variable MISSSCHL "FLAG ASSOCIATED WITH MISSED SCHOOL DAYS";
label variable INBEDFLG "FLAG ASSOCIATED WITH BED DAYS";
label variable ICD9CODX "ICD-9-CM CODE FOR CONDITION - EDITED";
label variable ICD9PROX "ICD-9-CM CODE FOR PROCEDURE - EDITED";
label variable CCCODEX "CLINICAL CLASSIFICATION CODE - EDITED";
label variable HHNUM "# HOME HEALTH EVENTS ASSOC. W/ CONDITION";
label variable IPNUM "# INPATIENT EVENTS ASSOC. W/ CONDITION";
label variable OPNUM "# OUTPATIENT EVENTS ASSOC. W/ CONDITION";
label variable OBNUM "# OFFICE-BASED EVENTS ASSOC W/ CONDITION";
label variable ERNUM "# ER EVENTS ASSOC. W/ CONDITION";
label variable RXNUM "# PRESCRIBED MEDICINES ASSOC. W/ COND.";
label variable PERWT07F "EXPENDITURE FILE PERSON WEIGHT, 2007";
label variable VARSTR "VARIANCE ESTIMATION STRATUM, 2007";
label variable VARPSU "VARIANCE ESTIMATION PSU, 2007";
*DEFINE VALUE LABELS FOR REPORTS;
label define H1120001X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED" ;
label define H1120002X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED" ;
label define H1120003X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
2005 "2005"
2006 "2006"
2007 "2007"
2008 "2008" ;
label define H1120004X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 BEFORE"
2 "2 AFTER" ;
label define H1120005X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO"
3 "3 DOES NOT WORK" ;
label define H1120006X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 AT HOME (OWN OR SOMEONE ELSE)"
2 "2 ON PUBLIC ST/RD/HWAY/SIDEWLK"
3 "3 ON FARM (OWN OR SOMEONE ELSE)"
4 "4 SCHOOL (IN BLD/ON GRND/FIELD)"
5 "5 STORE OR RESTAURANT (INCL MALL)"
6 "6 OFFICE (ANY PART OF BLD)"
7 "7 FACTORY, INDUSTRY SITE"
8 "8 MILITARY FACILITY"
9 "9 RECREATIONAL PLACE OR FACIL"
91 "91 OTHER" ;
label define H1120007X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120008X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED" ;
label define H1120009X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED" ;
label define H1120010X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED" ;
label define H1120011X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
2005 "2005"
2006 "2006"
2007 "2007"
2008 "2008" ;
label define H1120012X
1 "1 ROUND 1"
2 "2 ROUND 2"
3 "3 ROUND 3"
4 "4 ROUND 4"
5 "5 ROUND 5" ;
label define H1120013X
-1 "-1 INAPPLICABLE"
0 "0 NO"
1 "1 YES" ;
label define H1120014X
-1 "-1 INAPPLICABLE"
0 "0 NO"
1 "1 YES" ;
label define H1120015X
-1 "-1 INAPPLICABLE"
0 "0 NO"
1 "1 YES" ;
label define H1120016X
-1 "-1 INAPPLICABLE"
0 "0 NO"
1 "1 YES" ;
label define H1120017X
-1 "-1 INAPPLICABLE"
0 "0 NO"
1 "1 YES" ;
label define H1120018X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120019X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120020X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120021X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 ALL FOLLOWUP CARE RECEIVED"
2 "2 SOME FOLLOWUP CARE RECEIVED"
3 "3 NO FOLLOWUP CARE RECEIVED"
4 "4 STILL BEING TREATED" ;
label define H1120022X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 ALL FOLLOWUP CARE RECEIVED"
2 "2 SOME FOLLOWUP CARE RECEIVED"
3 "3 NO FOLLOWUP CARE RECEIVED"
4 "4 STILL BEING TREATED" ;
label define H1120023X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 ALL FOLLOWUP CARE RECEIVED"
2 "2 SOME FOLLOWUP CARE RECEIVED"
3 "3 NO FOLLOWUP CARE RECEIVED"
4 "4 STILL BEING TREATED" ;
label define H1120024X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120025X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120026X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120027X
-9 "-9 NOT ASCERTAINED"
0 "0 NO"
1 "1 YES" ;
label define H1120028X
0 "0 NOT AN INJURY CONDITION"
1 "1 ADD. INJURY INFO ON 2006 COND. FILE"
2 "2 ALL INJURY INFO ON 2007 COND. FILE" ;
label define H1120029X
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120030X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 INSIDE"
2 "2 OUTSIDE" ;
label define H1120031X
-9 "-9 NOT ASCERTAINED"
0 "0 NO"
1 "1 YES" ;
label define H1120032X
-9 "-9 NOT ASCERTAINED"
0 "0 NO"
1 "1 YES" ;
label define H1120033X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 VERY SERIOUS"
2 "2 SOMEWHAT SERIOUS"
3 "3 NOT VERY SERIOUS"
4 "4 NOT AT ALL" ;
label define H1120034X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 VERY SERIOUS"
2 "2 SOMEWHAT SERIOUS"
3 "3 NOT VERY SERIOUS"
4 "4 NOT AT ALL" ;
label define H1120035X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 VERY SERIOUS"
2 "2 SOMEWHAT SERIOUS"
3 "3 NOT VERY SERIOUS"
4 "4 NOT AT ALL" ;
label define H1120036X
11 "11 PANEL 11"
12 "12 PANEL 12" ;
label define H1120037X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120038X
1 "1 YES"
2 "2 NO" ;
label define H1120039X
0 "0 NOT A PRIORITY CONDITION"
1 "1 ADD. PRIORITY INFO ON 2006 COND. FILE"
2 "2 ALL PRIORITY INFO ON 2007 COND. FILE" ;
label define H1120040X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 FULLY RECOVERED"
2 "2 STILL HAVE IT"
3 "3 COND IS PERSIST/PERMNT" ;
label define H1120041X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120042X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120043X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120044X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120045X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120046X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120047X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120048X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120049X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120050X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120051X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120052X
-1 "-1 INAPPLICABLE"
-7 "-7 REFUSED"
-8 "-8 DK"
-9 "-9 NOT ASCERTAINED"
1 "1 YES"
2 "2 NO" ;
label define H1120053X
-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 ACCDENTD H1120001X;
label value ACCDENTM H1120002X;
label value ACCDENTY H1120003X;
label value ACCDNJAN H1120004X;
label value ACCDNWRK H1120005X;
label value ACDNTLOC H1120006X;
label value ACDNTOTH H1120007X;
label value AGEDIAG H1120008X;
label value CONDBEGD H1120009X;
label value CONDBEGM H1120010X;
label value CONDBEGY H1120011X;
label value CONDRN H1120012X;
label value CRND1 H1120013X;
label value CRND2 H1120014X;
label value CRND3 H1120015X;
label value CRND4 H1120016X;
label value CRND5 H1120017X;
label value DROWN H1120018X;
label value FALL H1120019X;
label value FIREBURN H1120020X;
label value FOLOCA3 H1120021X;
label value FOLOCA4 H1120022X;
label value FOLOCA5 H1120023X;
label value FURTCA3 H1120024X;
label value FURTCA4 H1120025X;
label value FURTCA5 H1120026X;
label value INBEDFLG H1120027X;
label value INJURFLG H1120028X;
label value INJURY H1120029X;
label value INOUTHH H1120030X;
label value MISSSCHL H1120031X;
label value MISSWORK H1120032X;
label value OVRALL3 H1120033X;
label value OVRALL4 H1120034X;
label value OVRALL5 H1120035X;
label value PANEL H1120036X;
label value POISON H1120037X;
label value PRIOLIST H1120038X;
label value PRIORFLG H1120039X;
label value RECOVER H1120040X;
label value REMISSN H1120041X;
label value SEEDREF3 H1120042X;
label value SEEDREF4 H1120043X;
label value SEEDREF5 H1120044X;
label value SEEDREV3 H1120045X;
label value SEEDREV4 H1120046X;
label value SEEDREV5 H1120047X;
label value SPORTS H1120048X;
label value STILTR3 H1120049X;
label value STILTR4 H1120050X;
label value STILTR5 H1120051X;
label value VEHICLE H1120052X;
label value WEAPON H1120053X;
*DISPLAY A DESCRIPTION OF STATA FILE;
describe;
*LIST FIRST 20 OBSERVATIONS IN THE FILE;
list in 1/20;
save H112, replace;
#delimit cr
* data file is stored in H112.dta
* log file is stored in H112.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 H112.LOG and a data file named H112.DTA. If these files (H112.DTA and H112.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.
************************************************************************************************/