/************************************************************************************************/ /* Stata User File for HC16DF2 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 */ /* (HC16DF2.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 HC16DF2.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\HC16DF2.DO */ /* The program below will output the Stata dataset HC16DF2.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using HC16DF2.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 IPSF97H 39-46 double IPMR97H 47-54 double IPMD97H 55-59 double IPPV97H 60-68 double IPVA97H 69-73 double IPCH97H 74-80 double IPOF97H 81-87 double IPSL97H 88-94 double IPWC97H 95-102 double IPOT97H 103-110 double IPUC97H 111-118 double IPTC97H 119-127 double IPSF97M 128-134 double IPMR97M 135-142 double IPMD97M 143-150 double IPPV97M 151-159 double IPVA97M 160-164 double IPCH97M 165-172 double IPOF97M 173-180 double IPSL97M 181-187 double IPWC97M 188-195 double IPOT97M 196-202 double IPTC97M 203-211 double WTDPER97 212-223 byte VARPSU97 224-225 int VARSTR97 226-228 using HC16DF2.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "NUMERIC PID"; label variable DUPERSID "PERSON ID (DUID+PID)"; label variable EVNTIDX "EVENT ID"; label variable HHSFFIDX "HOUSEHOLD REPORTD FLAT FEE ID(UNEDITED)"; label variable IPSF97H "HHLD RPTD AMT PD, FAMILY(PRE-IMPUTED)"; label variable IPMR97H "HHLD RPTD AMT PD, MEDICARE(PRE-IMPUTED)"; label variable IPMD97H "HHLD RPTD AMT PD, MEDICAID(PRE-IMPUTED)"; label variable IPPV97H "HHLD RPTD AMT PD, PRIV INS(PRE-IMPUTED)"; label variable IPVA97H "HHLD RPTD AMT PD, VETERANS(PRE-IMPUTED)"; label variable IPCH97H "HHLD RPTD AMT PD, CHMP/CHVA(PRE-IMPUTED)"; label variable IPOF97H "HHLD RPTD AMT PD, OTHER FED(PRE-IMPUTED)"; label variable IPSL97H "HHLD RPTD AMT PD, STATE/LOC(PRE-IMPUTED)"; label variable IPWC97H "HHLD RPTD AMT PD, WORK COMP(PRE-IMPUTED)"; label variable IPOT97H "HHLD RPTD AMT PD, OTH INSUR(PRE-IMPUTED)"; label variable IPUC97H "HHLD RPTD AMT PD,UNCOL LIAB(PRE-IMPUTED)"; label variable IPTC97H "HHLD REPORTED TOTAL CHARGE(PRE-IMPUTED)"; label variable IPSF97M "MPC RPTD AMT PD, FAMILY(UN-IMPUTED)"; label variable IPMR97M "MPC RPTD AMT PD, MEDICARE(UN-IMPUTED)"; label variable IPMD97M "MPC RPTD AMT PD, MEDICAID(UN-IMPUTED)"; label variable IPPV97M "MPC RPTD AMT PD, PRIV INS(UN-IMPUTED)"; label variable IPVA97M "MPC RPTD AMT PD, VETERANS(UN-IMPUTED)"; label variable IPCH97M "MPC RPTD AMT PD, CHMP/CHMPVA(UN-IMPUTED)"; label variable IPOF97M "MPC RPTD AMT PD, OTHER FED(UN-IMPUTED)"; label variable IPSL97M "MPC RPTD AMT PD, STATE & LOC(UN-IMPUTED)"; label variable IPWC97M "MPC RPTD AMT PD, WORK COMPU(UN-IMPUTED)"; label variable IPOT97M "MPC RPTD AMT PD,OTH INSUR(UN-IMPUTED)"; label variable IPTC97M "MPC REPORTED TOTAL CHARGE(UN-IMPUTED)"; label variable WTDPER97 "POVERTY/MORTALITY ADJ PERSON LEVL WGT-97"; label variable VARPSU97 "VARIANCE ESTIMATION PSU, 1997"; label variable VARSTR97 "VARIANCE ESTIMATION STRATUM, 1997"; *DEFINE VALUE LABELS FOR REPORTS; label define HC16DF20001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define HC16DF20002X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20003X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20004X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20005X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20006X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20007X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20008X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 5800 "$5800.00" ; label define HC16DF20009X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20010X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20011X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20012X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20013X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20014X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20015X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20016X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20017X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20018X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20019X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20020X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20021X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20022X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20023X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20024X -1 "-1 INAPPLICABLE" -2 "-2 DETERMINED IN PREVIOUS ROUND" -3 "-3 NO DATA IN ROUND" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define HC16DF20025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value DUID HC16DF20001X; label value IPCH97H HC16DF20002X; label value IPCH97M HC16DF20003X; label value IPMD97H HC16DF20004X; label value IPMD97M HC16DF20005X; label value IPMR97H HC16DF20006X; label value IPMR97M HC16DF20007X; label value IPOF97H HC16DF20008X; label value IPOF97M HC16DF20009X; label value IPOT97H HC16DF20010X; label value IPOT97M HC16DF20011X; label value IPPV97H HC16DF20012X; label value IPPV97M HC16DF20013X; label value IPSF97H HC16DF20014X; label value IPSF97M HC16DF20015X; label value IPSL97H HC16DF20016X; label value IPSL97M HC16DF20017X; label value IPTC97H HC16DF20018X; label value IPTC97M HC16DF20019X; label value IPUC97H HC16DF20020X; label value IPVA97H HC16DF20021X; label value IPVA97M HC16DF20022X; label value IPWC97H HC16DF20023X; label value IPWC97M HC16DF20024X; label value PID HC16DF20025X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save HC16DF2, replace; #delimit cr * data file is stored in HC16DF2.dta * log file is stored in HC16DF2.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 HC16DF2.LOG and a data file named HC16DF2.DTA. If these files (HC16DF2.DTA and HC16DF2.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. ************************************************************************************************/