/************************************************************************************************/
/* Stata User File for HC19 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                 */
/* (HC19.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 HC19.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\HC19.DO                                               */
/* The program below will output the Stata dataset HC19.DTA                                      */
/************************************************************************************************/


#delimit ;
cd C:\MEPS\DATA;
log using HC19.log, replace;
clear;

* INPUT ALL VARIABLES;
infix
  str    JOBSIDX 1-11
  str    DUPERSID 12-19
  long   DUID 20-24
  int    PID 25-27
  byte   RN 28-28
  byte   JOBSN 29-29
  byte   PANEL 30-30
  byte   JOBTYPE 31-32
  byte   JSTRTM 33-34
  byte   JSTRTD 35-36
  int    JSTRTY 37-40
  byte   JSTOPM 41-42
  byte   JSTOPD 43-44
  int    JSTOPY 45-48
  byte   RETIRJOB 49-50
  byte   SUBTYPE 51-52
  byte   MAIN_JOB 53-54
  byte   DIFFWAGE 55-56
  byte   WHY_DIFF 57-58
  byte   WORKSTAT 59-60
  byte   Y_CHANGE 61-62
  byte   STILLWRK 63-64
  byte   OFFTAKEI 65-66
  byte   NOWTAKEI 67-68
  byte   WHY_LEFT 69-70
  int    NUMEMPS 71-73
  int    ESTMATE1 74-76
  byte   MORELOC 77-78
  byte   BUSINC 79-80
  byte   PROPRIET 81-82
  byte   TYPEEMPL 83-84
  byte   YLEFT 85-86
  byte   YNOBUSN 87-88
  byte   RECALL 89-90
  int    HRSPRWK 91-93
  byte   HRS35WK 94-95
  byte   APXHRDAY 96-97
  byte   SICKPAY 98-99
  byte   PAYDRVST 100-101
  byte   PAYVACTN 102-103
  byte   RETIRPLN 104-105
  double WKLYAMT 106-112
  byte   EMPLINS 113-114
  byte   OFFRDINS 115-116
  byte   DIFFPLNS 117-118
  byte   INUNION 119-120
  byte   PROVDINS 121-122
  byte   HHMEMBER 123-124
  byte   NUMFMEMB 125-126
  int    TOTLEMP 127-129
  byte   SALARIED 130-131
  byte   HOWPAID 132-133
  double DAYWAGE 134-139
  byte   HRSPRDY 140-141
  double MAKEAMT 142-150
  byte   PERUNIT 151-152
  byte   MORE10 153-154
  byte   MORE15 155-156
  byte   MOREMINM 157-158
  double OVRTIMHR 159-164
  double GROSSPAY 165-173
  byte   GROSSPER 174-175
  byte   SALRYWKS 176-177
  byte   OTHRTYPE 178-179
  byte   EARNTIPS 180-181
  byte   EARNBONS 182-183
  byte   EARNCOMM 184-185
  double OTHRWAGE 186-191
  byte   TIPSUNIT 192-193
  double TIPSAMT 194-201
  byte   BONSUNIT 202-203
  double BONSAMT 204-212
  byte   COMMUNIT 213-214
  double COMMAMT 215-223
  double HRLYWAGE 224-229
  byte   JBEGHR 230-231
  byte   JENDHR 232-233
  byte   JBEGMIN 234-235
  byte   JENDMIN 236-237
  str    JBEGAMPM 238-239
  str    JENDAMPM 240-241
  byte   SHIFTWK 242-243
  byte   JOBHASHI 244-245
  byte   STILLAT 246-247
  byte   SHFTCHNG 248-249
  int    HRSALBAS 250-252
  byte   INDTCODX 253-254
  byte   OCCPCODX 255-256
using HC19.dat;

*DEFINE VARIABLE LABELS;
label variable JOBSIDX "JOB ID NUMBER";
label variable DUPERSID "SAMPLE PERSON ID (DUID+PID)";
label variable DUID "DWELLING UNIT ID";
label variable PID "PERSON NUMBER";
label variable RN "ROUND";
label variable JOBSN "JOB NUMBER";
label variable PANEL "PANEL";
label variable JOBTYPE "SELF-EMPLOYED OR WORK FOR SOMEONE ELSE";
label variable JSTRTM "JOB START DATE - MONTH";
label variable JSTRTD "JOB START DATE - DAY";
label variable JSTRTY "JOB START DATE - YEAR";
label variable JSTOPM "JOB STOP DATE - MONTH";
label variable JSTOPD "JOB STOP DATE - DAY";
label variable JSTOPY "JOB STOP DATE - YEAR";
label variable RETIRJOB "EM PERSON RETIRED FROM THIS JOB";
label variable SUBTYPE "JOB SUB-TYPE";
label variable MAIN_JOB "RJ01A STILL MAIN JOB OR BUSINESS";
label variable DIFFWAGE "RJ02 ANY CHANGE IN WAGE AMOUNT?";
label variable WHY_DIFF "RJ03 WHY WAGES CHANGED";
label variable WORKSTAT "RJ04 FULL OR PART TIME";
label variable Y_CHANGE "RJ05 WHY CHANGE IN FULL/PART TIME STATUS";
label variable STILLWRK "RJ06 STILL WORK AT ESTAB/MISC JOB";
label variable OFFTAKEI "RJ07 OFFERED INSURANCE AND NOW TAKE";
label variable NOWTAKEI "RJ08 NOW OFFERED AND TAKE INSURANCE";
label variable WHY_LEFT "RJ10 REASON WHY NOT AT JOB NOW";
label variable NUMEMPS "ESTABLISHMENT SIZE-NONSELF-EMP";
label variable ESTMATE1 "CATEGORICAL APPROX. ESTAB SIZE";
label variable MORELOC "EM93 MORE THAN ONE LOCATION";
label variable BUSINC "EM94 BUSINESS INCORPORATED";
label variable PROPRIET "EM95 PROPRIETORSHIP OR PARTNERSHIP";
label variable TYPEEMPL "EM96 EMPLOYEE TYPE";
label variable YLEFT "EM101 NO JOB REASON";
label variable YNOBUSN "EM102 WHY NO BUSINESS?";
label variable RECALL "EM103 RECALL WITHIN 30 DAYS?";
label variable HRSPRWK "EM111/104,EW17 NUMBER OF HOURS PER WEEK";
label variable HRS35WK "EM105 WORK 35 HOURS?";
label variable APXHRDAY "EM106 APPROX # OF HOURS WORKED PER DAY";
label variable SICKPAY "EM107 DOES PERSON HAVE PAID SICK LEAVE";
label variable PAYDRVST "EM108 IS THERE PAID SICK LEAVE FOR DR S";
label variable PAYVACTN "EM109 DOES PERSON GET PAID VACATION";
label variable RETIRPLN "EM110 DOES PERSON HAVE PENSION/RETIREMEN";
label variable WKLYAMT "EM112 USUAL WEEKLY GROSS INCOME";
label variable EMPLINS "EM113 HAVE HEALTH INSURANCE THRU THIS JO";
label variable OFFRDINS "EM114 OFFERED INSURANCE BUT CHOSE NOT TO";
label variable DIFFPLNS "EM115 CHOICE OF DIFFERENT HEALTH INS PLA";
label variable INUNION "EM116 BELONG TO LABOR UNION";
label variable PROVDINS "EM117 WHO PROVIDES HEALTH INSURANCE";
label variable HHMEMBER "EM122 ANY OTHER HH MEMBER WRK AT THIS BU";
label variable NUMFMEMB "EM123 HOW MANY HH MEMBERS WORK THERE";
label variable TOTLEMP "ESTABLISTMENT SIZE-SELF-EMP";
label variable SALARIED "EW01 IS PERSON SALARIED, PAID BY THE HR,";
label variable HOWPAID "EW02 HOW IS PERSON PAID";
label variable DAYWAGE "EW03 PERSON S DAILY WAGE RATE";
label variable HRSPRDY "EW04 # HOURS PERSON WORKED IN ONE DAY";
label variable MAKEAMT "EW05 HOW MUCH MONEY DOES PERSON MAKE";
label variable PERUNIT "EW05 PERIOD FOR WHICH PERSON IS PAID";
label variable MORE10 "PERSON MAKES MORE OR LESS THAN $10/HOUR";
label variable MORE15 "PERSON MAKES MORE OR LESS THAN $15/HOUR";
label variable MOREMINM "PERS MAKES MORE OR LESS THAN MINM WAGE";
label variable OVRTIMHR "EW06 OVERTIME PAY RATE PER HOUR";
label variable GROSSPAY "EW11 PERSONS SALARY BEFORE TAXES (GROSS)";
label variable GROSSPER "EW11 PERIOD GROSS SALARY WAS EARNED";
label variable SALRYWKS "EW12 # WEEKS PER YEAR SALARY BASED ON";
label variable OTHRTYPE "EW19 TYPE OF OVERTIME PAY";
label variable EARNTIPS "EW23 DOES PERSON EARN TIPS";
label variable EARNBONS "EW23 DOES PERSON EARN BONUSES";
label variable EARNCOMM "EW23 DOES PERSON EARN COMMISSION";
label variable OTHRWAGE "EW23 OVERTIME PAY RATE PER HOUR";
label variable TIPSUNIT "EW24A PERIOD TIP EARNINGS ARE BASED ON";
label variable TIPSAMT "EW24A HOW MUCH ARE PERSONS TIPS";
label variable BONSUNIT "EW24B PERIOD WHICH BONUSES ARE BASED ON";
label variable BONSAMT "EW24B HOW MUCH ARE PERSONS BONUSES";
label variable COMMUNIT "EW24C PERIOD WHICH COMMISSIONS ARE BASED";
label variable COMMAMT "EW24C HOW MUCH ARE PERSONS COMMISSIONS";
label variable HRLYWAGE "EW EW07/13/18 HOW MUCH PERSON MAKES/HR";
label variable JBEGHR "EM EM111A/105A JOB BEGIN HOUR OF DAY";
label variable JENDHR "EM EM111A3/105A3 JOB END HOUR OF DAY";
label variable JBEGMIN "EM EM111A1/105A1 JOB BEGIN MINUTES";
label variable JENDMIN "EM EM111A4/105A4 JOB END MINUTES";
label variable JBEGAMPM "EM EM111A2/105A2 JOB BEGIN AM/PM";
label variable JENDAMPM "EM EM111A5/105A5 JOB END AM/PM";
label variable SHIFTWK "EM EM111B/105B WORK ROTATING SHIFTS";
label variable JOBHASHI "DOES PERSON HAVE HEALTH INS AT THIS JOB";
label variable STILLAT "RJ01 STILL WORK AT ESTAB/MAIN JOB";
label variable SHFTCHNG "RJ05A HAS A CHANGE IN SHIFT OCCURED";
label variable HRSALBAS "EW17 HOURS SALARY BASED ON";
label variable INDTCODX "CONDENSED INDUSTRY CODE";
label variable OCCPCODX "CONDENSED OCCUPATION CODE";


*DEFINE VALUE LABELS FOR REPORTS;
label define HC190001X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190002X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190003X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PER HOUR"
         2 "2 PER DAY"
         3 "3 PER WEEK"
         4 "4 PER TWO WKS"
         5 "5 PER MONTH"
         6 "6 PER YEAR"
         91 "91 OTHER" ;

label define HC190004X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190005X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190006X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PER HOUR"
         2 "2 PER DAY"
         3 "3 PER WEEK"
         4 "4 PER TWO WKS"
         5 "5 PER MONTH"
         6 "6 PER YEAR"
         91 "91 OTHER" ;

label define HC190007X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190008X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES, GT ONE"
         2 "2 NO, ONLY ONE" ;

label define HC190009X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190010X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190011X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190012X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190013X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190014X
         -1 "-1 INAPPLICABLE"
         -10 "-10 GT 1,000"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 1-9"
         2 "2 10-25"
         3 "3 26-49"
         4 "4 50-100"
         5 "5 101-500"
         6 "6 501-1,000" ;

label define HC190015X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190016X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PER YEAR"
         2 "2 PER MONTH"
         3 "3 PER TWO WKS"
         4 "4 PER WEEK"
         91 "91 OTHER" ;

label define HC190017X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190018X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 BY THE DAY"
         2 "2 PIECEWORK"
         3 "3 COMMISSION"
         4 "4 BONUS"
         5 "5 BY JOB/MILE"
         91 "91 OTHER" ;

label define HC190019X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190020X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190021X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190022X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190023X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190024X
         -1 "-1 INAPPLICABLE"
         -2 "-2 DET. IN PREV. RD"
         -3 "-3 NO DATA IN RD"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         1 "1 AGRICULTURE, FORESTRY, FISHERIES"
         10 "10 ENTERTAINMENT AND RECREATION"
         11 "11 PROFESSIONAL SERVICES"
         12 "12 PUBLIC ADMINISTRATION"
         13 "13 INDUSTRY UNKNOWN"
         14 "14 ACTIVE MILITARY"
         2 "2 MINING"
         3 "3 CONSTRUCTION"
         4 "4 MANUFACTURING"
         5 "5 TRANSPORTATION, COMMUNICATION AND UTI"
         6 "6 SALES"
         7 "7 FINANCE, INSURANCE, REAL ESTATE"
         8 "8 REPAIR SERVICES"
         9 "9 PERSONAL SERVICES" ;

label define HC190025X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190026X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0"
         95 "95 HOURS VARIED" ;

label define HC190027X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190028X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190029X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190030X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190031X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 SELF-EMPLOYED"
         2 "2 FOR SOMEONE ELSE" ;

label define HC190032X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED" ;

label define HC190033X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED" ;

label define HC190034X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0 STILL AT JOB"
         1924 "1924"
         1925 "1925"
         1996 "1996"
         1997 "1997"
         1998 "1998" ;

label define HC190035X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED" ;

label define HC190036X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED" ;

label define HC190037X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1991 "1991"
         1992 "1992"
         1993 "1993"
         1994 "1994"
         1995 "1995"
         1996 "1996"
         1997 "1997" ;

label define HC190038X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190039X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190040X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 GE $10"
         2 "2 LT $10" ;

label define HC190041X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 GE $15"
         2 "2 LT $15" ;

label define HC190042X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190043X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 GE MINIMUM WAGE"
         2 "2 LT MINIMUM WAGE" ;

label define HC190044X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190045X
         -1 "-1 INAPPLICABLE"
         -10 "-10 # OF EMP > 1000"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190046X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190047X
         -1 "-1 INAPPLICABLE"
         -2 "-2 DET. IN PREV. RD"
         -3 "-3 NO DATA IN RD"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         1 "1 PROFESSIONAL, TECHNICAL, AND KINDRED"
         10 "10 FARM OWNERS AND MANAGERS"
         11 "11 FARM LABORERS AND FOREMEN"
         12 "12 UNKNOWN"
         13 "13 ACTIVE MILITARY"
         14 "14 LAST WORKED PRIOR TO 1984"
         2 "2 MANAGERIAL AND ADMINISTRATIVE"
         3 "3 SALES WORKERS"
         4 "4 CLERICAL AND KINDRED WORKERS"
         5 "5 CRAFTSMAN AND FOREMEN"
         6 "6 OPERATIVES"
         7 "7 TRANSPORT OPERATIVES"
         8 "8 SERVICE WORKERS"
         9 "9 LABORERS, NOT FARMING" ;

label define HC190048X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190049X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190050X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 DOES NOT WORK OVERTIME"
         2 "2 STRAIGHT TIME"
         3 "3 TIME AND A HALF"
         4 "4 COMPTIME"
         5 "5 EXACT AMOUNT"
         91 "91 OTHER" ;

label define HC190051X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190052X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190053X
         1 "1"
         2 "2" ;

label define HC190054X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190055X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190056X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PER HOUR"
         2 "2 PER DAY"
         3 "3 PER WEEK"
         4 "4 PER TWO WKS"
         5 "5 PER MONTH"
         6 "6 PER YEAR"
         91 "91 OTHER" ;

label define HC190057X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190058X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 EMPLOYER"
         2 "2 UNION"
         3 "3 BOTH" ;

label define HC190059X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190060X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190061X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190062X
         1 "1"
         2 "2"
         3 "3"
         4 "4"
         5 "5" ;

label define HC190063X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 SALARIED"
         2 "2 PAID BY HOUR"
         3 "3 OTHER" ;

label define HC190064X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190065X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190066X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190067X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190068X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190069X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 YES"
         2 "2 NO" ;

label define HC190070X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 CUR MAIN JOB"
         2 "2 CUR MISC JOB IN REF PD"
         3 "3 FMR MAIN JOB IN REF PD"
         4 "4 FMR MISC JOB IN REF PD"
         5 "5 LAST JOB OUTSD REF PD"
         6 "6 RETIREMENT JOB" ;

label define HC190071X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190072X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PER HOUR"
         2 "2 PER DAY"
         3 "3 PER WEEK"
         4 "4 PER TWO WKS"
         5 "5 PER MONTH"
         6 "6 PER YEAR"
         91 "91 OTHER" ;

label define HC190073X
         -1 "-1 INAPPLICABLE"
         -10 "-10 # OF EMP > 1000"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         0 "0" ;

label define HC190074X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PRIVATE"
         2 "2 FEDERAL"
         3 "3 STATE"
         4 "4 LOCAL"
         5 "5 ARMED FORCES"
         6 "6 FOREIGN NON US GOV" ;

label define HC190075X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PROMOTION OR DEMOTION"
         2 "2 CHANGE IN RESP"
         3 "3 PAY RAISE/DECREASE"
         4 "4 ANUL COST OF LIVING INCR"
         5 "5 NEW CONTRACT"
         6 "6 CHANGE IN # HRS WRKD"
         7 "7 CHANGE IN SHIFT TIME"
         8 "8 RECEIVED EDU DEGREE"
         9 "9 TOOK SPECIAL CLASSES"
         91 "91 OTHER" ;

label define HC190076X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 JOB ENDED"
         10 "10 QUIT TO TAKE OTHER JOB"
         11 "11 UNPAID LEAVE"
         2 "2 BUSINESS DISOLVED OR SOLD"
         3 "3 RETIRED"
         4 "4 ILLNESS OR INJURY"
         5 "5 LAID OFF"
         6 "6 QUIT TO HAVE A BABY"
         7 "7 QUIT TO GO TO SCHOOL"
         8 "8 QUIT TO TAKE CARE OF HOME/FAM"
         9 "9 QUIT BECAUSE WANTED TIME OFF"
         91 "91 OTHER" ;

label define HC190077X
         -1 "-1 INAPPLICABLE"
         -10 "-10 HOURLY WAGE >= $67.00"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASCERTAINED"
         0 "0" ;

label define HC190078X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 GE 35 HRS"
         2 "2 LT 35 HRS" ;

label define HC190079X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 JOB ENDED"
         2 "2 RETIRED"
         3 "3 ILLNESS OR INJURY"
         4 "4 LAID OFF"
         5 "5 HAVE BABY"
         6 "6 SCHOOL"
         7 "7 HOME CARE"
         8 "8 TIME OFF"
         9 "9 OTHER JOB"
         91 "91 OTHER REASON" ;

label define HC190080X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 BUSINESS SOLD"
         2 "2 RETIRED"
         3 "3 ILLNESS/INJURY"
         4 "4 HAVE BABY"
         5 "5 SCHOOL"
         6 "6 HOME CARE"
         7 "7 TIME OFF"
         8 "8 OTHER JOB"
         91 "91 OTHER REASON" ;

label define HC190081X
         -1 "-1 INAPPLICABLE"
         -7 "-7 REFUSED"
         -8 "-8 DK"
         -9 "-9 NOT ASERTAINED"
         1 "1 PROMOTION OR DEMOTION"
         10 "10 CHANGE IN HOME/FAM SITUATION"
         11 "11 NEED TIME OFF/WANT WRK MORE"
         2 "2 CHANGE IN RESPONSIBILITIES"
         3 "3 CHANGE IN AMT OF WRK BUS BRINGS"
         4 "4 CHANGE IN SHIFT TIME"
         5 "5 CHANGE IN # OF EMPLOYEE AVAIL"
         6 "6 ILLNESS/DISABILITY"
         7 "7 TEMPORARY LEAVE"
         8 "8 MATERNITY/PATERNITY LEAVE"
         9 "9 GOING TO SCHL/FINISHED SCHL"
         91 "91 OTHER" ;

* ASSOCIATE VARIABLES WITH VALUE LABEL DEFINITIONS;
label value APXHRDAY HC190001X;
label value BONSAMT HC190002X;
label value BONSUNIT HC190003X;
label value BUSINC HC190004X;
label value COMMAMT HC190005X;
label value COMMUNIT HC190006X;
label value DAYWAGE HC190007X;
label value DIFFPLNS HC190008X;
label value DIFFWAGE HC190009X;
label value EARNBONS HC190010X;
label value EARNCOMM HC190011X;
label value EARNTIPS HC190012X;
label value EMPLINS HC190013X;
label value ESTMATE1 HC190014X;
label value GROSSPAY HC190015X;
label value GROSSPER HC190016X;
label value HHMEMBER HC190017X;
label value HOWPAID HC190018X;
label value HRLYWAGE HC190019X;
label value HRS35WK HC190020X;
label value HRSALBAS HC190021X;
label value HRSPRDY HC190022X;
label value HRSPRWK HC190023X;
label value INDTCODX HC190024X;
label value INUNION HC190025X;
label value JBEGHR HC190026X;
label value JBEGMIN HC190027X;
label value JENDHR HC190028X;
label value JENDMIN HC190029X;
label value JOBHASHI HC190030X;
label value JOBTYPE HC190031X;
label value JSTOPD HC190032X;
label value JSTOPM HC190033X;
label value JSTOPY HC190034X;
label value JSTRTD HC190035X;
label value JSTRTM HC190036X;
label value JSTRTY HC190037X;
label value MAIN_JOB HC190038X;
label value MAKEAMT HC190039X;
label value MORE10 HC190040X;
label value MORE15 HC190041X;
label value MORELOC HC190042X;
label value MOREMINM HC190043X;
label value NOWTAKEI HC190044X;
label value NUMEMPS HC190045X;
label value NUMFMEMB HC190046X;
label value OCCPCODX HC190047X;
label value OFFRDINS HC190048X;
label value OFFTAKEI HC190049X;
label value OTHRTYPE HC190050X;
label value OTHRWAGE HC190051X;
label value OVRTIMHR HC190052X;
label value PANEL HC190053X;
label value PAYDRVST HC190054X;
label value PAYVACTN HC190055X;
label value PERUNIT HC190056X;
label value PROPRIET HC190057X;
label value PROVDINS HC190058X;
label value RECALL HC190059X;
label value RETIRJOB HC190060X;
label value RETIRPLN HC190061X;
label value RN HC190062X;
label value SALARIED HC190063X;
label value SALRYWKS HC190064X;
label value SHFTCHNG HC190065X;
label value SHIFTWK HC190066X;
label value SICKPAY HC190067X;
label value STILLAT HC190068X;
label value STILLWRK HC190069X;
label value SUBTYPE HC190070X;
label value TIPSAMT HC190071X;
label value TIPSUNIT HC190072X;
label value TOTLEMP HC190073X;
label value TYPEEMPL HC190074X;
label value WHY_DIFF HC190075X;
label value WHY_LEFT HC190076X;
label value WKLYAMT HC190077X;
label value WORKSTAT HC190078X;
label value YLEFT HC190079X;
label value YNOBUSN HC190080X;
label value Y_CHANGE HC190081X;

*DISPLAY A DESCRIPTION OF STATA FILE;
describe;

*LIST FIRST 20 OBSERVATIONS IN THE FILE;
list in 1/20;

save HC19, replace;

#delimit cr

* data file is stored in HC19.dta
* log  file is stored in HC19.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 HC19.LOG and a data file named HC19.DTA.  If these files (HC19.DTA and HC19.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.          
                                                                                                 
************************************************************************************************/