/************************************************************************************************/ /* Stata User File for H42 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 */ /* (H42.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 H42.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\H42.DO */ /* The program below will output the Stata dataset H42.DTA */ /************************************************************************************************/ #delimit ; cd C:\MEPS\DATA; log using H42F3.log, replace; clear; * INPUT ALL VARIABLES; infix long DUID 1-5 int PID 6-8 str DUPERSID 9-16 str CGVRIDX 17-31 str CGDUPERS 32-39 byte PANELRN 40-40 byte AGE42X 41-42 byte CGCOUNT 43-44 byte GETCARE 45-46 byte CGELIG 47-47 byte RESPNDCR 48-49 byte CGDETELG 50-51 byte RESPNDCG 52-53 str CREATEQ 54-57 byte MEPSCG 58-58 byte MEMHLPX 59-60 byte MEMBMVEX 61-62 byte MOVECARX 63-64 byte MOVEDX 65-66 byte HLPMDTRX 67-68 byte HLPDLACX 69-70 byte HLPPCARX 71-72 byte HLPOTHX 73-74 byte CGVRTIMX 75-76 int CGHRSWX 77-79 byte OLDRCHLX 80-81 byte NUMSISX 82-83 byte NUMBROX 84-85 byte MOTHLVGX 86-87 byte FATHLVGX 88-89 byte OLDRSIBX 90-91 byte PARELSEX 92-93 byte MLLVGX 94-95 byte FLLVGX 96-97 byte NUMGRPRX 98-99 byte CAREAGEX 100-101 byte CGAGERGX 102-103 byte CAREMRDX 104-105 byte CARESEXX 106-107 byte CARESCHX 108-109 byte CARECHLX 110-111 byte CHLDUN6X 112-113 byte CAREHTHX 114-115 byte CARELIVX 116-117 byte WRKFPX 118-119 byte CRMNJBX 120-121 byte WFEWKFPX 122-123 byte CAREASTX 124-125 byte WEEKHLPX 126-127 byte DAYPRWKX 128-129 byte DAYPMOX 130-131 byte HOWLNGHX 132-133 byte HOWLNGMX 134-135 using H42F3.dat; *DEFINE VARIABLE LABELS; label variable DUID "DWELLING UNIT ID"; label variable PID "PERSON NUMBER"; label variable DUPERSID "PERSON ID (DUID + PID)"; label variable CGVRIDX "CG RECORD ID (DUID + RUID + COUNTER)"; label variable CGDUPERS "DUPERSID OF POTENTIAL CAREGIVER IF MEPS"; label variable PANELRN "PANEL/ROUND INDICATOR FOR CG DATA"; label variable AGE42X "AGE-R4/2 (EDITED/IMPUTED)"; label variable CGCOUNT "# POTENTL CAREGVRS ON FILE FOR MEPS PERS"; label variable GETCARE "1 IF POTENTIAL CG IS ACTUAL CG"; label variable CGELIG "1 IF PERSON IS ELIGIBLE FOR CG SUPPL"; label variable RESPNDCR "1 IF PERSON ANSWERED 1ST SEC OF CG SUPP"; label variable CGDETELG "ELIGIBILITY FOR CG DETAIL QUESTIONS"; label variable RESPNDCG "1 IF PERS RESPOND TO CG DETAIL QUESTIONS"; label variable CREATEQ "QUESTION NO. WHERE POTENTIAL CG ADDED"; label variable MEPSCG "STATUS OF POTENTIAL CAREGIVER"; label variable MEMHLPX "ED PERSION RECEIVE HELP FROM RU MEMBER"; label variable MEMBMVEX "ED DID ANYONE MOVE TO ENABLE CARE"; label variable MOVECARX "ED PERSON MOVED TO RECEIVE CARE"; label variable MOVEDX "ED PERSON MOVED TO GIVE CARE"; label variable HLPMDTRX "ED CR14 & CG05 HELP PERS W/ MED TREAMNT"; label variable HLPDLACX "ED CR14 & CG05 HELP PERS W/ DAILY ACTIV"; label variable HLPPCARX "ED CR14 & CG05 HELP PERS W/PERSONAL CARE"; label variable HLPOTHX "ED CR14 & CG05 HELP WITH OTHER ACTIVITY"; label variable CGVRTIMX "ED LENGTH OF TIME PERSON RECEIVED HELP"; label variable CGHRSWX "ED EXTRA HOURS PER WEEK SPENT HELPING"; label variable OLDRCHLX "ED PERSON HAVE CHILDREN >=18 YRS OLD"; label variable NUMSISX "ED PERSON NUMBER OF LIVING SISTERS"; label variable NUMBROX "ED PERSON NUMBER OF LIVING BROTHERS"; label variable MOTHLVGX "ED PERSON MOTHER LIVING"; label variable FATHLVGX "ED PERSON FATHER LIVING"; label variable OLDRSIBX "ED PERSON HAVE BROS/SISTERS >=18 YRS OLD"; label variable PARELSEX "ED PERSON HAVE MOTH/FATH LIVING ELSEWH"; label variable MLLVGX "ED PERSON MOTHER-IN-LAW LIVING"; label variable FLLVGX "ED PERSON FATHER-IN-LAW LIVING"; label variable NUMGRPRX "ED PERSON NUMBER OF LIVING GRANDPARENTS"; label variable CAREAGEX "ED POTENTIAL CG AGE"; label variable CGAGERGX "ED POTENTIAL CG AGE RANGE"; label variable CAREMRDX "ED POTENTIAL CG MARITAL STATUS"; label variable CARESEXX "ED POTENTIAL CG SEX"; label variable CARESCHX "ED POTENTIAL CG EDUCATION"; label variable CARECHLX "ED POTENTIAL CG NUMBER OF CHILDREN"; label variable CHLDUN6X "ED POTENTIAL CG NUMBER OF CHILDREN < 6"; label variable CAREHTHX "ED POTENTIAL CG HEALTH"; label variable CARELIVX "ED POTENTIAL CG DISTANCE FROM PID"; label variable WRKFPX "ED POTENTIAL CG EMPLOYMENT STATUS"; label variable CRMNJBX "ED POTENTIAL CG MAIN JOB/OCCUPATION"; label variable WFEWKFPX "ED POTENTIAL CG WIFE S EMPLOYMENT STATUS"; label variable CAREASTX "ED DID POTENTIAL CG HELP OR ASSIST PERSN"; label variable WEEKHLPX "ED CAREGIVER COME EVERY WEEK/SOME WEEKS"; label variable DAYPRWKX "ED HOW MANY DAYS PER WK CAREGIVER COMES"; label variable DAYPMOX "ED HOW MANY DAYS PER MON CAREGIVER COMES"; label variable HOWLNGHX "ED HOW LONG DID EACH VISIT LAST (HOURS)"; label variable HOWLNGMX "ED HOW LONG DID EACH VISIT LAST (MINS)"; *DEFINE VALUE LABELS FOR REPORTS; label define H42F30001X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H42F30002X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30003X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" ; label define H42F30004X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30005X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 10 MINUTES OR LESS" 2 "2 11-30 MINUTES" 3 "3 31-59 MINUTES" 4 "4 1-2 HOURS" 5 "5 MORE THAN 2 HOURS" ; label define H42F30006X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30007X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 NO FORMAL SCHOOLING" 2 "2 ELEMENTARY SCHOOL (GRADES 1-8)" 3 "3 SOME HIGH SCHOOL (GRADES 9-12)" 4 "4 COMPLETED HIGH SCHOOL, NO COLLEGE" 5 "5 TECHNICAL OR TRADE SCHOOL" 6 "6 SOME COLLEGE" 7 "7 COLLEGE GRADUATE" 8 "8 GRADUATE DEGREE" ; label define H42F30008X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 MALE" 2 "2 FEMALE" ; label define H42F30009X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30010X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30011X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30012X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO" 1 "1 YES" 95 "95" ; label define H42F30013X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 995 "995 LESS THAN 1 HR PER WEEK" ; label define H42F30014X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" 1 "1 A MONTH OR LESS" 2 "2 >1 MONTH, BUT < 1 YEAR" 3 "3 >3 MONTHS, BUT < 1 YEAR" 4 "4 ABOUT A YEAR" 5 "5 MORE THAN A YEAR" ; label define H42F30015X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30016X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 EXEC/ADMIN/MANAGEERIAL OCCUPATIONS" 10 "10 PRODUCTION OCCUPATIONS" 11 "11 TRANSPORTATION/MATERIAL MOVING OCCUP" 12 "12 HANDLER/EQUIP CLEANER/HELPER/LABORERS" 13 "13 MILITARY OCCUPATIONS" 2 "2 PROFESSIONAL SPECIALTY OCCUPATIONS" 3 "3 TECHNICIAN/RELATED SUPPORT OCCUPATIONS" 4 "4 MARKETING/SALES OCCUPATIONS" 5 "5 ADMIN SUPPORT OCCUPATIONS INCL CLERICAL" 6 "6 SERVICE OCCUPATIONS" 7 "7 AGRICULTURE/FORESTRY/FISH/RELATED OCCUP" 8 "8 MECHANICS/INSTALLERS/REPAIRERS" 9 "9 CONSTRUCTION/EXTRACTIVE OCCUPATIONS" 91 "91 OTHER" ; label define H42F30017X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30018X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30019X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30020X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30021X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO" 1 "1 YES" 95 "95" ; label define H42F30022X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30023X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30024X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30025X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30026X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30027X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30028X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30029X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30030X 1 "1 POT CG FR MEPS" 2 "2 POT CG NOT FR MEPS" 3 "3 NO POT CG" ; label define H42F30031X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30032X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30033X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30034X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30035X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30036X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30037X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0" ; label define H42F30038X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30039X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30040X 1 "1 RECORD FROM P1R4" 2 "2 RECORD FROM P2R2" ; label define H42F30041X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95 LIVES WITH BOTH PARENTS" ; label define H42F30042X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO" 1 "1 YES" 95 "95" ; label define H42F30043X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 0 "0 NO" 1 "1 YES" 95 "95" ; label define H42F30044X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 YES" 2 "2 NO" 95 "95" ; label define H42F30045X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FULL-TIME" 2 "2 PART-TIME" 3 "3 NOT AT ALL" ; label define H42F30046X -1 "-1 INAPPLICABLE" -7 "-7 REFUSED" -8 "-8 DK" -9 "-9 NOT ASCERTAINED" 1 "1 FULL-TIME" 2 "2 PART-TIME" 3 "3 NOT AT ALL" ; * ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS; label value CAREAGEX H42F30001X; label value CAREASTX H42F30002X; label value CARECHLX H42F30003X; label value CAREHTHX H42F30004X; label value CARELIVX H42F30005X; label value CAREMRDX H42F30006X; label value CARESCHX H42F30007X; label value CARESEXX H42F30008X; label value CGAGERGX H42F30009X; label value CGCOUNT H42F30010X; label value CGDETELG H42F30011X; label value CGELIG H42F30012X; label value CGHRSWX H42F30013X; label value CGVRTIMX H42F30014X; label value CHLDUN6X H42F30015X; label value CRMNJBX H42F30016X; label value DAYPMOX H42F30017X; label value DAYPRWKX H42F30018X; label value FATHLVGX H42F30019X; label value FLLVGX H42F30020X; label value GETCARE H42F30021X; label value HLPDLACX H42F30022X; label value HLPMDTRX H42F30023X; label value HLPOTHX H42F30024X; label value HLPPCARX H42F30025X; label value HOWLNGHX H42F30026X; label value HOWLNGMX H42F30027X; label value MEMBMVEX H42F30028X; label value MEMHLPX H42F30029X; label value MEPSCG H42F30030X; label value MLLVGX H42F30031X; label value MOTHLVGX H42F30032X; label value MOVECARX H42F30033X; label value MOVEDX H42F30034X; label value NUMBROX H42F30035X; label value NUMGRPRX H42F30036X; label value NUMSISX H42F30037X; label value OLDRCHLX H42F30038X; label value OLDRSIBX H42F30039X; label value PANELRN H42F30040X; label value PARELSEX H42F30041X; label value RESPNDCG H42F30042X; label value RESPNDCR H42F30043X; label value WEEKHLPX H42F30044X; label value WFEWKFPX H42F30045X; label value WRKFPX H42F30046X; *DISPLAY A DESCRIPTION OF STATA FILE; describe; *LIST FIRST 20 OBSERVATIONS IN THE FILE; list in 1/20; save H42F3, replace; #delimit cr * data file is stored in H42F3.dta * log file is stored in H42F3.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 H42.LOG and a data file named H42.DTA. If these files (H42.DTA and H42.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. ************************************************************************************************/