/************************************************************************************************/ /* Stata User File for HC16GF2 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 */ /* (HC16GF2.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 HC16GF2.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\HC16GF2.DO */ /* The program below will output the Stata dataset HC16GF2.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using HC16GF2.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-5 int PID 6-8 str DUPERSID 9-16 str EVNTIDX 17-28 str HHSFFIDX 29-38 double OBSF97H 39-46 double OBMR97H 47-53 double OBMD97H 54-59 double OBPV97H 60-67 double OBVA97H 68-72 double OBCH97H 73-80 double OBOF97H 81-86 double OBSL97H 87-93 double OBWC97H 94-100 double OBOT97H 101-107 double OBUC97H 108-114 double OBTC97H 115-122 double OBSF97M 123-129 double OBMR97M 130-136 double OBMD97M 137-143 double OBPV97M 144-150 double OBVA97M 151-155 double OBCH97M 156-161 double OBOF97M 162-167 double OBSL97M 168-173 double OBWC97M 174-180 double OBOT97M 181-187 double OBTC97M 188-195 double WTDPER97 196-207 byte VARPSU97 208-209 int VARSTR97 210-212 using HC16GF2.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 HHSFFIDX "HOUSEHOLD REPORTD FLAT FEE ID(UNEDITED)"; label variable OBSF97H "HHLD RPTD AMT PD, FAMILY (PRE-IMPUTED)"; label variable OBMR97H "HHLD RPTD AMT PD, MEDICARE (PRE-IMPUTED)"; label variable OBMD97H "HHLD RPTD AMT PD, MEDICAID (PRE-IMPUTED)"; label variable OBPV97H "HHLD RPTD AMT PD, PRIV INS (PRE-IMPUTED)"; label variable OBVA97H "HHLD RPTD AMT PD, VETERANS (PRE-IMPUTED)"; label variable OBCH97H "HHLD RPTD AMT PD,CHMP/CHPVA(PRE-IMPUTED)"; label variable OBOF97H "HHLD RPTD AMT PD, OTHER FED(PRE-IMPUTED)"; label variable OBSL97H "HHLD RPTD AMT PD, STATE&LOC(PRE-IMPUTED)"; label variable OBWC97H "HHLD RPTD AMT PD, WORK COMP(PRE-IMPUTED)"; label variable OBOT97H "HHLD RPTD AMT PD, OTH INSUR(PRE-IMPUTED)"; label variable OBUC97H "HHLD RPTD AMT PD,UNCOL LIAB(PRE-IMPUTED)"; label variable OBTC97H "HHLD REPORTED TOTAL CHARGE (PRE-IMPUTED)"; label variable OBSF97M "MPC RPTD AMT PD, FAMILY (UN-IMPUTED)"; label variable OBMR97M "MPC RPTD AMT PD, MEDICARE (UN-IMPUTED)"; label variable OBMD97M "MPC RPTD AMT PD, MEDICAID (UN-IMPUTED)"; label variable OBPV97M "MPC RPTD AMT PD, PRIV INS (UN-IMPUTED)"; label variable OBVA97M "MPC RPTD AMT PD, VETERANS (UN-IMPUTED)"; label variable OBCH97M "MPC RPTD AMT PD, CHMP/CHMPVA(UN-IMPUTED)"; label variable OBOF97M "MPC RPTD AMT PD, OTHER FED (UN-IMPUTED)"; label variable OBSL97M "MPC RPTD AMT PD, STATE&LOC (UN-IMPUTED)"; label variable OBWC97M "MPC RPTD AMT PD, WORK COMP (UN-IMPUTED)"; label variable OBOT97M "MPC RPTD AMT PD, OTH INSUR (UN-IMPUTED)"; label variable OBTC97M "MPC REPORTED TOTAL CHARGE (UN-IMPUTED)"; label variable WTDPER97 "POVERTY/MORTALITY ADJ PERS LEVL WGT,1997"; label variable VARPSU97 "VARIANCE ESTIMATION PSU,1997"; label variable VARSTR97 "VARIANCE ESTIMATION STRATUM,1997"; *DEFINE VALUE LABELS FOR REPORTS; label define HC16GF20001X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20002X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20003X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 100 "$100.00" ; label define HC16GF20004X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20005X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20006X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20007X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 3 "$3.00" ; label define HC16GF20008X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20009X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20010X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20011X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20012X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20013X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20014X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20015X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20016X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20017X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20018X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20019X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20020X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20021X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16GF20022X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 100 "$100.00" ; label define HC16GF20023X -1 "-1 INAPPLICABLE" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value OBCH97H HC16GF20001X; label value OBCH97M HC16GF20002X; label value OBMD97H HC16GF20003X; label value OBMD97M HC16GF20004X; label value OBMR97H HC16GF20005X; label value OBMR97M HC16GF20006X; label value OBOF97H HC16GF20007X; label value OBOF97M HC16GF20008X; label value OBOT97H HC16GF20009X; label value OBOT97M HC16GF20010X; label value OBPV97H HC16GF20011X; label value OBPV97M HC16GF20012X; label value OBSF97H HC16GF20013X; label value OBSF97M HC16GF20014X; label value OBSL97H HC16GF20015X; label value OBSL97M HC16GF20016X; label value OBTC97H HC16GF20017X; label value OBTC97M HC16GF20018X; label value OBUC97H HC16GF20019X; label value OBVA97H HC16GF20020X; label value OBVA97M HC16GF20021X; label value OBWC97H HC16GF20022X; label value OBWC97M HC16GF20023X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save HC16GF2, replace; #delimit cr * data file is stored in HC16GF2.dta * log file is stored in HC16GF2.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 HC16GF2.LOG and a data file named HC16GF2.DTA. If these files (HC16GF2.DTA and HC16GF2.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. ************************************************************************************************/