income_to_keep.do

* income to keep

keep cbsa_code st_cd st_abbrev geo_id name s1901_c01_002e s1901_c01_003e s1901_c01_004e s1901_c01_005e s1901_c01_006e s1901_c01_007e s1901_c01_008e s1901_c01_009e s1901_c01_010e s1901_c01_011e s1901_c01_012e


rename s1901_c01_002e hhinc_lt_10000
rename s1901_c01_003e hhinc_10_14999 
rename s1901_c01_004e hhinc_15_24999 
rename s1901_c01_005e hhinc_25_34999 
rename s1901_c01_006e hhinc_35_49999 
rename s1901_c01_007e hhinc_50_74999 
rename s1901_c01_008e hhinc_75_99999 
rename s1901_c01_009e hhinc_100_149999 
rename s1901_c01_010e hhinc_150_199999 
rename s1901_c01_011e hhinc_gt_200000 
rename s1901_c01_012e hhinc_median_income