*** Medicaid Under-reporting in the Current Population Survey and *** One Approach for a Partial Correction *** State Health Access Data Assistance Center, 612-624-4802, 15 Oct. 2007 *** Combine 2005 and 2006 CPS use "P:\CPS Stata files\cpsmar06.dta", clear append using "P:\CPS Stata files\cpsmar05.dta" save "C:\CPS\cps05_06.dta" **** Generate CPS weights gen geocode=. replace geocode=gtcbsa if gtcbsa>0 replace geocode = (gestfips*100000) if geocode==. svyset [w=marsupwt], psu (h_seq) strata (geocode) ** Health insurance recode ** first designate which model individuals are in ** In model2 if state medicaid (or imputed or edited to medicaid), else in model1 gen model2 = . replace model2 = 1 if caid == 1 | othstyp1-othstyp6==2 | ahityp1-ahityp6== 2 replace model2 = 0 if model2 == . gen model1 = . replace model1 = 1 if model2 == 0 replace model1 = 0 if model2 == 1 gen caidplus = model2 label var caidplus "caid and othstyp and ahityp" ************************************************* ***** INSURANCE STATUS VARIABLES ************************************************* gen insurance = . replace insurance = 1 if mcaid == 2 & mcare == 2 & cov_hi == 2 & champ == 2 replace insurance = 2 if (mcare == 1 | (mcaid == 1 & caidplus == 0)) & (cov_hi == 2 & champ == 2) replace insurance = 3 if (cov_hi == 1 | champ == 1) & (mcaid == 2 & mcare == 2) replace insurance = 4 if caidplus == 1 & (champ == 2 & cov_hi == 2 & insurance != 2) replace insurance = 5 if insurance == . label define insurance 1 "uninsured" 2 "public_nocaid" 3 "private_only" 4 "medicaid_only" 5 "public_private" label values insurance insurance tab insurance, gen(ins) rename ins1 uninsured rename ins2 public_nocaid rename ins3 private_only rename ins4 medicaid_only rename ins5 public_private *************************************************************** /* DUMMY VARIABLE FOR MEDICAID IMPUTATION STATUS THE VARIABLE "i-caid" IMPUTATION FLAG HAS THREE VALUES: 0 - NO 1 - ALLOCATED 2 - LOGICAL IMPUTED */ *************************************************************** tab i_caid, gen(medicaid_flag) rename medicaid_flag1 medicaid_explicit rename medicaid_flag2 medicaid_imputed rename medicaid_flag3 medicaid_edited *** Add additional code for imputed from fl_665, othstyp, or ahityp replace medicaid_imputed = 1 if (fl_665== 2|fl_665 == 3) | i_oth == 1 | iahityp == 1 replace medicaid_edited = 0 if medicaid_imputed == 1 replace medicaid_explicit = 0 if medicaid_imputed == 1 ******************** /* RACE VARIABLES */ ******************** * make as consistent with earlier years as possible - hisp, white only, then any american indian, any black, and any asian * the non-identified multiple races are assigned the modal category - white gen race = . replace race = 1 if pehsp == 1 replace race = 2 if (prdtrace == 1|prdtrace == 20|prdtrace == 21) & race == . replace race = 3 if (prdtrace == 3|prdtrace == 7|prdtrace == 10 |prdtrace== 13|prdtrace == 15|prdtrace == 17|prdtrace == 19) & race == . replace race = 4 if (prdtrace == 2|prdtrace == 6|prdtrace == 11 |prdtrace == 12|prdtrace == 16) & race == . replace race = 5 if (prdtrace == 4 | prdtrace==5|prdtrace == 8 | prdtrace==9|prdtrace == 14|prdtrace == 18) & race == . #d ; label define race 3 "American Indian" 4 "Black" 5 "Asian/Pacific Islander" 2 "White Only" 1 "Hispanic", modify ; #d cr label values race race tab race, gen(race_cat) rename race_cat1 phispanic rename race_cat2 pwhite rename race_cat3 pai rename race_cat4 pblack rename race_cat5 papi ******************************** /* GENDER INDICATOR VARIABLE */ ******************************** gen male = . replace male = 1 if a_sex == 1 replace male = 0 if a_sex == 2 label define male 1 "Male" 0 "Female" label val male male ******************** /* AGE CATEGORIES */ ******************** gen age_cat = . replace age_cat = 1 if a_age < 6 replace age_cat = 2 if a_age >= 6 & a_age < 15 replace age_cat = 3 if a_age >= 15 & a_age < 18 replace age_cat = 4 if a_age >= 18 & a_age < 45 replace age_cat = 5 if a_age >= 45 & a_age < 65 replace age_cat = 6 if a_age >= 65 tab age_cat, generate(cat_ages) rename cat_ages1 age_005 rename cat_ages2 age_614 rename cat_ages3 age_1517 rename cat_ages4 age_1844 rename cat_ages5 age_4564 rename cat_ages6 age_65up ********************* /* INCOME VARIABLE */ ********************* generate ZERO = . replace ZERO = 1 if ftotval <= 0 replace ZERO = 0 if ftotval > 0 *** dummy indicator variables for poverty ratios *** replace rpl = . replace rpl = 1 if povll == 1 replace rpl = 2 if povll == 2 replace rpl = 3 if povll == 3 replace rpl = 4 if povll == 4 replace rpl = 5 if povll == 5 replace rpl = 6 if povll == 6 replace rpl = 7 if povll == 7 replace rpl = 8 if povll > = 8 tab rpl, gen(rpl) ***************************** /* RELATIONSHIP VARIABLES */ **************************** gen rel = . replace rel = 1 if a_exprrp == 3 | a_exprrp == 4 replace rel = 2 if a_exprrp == 5 replace rel = 3 if a_exprrp == 8 replace rel = 4 if a_exprrp == 6 | a_exprrp == 7 | (a_exprrp > 8 & a_exprrp <= 14) replace rel = 5 if a_exprrp == 1 | a_exprrp == 2 tab rel, gen(rel) rename rel1 rel_spouse rename rel2 rel_child rename rel3 rel_parent rename rel4 rel_other rename rel5 rel_self **************** *** States ***** **************** # d; label define state 1 "Alabama" 2 "Alaska" 4 "Arizona" 5 "Arkansas" 6 "California" 8 "Colorado" 9 "Connecticut" 10 "Delaware" 11 "District of Columbia" 12 "Florida" 13 "Georgia" 15 "Hawaii" 16 "Idaho" 17 "Illinois" 18 "Indiana" 19 "Iowa" 20 "Kansas" 21 "Kentucky" 22 "Louisiana" 23 "Maine" 24 "Maryland" 25 "Massachusetts" 26 "Michigan" 27 "Minnesota" 28 "Mississippi" 29 "Missouri" 30 "Montana" 31 "Nebraska" 32 "Nevada" 33 "New Hampshire" 34 "New Jersey" 35 "New Mexico" 36 "New York" 37 "North Carolina" 38 "North Dakota" 39 "Ohio" 40 "Oklahoma" 41 "Oregon" 42 "Pennsylvania" 44 "Rhode Island" 45 "South Carolina" 46 "South Dakota" 47 "Tennessee" 48 "Texas" 49 "Utah" 50 "Vermont" 51 "Virginia" 53 "Washington" 54 "West Virginia" 55 "Wisconsin" 56 "Wyoming"; #d cr label values gestfips state * indicator variables for the states dummieslab gestfips