
libname library 'C:\2000PUMA_5pct\migration';
libname pums v7 'C:\2000PUMA_5pct\migration';


proc format library = library ;
  value $RT
  'H' = 'Household record'
  'P' = 'Person record'
  ;
value $SMPL
  '1' = '1% sample'
  '5' = '5% sample'
  ;
value $STATE
  '01' = 'Alabama'
  '02' = 'Alaska'
  '04' = 'Arizona'
  '05' = 'Arkansas'
  '06' = 'California'
  '08' = 'Colorado'
  '09' = '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'
  '33' = 'New Hampshire'
  '34' = 'New Jersey'
  '35' = 'New Mexico'
  '36' = 'New York'
  '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'
  '72' = 'Puerto Rico'
  ;
value $REGF
  '0' = 'Region not identified'
  '1' = 'Northeast'
  '2' = 'Midwest'
  '3' = 'South'
  '4' = 'West'
  ;
value $DIVISF
  '0' = 'Division not identified'
  '1' = 'New England'
  '2' = 'Middle Atlantic'
  '3' = 'East North Central'
  '4' = 'West North Central'
  '5' = 'South Atlantic'
  '6' = 'East South Central'
  '7' = 'West South Central'
  '8' = 'Mountain'
  '9' = 'Pacific'
  ;
value $MSCMS5_
  '9997' = 'Mixed MSA/CMSA:nonmetro territory'
  '9998' = '2 or more MSAs/CMSAs'
  '9999' = 'Not in metro area'
  ;
value $MSPMS5_
  '9997' = 'Mixed MSA/CMSA:nonmetro territory'
  '9998' = '2 or more MSAs/CMSAs'
  '9999' = 'Not in metro area'
  ;
value $MSCMS1_
  '9997' = 'Mixed MSA/CMSA:nonmetro territory'
  '9998' = '2 or more MSAs/CMSAs'
  '9999' = 'Not in metro area'
  ;
value $MSPMS1_
  '9997' = 'Mixed MSA/CMSA:nonmetro territory'
  '9998' = '2 or more MSAs/CMSAs'
  '9999' = 'Not in metro area'
  ;
value $AREA5_
  '11' = 'Inside central city/MSA part of full MSA'
  '12' = 'Outside central city/MSA part of full MSA'
  '13' = 'Inside/outside central city/MSA part of full MSA'
  '14' = 'Entire MSA'
  '21' = 'Inside central city/MSA part of partial MSA'
  '22' = 'Outside central city/MSA part of partial MSA'
  '23' = 'Inside/outside central city/MSA part of partial MSA'
  '31' = 'Inside central city/PMSA part of full PMSA/CMSA'
  '32' = 'Outside central city/PMSA part of full PMSA/CMSA'
  '33' = 'Inside/outside central city/PMSA part of full PMSA/CMSA'
  '34' = 'Entire PMSA/PMSA belongs to full CMSA'
  '41' = 'Inside central city/PMSA part of full PMSA/partial CMSA'
  '42' = 'Outside central city/PMSA part of full PMSA/partial CMSA'
  '43' = 'Inside/outside central city/PMSA part of full PMSA/partial CMSA'
  '44' = 'Entire PMSA/PMSA belongs to partial CMSA'
  '51' = 'Inside central city/PMSA part of partial PMSA/CMSA'
  '52' = 'Outside central city/PMSA part of partial PMSA/CMSA'
  '53' = 'Inside/outside central city/PMSA part of partial PMSA/CMSA'
  '70' = 'Both metro and nonmetro territory'
  '80' = 'Metro in 2+ partial and/or entire MSAs/PMSAs/CMSAs'
  '90' = 'Only metro territory'
  ;
value $AREA1_
  '11' = 'Inside central city/MSA part of full MSA'
  '12' = 'Outside central city/MSA part of full MSA'
  '13' = 'Inside/outside central city/MSA part of full MSA'
  '14' = 'Entire MSA'
  '21' = 'Inside central city/MSA part of partial MSA'
  '22' = 'Outside central city/MSA part of partial MSA'
  '23' = 'Inside/outside central city/MSA part of partial MSA'
  '31' = 'Inside central city/PMSA part of full PMSA/CMSA'
  '32' = 'Outside central city/PMSA part of full PMSA/CMSA'
  '33' = 'Inside/outside central city/PMSA part of full PMSA/CMSA'
  '34' = 'Entire PMSA/PMSA belongs to full CMSA'
  '41' = 'Inside central city/PMSA part of full PMSA/partial CMSA'
  '42' = 'Outside central city/PMSA part of full PMSA/partial CMSA'
  '43' = 'Inside/outside central city/PMSA part of full PMSA/partial CMSA'
  '44' = 'Entire PMSA/PMSA belongs to partial CMSA'
  '51' = 'Inside central city/PMSA part of partial PMSA/CMSA'
  '52' = 'Outside central city/PMSA part of partial PMSA/CMSA'
  '53' = 'Inside/outside central city/PMSA part of partial PMSA/CMSA'
  '70' = 'Both metro and nonmetro territory'
  '80' = 'Metro in 2+ partial and/or entire MSAs/PMSAs/CMSAs'
  '90' = 'Only metro territory'
  ;
value PERSONS   
   00 = 'Vacant unit'
   01 = 'Householder living alone/any person in GQ'
  ;
value $UT
  '0' = 'Housing unit'
  '1' = 'Institutional group quarters'
  '2' = 'Noninstitutional group quarters'
  ;
value $HSUB
  '0' = 'Not substituted or GQ'
  '1' = 'Substituted'
  ;
value $HAUG
  '0' = 'Not augmented or GQ'
  '1' = 'Augmented'
  ;
value $VCST
  '0' = 'Not in universe (occupied or GQ)'
  '1' = 'For rent'
  '2' = 'For sale only'
  '3' = 'Rented or sold, not occupied'
  '4' = 'For seasonal, recreational or occasional use'
  '5' = 'For migrant workers'
  '6' = 'Other vacant'
  ;
value $VCSTA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $TNR
  '0' = 'Not in universe (vacant/GQ)'
  '1' = 'Owned by you or someone in this household with a mortgage or loan'
  '2' = 'Owned by you or someone in this household free and clear'
  '3' = 'Rented for cash rent'
  '4' = 'Occupied without payment of cash rent'
  ;
value $TNRA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $BLD
  '  ' = 'Not in universe (GQ)'
  '01' = 'Mobile home'
  '02' = 'One-family house detached'
  '03' = 'One-family house attached'
  '04' = '2 apartments'
  '05' = '3 or 4 apartments'
  '06' = '5 to 9 apartments'
  '07' = '10 to 19 apartments'
  '08' = '20 to 49 apartments'
  '09' = '50 or more apartments'
  '10' = 'Boat, RV, van, etc.'
  ;
value $BLDA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $YRBLT
  ' ' = 'Not in universe (GQ)'
  '1' = '1999 to 2000'
  '2' = '1995 to 1998'
  '3' = '1990 to 1994'
  '4' = '1980 to 1989'
  '5' = '1970 to 1979'
  '6' = '1960 to 1969'
  '7' = '1950 to 1959'
  '8' = '1940 to 1949'
  '9' = '1939 or earlier'
  ;
value $YRBLTA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $YRMVD
  ' ' = 'Not in universe (vacant/GQ)'
  '1' = '1999 or 2000'
  '2' = '1995 to 1998'
  '3' = '1990 to 1994'
  '4' = '1980 to 1989'
  '5' = '1970 to 1979'
  '6' = '1969 or earlier'
  ;
value $YRMVDA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $ROOMS
  ' ' = 'Not in universe/GQ'
  '1' = '1 room'
  '2' = '2 rooms'
  '3' = '3 rooms'
  '4' = '4 rooms'
  '5' = '5 rooms'
  '6' = '6 rooms'
  '7' = '7 rooms'
  '8' = '8 rooms'
  '9' = '9 or more rooms'
  ;
value $RMSA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $BEDRMS
  '0' = 'No bedrooms'
  '1' = '1 bedroom'
  '2' = '2 bedrooms'
  '3' = '3 bedrooms'
  '4' = '4 bedrooms'
  '5' = '5 or more bedrooms'
  ;
value $BDRMSA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $CPLMB
  ' ' = 'Not in universe (GQ)'
  '1' = 'Yes, have all three facilites'
  '2' = 'No'
  ;
value $CPLMBA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $CKTCH
  ' ' = 'Not in universe (GQ)'
  '1' = 'Yes, have all three facilities'
  '2' = 'No'
  ;
value $CKTCHA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $PHN
  ' ' = 'Not in universe (vacant/GQ)'
  '1' = 'Yes'
  '2' = 'No'
  ;
value $PHNA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $FUEL
  ' ' = 'Not in universe (vacant/GQ)'
  '1' = 'Gas from underground pipes serving neighborhood'
  '2' = 'Gas: bottled, tank, or LP'
  '3' = 'Electricity'
  '4' = 'Fuel oil, kerosene, etc'
  '5' = 'Coal or coke'
  '6' = 'Wood'
  '7' = 'Solar energy'
  '8' = 'Other fuel'
  '9' = 'No fuel used'
  ;
value $FUELA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $VEHICL
  ' ' = 'Not in universe/vacant/GQ'
  '0' = 'No vehicles'
  '1' = '1 vehicle'
  '2' = '2 vehicles'
  '3' = '3 vehicles'
  '4' = '4 vehicles'
  '5' = '5 vehicles'
  '6' = '6 or more vehicles'
  ;
value $VHCLA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $BSNS
  ' ' = 'Not in universe (vacant/GQ/occupied and BLDGSZ>3)'
  '1' = 'Yes'
  '2' = 'No'
  ;
value $BSNSA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $ACR
  ' ' = 'Not in universe/vacant/GQ/occupied and BLDGSZ>3'
  '1' = 'Less than 1 acre'
  '2' = '1.0 to 9.9 acres'
  '3' = '10 acres or more'
  ;
value $ACRA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $AGSLS
  ' ' = 'Not in universe (vacant/GQ/occupied and ACRES=1 or BLDGSZ>3)'
  '0' = 'None'
  '1' = '$1 to $999'
  '2' = '$1,000 to $2,499'
  '3' = '$2.500 to $4,999'
  '4' = '$5,000 to $9,999'
  '5' = '$10,000 or more'
  ;
value $AGSLSA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $ELEC
  '    ' = 'Not in universe/vacant/GQ'
  '0000' = 'Included in rent or condo fee'
  '0001' = 'No charge or not used'
  '0002' = '$1 or $2'
  ;
value $ELECA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $GAS
  '    ' = 'Not in universe/vacant/GQ'
  '0000' = 'Included in rent or condo fee'
  '0001' = 'No charge or not used'
  '0002' = '$1 or $2'
  ;
value $GASA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $WTR
  '    ' = 'Not in universe (vacant/GQ)'
  '0000' = 'Included in rent or condo fee'
  '0001' = 'No charge or not used'
  '0002' = '$1 or $2'
  ;
value $WTRA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $OIL
  '    ' = 'Not in universe (vacant/GQ)'
  '0000' = 'Included in rent or condo fee'
  '0001' = 'No charge or not used'
  '0002' = '$1 or $2'
  ;
value $OILA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $RENT
  '    ' = 'Not in universe (GQ/TENURE is not 3 and VACSTAT is not 1)'
  ;
value $RENTA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $MEALS
  ' ' = 'Not in universe (GQ/TENURE is not 3 and VACSTAT is not 1)'
  '1' = 'Yes'
  '2' = 'No'
  ;
value $MEALSA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $MRTG1_
  ' ' = 'Not in universe (vacant/GQ/renter occupied)'
  '1' = 'Yes, mortgage, deed of trust or similar debt'
  '2' = 'Yes, contract to purchase'
  '3' = 'No'
  ;
value $MRTG1A
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $AMT1_
  '     ' = 'Not in universe (vacant/GQ/renter-occupied/MORTG1=3)'
  '00000' = 'No regular payment'
  ;
value $AMT1A
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $MRTG2_
  ' ' = 'Not in universe (vacant/GQ/renter-occupied/MORTG1=3)'
  '1' = 'Yes, 2nd mortgage'
  '2' = 'Yes, home equity loan'
  '3' = 'No'
  '4' = 'Both 2nd mortgage and home equity loan'
  ;
value $MRTG2A
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $AMT2_
  '     ' = 'Not in universe (vacant/GQ/renter-occupied/MORTG1=3)'
  '00000' = 'No regular payment'
  ;
value $AMT2A
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $TXINCL
  ' ' = 'Not in universe (vacant/GQ/renter-occupied/MRTG1=3)'
  '1' = 'Yes, taxes included in mortgage payment'
  '2' = 'No, taxes paid separately, or taxes not required'
  ;
value $TXINCLA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $TXAMT
  '00' = 'Not in universe (GQ/renter-occupied/vacant but VACSTAT not 2)'
  '01' = 'No taxes paid'
  '02' = '$1-$49'
  '03' = '$50-$99'
  '04' = '$100-$149'
  '05' = '$150-$199'
  '06' = '$200-$249'
  '07' = '$250-$299'
  '08' = '$300-$349'
  '09' = '$350-$399'
  '10' = '$400-$449'
  '11' = '$450-$499'
  '12' = '$500-$549'
  '13' = '$550-$599'
  '14' = '$600-$649'
  '15' = '$650-$699'
  '16' = '$700-$749'
  '17' = '$750-$799'
  '18' = '$800-$849'
  '19' = '$850-$899'
  '20' = '$900-$949'
  '21' = '$950-$999'
  '22' = '$1000-$1,099'
  '23' = '$1,100-$1,199'
  '24' = '$1,200-$1,299'
  '25' = '$1,300-$1,399'
  '26' = '$1,400-$1,499'
  '27' = '$1,500-$1,599'
  '28' = '$1,600-$1,699'
  '29' = '$1,700-$1,799'
  '30' = '$1,800-$1,899'
  '31' = '$1,900-$1,999'
  '32' = '$2,000-$2,099'
  '33' = '$2,100-$2,199'
  '34' = '$2,200-$2,299'
  '35' = '$2,300-$2,399'
  '36' = '$2,400-$2,499'
  '37' = '$2,500-$2,599'
  '38' = '$2,600-$2,699'
  '39' = '$2,700-$2,799'
  '40' = '$2,800-$2,899'
  '41' = '$2,900-$2,999'
  '42' = '$3,000-$3,099'
  '43' = '$3,100-$3,199'
  '44' = '$3,200-$3,299'
  '45' = '$3,300-$3,399'
  '46' = '$3,400-$3,499'
  '47' = '$3,500-$3,599'
  '48' = '$3,600-$3,699'
  '49' = '$3,700-$3,799'
  '50' = '$3,800-$3,899'
  '51' = '$3,900-$3,999'
  '52' = '$4,000-$4,099'
  '53' = '$4,100-$4,199'
  '54' = '$4,200-$4,299'
  '55' = '$4,300-$4,399'
  '56' = '$4,400-$4,499'
  '57' = '$4,500-$4,599'
  '58' = '$4,600-$4,699'
  '59' = '$4,700-$4,799'
  '60' = '$4,800-$4,899'
  '61' = '$4,900-$4,999'
  '62' = '$5,000-$5,499'
  '63' = '$5,500-$5,999'
  '64' = '$6,000-$6,999'
  '65' = '$7,000-$7.999'
  '66' = '$8,000-$9,099'
  '67' = '$9,100 or more'
  ;
value $TXAMTA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $INS
  ' ' = 'Not in universe (vacant/GQ/renter-occupied/MORTG1=3)'
  '1' = 'Yes, insurance inclued in mortgage payment'
  '2' = 'No, insurance paid separately, or no insurance'
  ;
value $INSA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $INSAMT
  '    ' = 'Not in universe (vacant/GQ/renter-occupied)'
  '0000' = 'No insurance payment'
  ;
value $INSATA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $CNDF
  '    ' = 'Not in universe (vacant/GQ/renter-occupied)'
  '0000' = 'Not a condo'
  ;
value $CNDFA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $VALUE
  '  ' = 'Not in universe (GQ/TENURE=3-4/VACSTAT=1,3-6)'
  '01' = 'Less than $10,000'
  '02' = '$10,000-$14,999'
  '03' = '$15,000-$19,999'
  '04' = '$20,000-$24,999'
  '05' = '$25,000-$29,999'
  '06' = '$30,000-$34,999'
  '07' = '$35,000-$39,999'
  '08' = '$40,000-$49,999'
  '09' = '$50,000-$59,999'
  '10' = '$60,000-$69,999'
  '11' = '$70,000-$79,999'
  '12' = '$80,000-$89,999'
  '13' = '$90,000-$99,999'
  '14' = '$100,000-$124,999'
  '15' = '$125,000-$149,999'
  '16' = '$150,000-$174,999'
  '17' = '$175,000-$199,999'
  '18' = '$200,000-$249,999'
  '19' = '$250,000-$299,999'
  '20' = '$300,000-$399,999'
  '21' = '$400,000-$499,999'
  '22' = '$500,000-$749,999'
  '23' = '$750,000-$999,999'
  '24' = '$1,000,000 or more'
  ;
value $VALUEA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $MHLN
  ' ' = 'Not in universe (GQ/TENURE not 1-2/BLDGSZ not 1)'
  '1' = 'Yes'
  '2' = 'No'
  ;
value $MHLNA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $MHCST
  '     ' = 'Not in universe (GQ/TENURE not 1-2/BLDGSZ not 1)'
  '00000' = 'No cost'
  ;
value $MHCSTA
  '0' = 'Not allocated or GQ'
  '1' = 'Allocated'
  ;
value $HHT
  '0' = 'Not in universe (vacant/GQ)'
  '1' = 'Family household:married-couple'
  '2' = 'Family household:male householder, no wife present'
  '3' = 'Family household:female householder, no husband present'
  '4' = 'Nonfamily household:Male householder, living alone'
  '5' = 'Nonfamily household:Male householder, not living alone'
  '6' = 'Nonfamily household:Female householder, living alone'
  '7' = 'Nonfamily household:Female householder, not living alone'
  ;
value $P65_
  '00' = 'Not in universe (vacant/GQ)'
  ;
value $P18_
  '00' = 'Not in universe (vacant/GQ)'
  ;
value $NPF
  '00' = 'Not in universe (vacant/GQ/HHT not 1-3)'
  ;
value $NOC
  '00' = 'None (includes not in universe:vacant/GQ)'
  ;
value $NRC
  '00' = 'None (includes not in universe:vacant/GQ)'
  ;
value $PSF
  '0' = 'No subfamilies (includes not in universe:vacant/GQ)'
  '1' = '1 or more subfamiles'
  ;
value $PAOC
  '0' = 'Not in universe (vacant/GQ)'
  '1' = 'With own children under 6 years only'
  '2' = 'With own children 6-17 years only'
  '3' = 'With own children under 6 and 6-17 years'
  '4' = 'No own children under 18 years'
  ;
value $PARC
  '0' = 'Not in universe (vacant/GQ)'
  '1' = 'With related children under 6 years only'
  '2' = 'With related children 6-17 years only'
  '3' = 'With related children under 6 and 6-17 years'
  '4' = 'No related children under 18 years'
  ;
value $SVAL
  '0' = 'Not specified unit (includes GQ/rental units)'
  '1' = 'Specified unit'
  ;
value $SMOC
  '00000' = 'Not in universe (vacant/GQ/no costs/not owner-occupied)'
  '25000' = '$25,000 or more'
  ;
value $SMOCAPI
  '000' = 'Not in universe (vacant/GQ/no costs/not owner-occupied/HHI<$1)'
  '101' = '101% or more'
  ;
value $SRNT
  '0' = 'Not specified rental unit (includes GQ, owned units)'
  '1' = 'Specified'
  ;
value $GRENT
  '0000' = 'Not in universe (vacant/GQ/owner-occupied/not rented for cash rent)'
  '9999' = '$9,999 or more'
  ;
value $GRAPI
  '000' = 'Not in universe (vcnt/GQ/ownr-occpd/not rented for cash rent/HHI-/0%)'
  '101' = '101% or more'
  ;
value $FNF
  '0' = 'Not in universe (GQ/urban)'
  '1' = 'Farm'
  '2' = 'Nonfarm'
  ;
value $HHL
  '0' = 'Not in universe (vacant/GQ)'
  '1' = 'English only'
  '2' = 'Spanish'
  '3' = 'Other Indo-European'
  '4' = 'Asian or Pacific Island'
  '5' = 'Other language'
  ;
value $LNGI
  '0' = 'Not in universe (vacant/GQ)'
  '1' = 'Not linguistically isolated'
  '2' = 'Linguistically isolated'
  ;
value $WIF
  '0' = 'Not in universe (vacant/GQ/HHT not 1-3)'
  '1' = 'No workers in family'
  '2' = '1 worker in family'
  '3' = '2 workers in family'
  '4' = '3 or more workers in family'
  ;
value $EMPSTAT
  '0' = 'Not in universe (vacant/GQ/HHT not 1-3)'
  '1' = 'Mrrd-cpl family:husband and wife in labor force'
  '2' = 'Mrrd-cpl family:husband in labor force, wife not in labor force'
  '3' = 'Mrrd-cpl family:husband not in labor force, wife in labor force'
  '4' = 'Mrrd-cpl family:husband and wife not in labor force'
  '5' = 'Other family, male hhldr, no wife present, in labor force'
  '6' = 'Other family, male hhldr, no wife present, not in labor force'
  '7' = 'Other family, female hhldr, no husband present, in labor force'
  '8' = 'Other family, female hhldr, no husband present, not in labor force'
  ;
value $WRKEXP
  '00' = 'Not in universe (vacant/GQ/HHT not 1-3)'
  '01' = 'Mrrd-cpl fmly:hhldr and spse wrkd FTYR in 1999'
  '02' = 'Mrrd-cpl fmly:hhldr wrkd FTYR in 1999, spse wrkd < FTYR in 1999'
  '03' = 'Mrrd-cpl fmly:hhldr wrkd FTYR in 1999, spse did not work in 1999'
  '04' = 'Mrrd-cpl fmly:hhldr wrkd < FTYR in 1999, spse wrkd FTYR in 1999'
  '05' = 'Mrrd-cpl fmly:hhldr and spse wrkd < FTYR in 1999'
  '06' = 'Mrrd-cpl fmly:hhldr wrkd < FTYR in 1999, spse did not work in 1999'
  '07' = 'Mrrd-cpl fmly:hhldr did not work in 1999, spse wrkd FTYR in 1999'
  '08' = 'Mrrd-cpl fmly:hhldr did not work in 1999, spse wrkd < FTYR in 1999'
  '09' = 'Mrrd-cpl fmly:hhldr and spse did not work in 1999'
  '10' = 'Other fmly:MHNWP, hhldr wrkd FTYR in 1999'
  '11' = 'Other fmly:MHNWP, hhldr wrkd < FTYR in 1999'
  '12' = 'Other fmly:MHNWP, hhldr did not work in 1999'
  '13' = 'Other fmly:FHNHP, hhldr wrkd FTYR in 1999'
  '14' = 'Other fmly:FHNHP, hhldr wrkdy < FTYR in 1999'
  '15' = 'Other fmly:FHNHP, hhldr did not work in 1999'
  ;
value $HINC
  '-0059999' = 'Loss of $59,999 or more'
  '00000000' = 'Not in universe(vacant/GQ/no income'
  '00000001' = '$1 or break even'
  '99999999' = '$99,999,999 or more'
  ;
value $FINC
  '-0059999' = 'Loss of $59,999 or more'
  '00000000' = 'Not in universe (vacant/GQ/no income'
  '00000001' = '$1 or break even'
  '99999999' = '$99,999,999 or more'
  ;
run;

proc datasets library = pums ;
modify migpumswa2;
   format    REGION REGION.;
   format  DIVISION DIVISIO.;
   format  AREATYP5 AREATYP.;
   format  AREATYP1 AREATYP.;
   format   PERSONS PERSONS.;
   format  UNITTYPE UNITTYP.;
   format   VACSTAT VACSTAT.;
   format    TENURE TENURE.;
   format    BLDGSZ BLDGSZ.;
   format   YRBUILT YRBUILT.;
   format   YRMOVED YRMOVED.;
   format     ROOMS ROOMS.;
   format    BEDRMS BEDRMS.;
   format    CPLUMB CPLUMB.;
   format    CKITCH CKITCH.;
   format     PHONE PHONE.;
   format      FUEL FUEL.;
   format    VEHICL VEHICL.;
   format   BUSINES BUSINES.;
   format     ACRES ACRES.;
   format   AGSALES AGSALES.;
   format      ELEC ELEC.;
   format       GAS GAS.;
   format     WATER WATER.;
   format       OIL OIL.;
   format     MEALS MEALS.;
   format    MORTG1 MORTGA.;
   format   MRT1AMT MRT1AMT.;
   format    MORTG2 MORTGB.;
   format   MRT2AMT MRT2AMT.;
   format   TAXINCL TAXINCL.;
   format    TAXAMT TAXAMT.;
   format   INSINCL INSINCL.;
   format    INSAMT INSAMT.;
   format   CONDFEE CONDFEE.;
   format     VALUE VALUE.;
   format    MHLOAN MHLOAN.;
   format       HHT HHT.;
   format       PSF PSF.;
   format      PAOC PAOC.;
   format      PARC PARC.;
   format      SVAL SVAL.;
   format      SRNT SRNT.;
   format       FNF FNF.;
   format       HHL HHL.;
   format      LNGI LNGI.;
   format       WIF WIF.;
   format   EMPSTAT EMPSTAT.;
   format   WORKEXP WORKEXP.;
   format      HSUB HSUB.;
   format      HAUG HAUG.;
   format  VACSTATA VACSTAT.;
   format   TENUREA TENUREA.;
   format   BLDGSZA BLDGSZA.;
   format  YRBUILTA YRBUILT.;
   format  YRMOVEDA YRMOVED.;
   format    ROOMSA ROOMSA.;
   format   BEDRMSA BEDRMSA.;
   format   CPLUMBA CPLUMBA.;
   format   CKITCHA CKITCHA.;
   format    PHONEA PHONEA.;
   format     FUELA FUELA.;
   format   VEHICLA VEHICLA.;
   format  BUSINESA BUSINES.;
   format    ACRESA ACRESA.;
   format  AGSALESA AGSALES.;
   format     ELECA ELECA.;
   format      GASA GASA.;
   format    WATERA WATERA.;
   format      OILA OILA.;
   format     RENTA RENTA.;
   format    MEALSA MEALSA.;
   format   MORTG1A MORTG1A.;
   format  MRT1AMTA MRT1AMT.;
   format   MORTG2A MORTG2A.;
   format  MRT2AMTA MRT2AMT.;
   format  TAXINCLA TAXINCL.;
   format   TAXAMTA TAXAMTA.;
   format  INSINCLA INSINCL.;
   format   INSAMTA INSAMTA.;
   format  CONDFEEA CONDFEE.;
   format    VALUEA VALUEA.;
   format   MHLOANA MHLOANA.;
   format   MHCOSTA MHCOSTA.;
   format       DDP DDP.;
   format    RELATE RELATE.;
   format        OC OC.;
   format        RC RC.;
   format     PAOCF PAOCF.;
   format       SEX SEX.;
   format    HISPAN HISPAN.;
   format   NUMRACE NUMRACE.;
   format     WHITE WHITE.;
   format     BLACK BLACK.;
   format      AIAN AIAN.;
   format     ASIAN ASIAN.;
   format      NHPI NHPI.;
   format     OTHER OTHER.;
   format     RACE1 RACEA.;
   format     RACE2 RACEB.;
   format     RACE3 RACEC.;
   format   MARSTAT MARSTAT.;
   format       MSP MSP.;
   format       SFN SFN.;
   format     SFREL SFREL.;
   format    ENROLL ENROLL.;
   format     GRADE GRADE.;
   format      EDUC EDUC.;
   format  ANCFRST5 ANCFRST.;
   format  ANCSCND5 ANCSCND.;
   format      ANCR ANCR.;
   format     SPEAK SPEAK.;
   format     LANG5 LANGA.;
   format   ENGABIL ENGABIL.;
   format      POB5 POBA.;
   format   CITIZEN CITIZEN.;
   format     YR2US YR2US.;
   format       MOB MOB.;
   format    MIGST5 MIGSTA.;
   format  MIGAREA5 MIGAREA.;
   format  MIGAREA1 MIGAREA.;
   format   SENSORY SENSORY.;
   format    PHYSCL PHYSCL.;
   format    MENTAL MENTAL.;
   format   SLFCARE SLFCARE.;
   format      ABGO ABGO.;
   format    ABWORK ABWORK.;
   format   DISABLE DISABLE.;
   format    GRANDC GRANDC.;
   format   RSPNSBL RSPNSBL.;
   format   HOWLONG HOWLONG.;
   format   MILTARY MILTARY.;
   format      VPS1 VPSA.;
   format      VPS2 VPSB.;
   format      VPS3 VPSC.;
   format      VPS4 VPSD.;
   format      VPS5 VPSE.;
   format      VPS6 VPSF.;
   format      VPS7 VPSG.;
   format      VPS8 VPSH.;
   format      VPS9 VPSI.;
   format    MILYRS MILYRS.;
   format      VPSR VPSR.;
   format       ESR ESR.;
   format       ESP ESP.;
   format    POWST5 POWSTA.;
   format  POWAREA5 POWAREA.;
   format  POWAREA1 POWAREA.;
   format   POWCMA5 POWCMAA.;
   format   POWCMA1 POWCMAB.;
   format   POWPMA5 POWPMAA.;
   format   POWPMA1 POWPMAB.;
   format    TRVMNS TRVMNS.;
   format   CARPOOL CARPOOL.;
   format    LVTIME LVTIME.;
   format    LAYOFF LAYOFF.;
   format    ABSENT ABSENT.;
   format    RECALL RECALL.;
   format   LOOKWRK LOOKWRK.;
   format   BACKWRK BACKWRK.;
   format   LASTWRK LASTWRK.;
   format    INDCEN INDCEN.;
   format   OCCCEN5 OCCCENA.;
   format   OCCSOC5 OCCSOCA.;
   format     CLWKR CLWKR.;
   format    WRKLYR WRKLYR.;
   format      PAUG PAUG.;
   format   RELATEA RELATEA.;
   format      SEXA SEXA.;
   format      AGEA AGEA.;
   format   HISPANA HISPANA.;
   format     RACEA RACEA.;
   format  MARSTATA MARSTAT.;
   format   ENROLLA ENROLLA.;
   format    GRADEA GRADEA.;
   format     EDUCA EDUCA.;
   format      ANCA ANCA.;
   format    SPEAKA SPEAKA.;
   format     LANGA LANGA.;
   format  ENGABILA ENGABIL.;
   format      POBA POBA.;
   format  CITIZENA CITIZEN.;
   format    YR2USA YR2USA.;
   format      MOBA MOBA.;
   format    MIGSTA MIGSTA.;
   format  SENSORYA SENSORY.;
   format   PHYSCLA PHYSCLA.;
   format   MENTALA MENTALA.;
   format  SLFCAREA SLFCARE.;
   format     ABGOA ABGOA.;
   format   ABWORKA ABWORKA.;
   format   GRANDCA GRANDCA.;
   format  RSPNSBLA RSPNSBL.;
   format  HOWLONGA HOWLONG.;
   format  MILTARYA MILTARY.;
   format      VPSA VPSA.;
   format   MILYRSA MILYRSA.;
   format      ESRA ESRA.;
   format    POWSTA POWSTA.;
   format   TRVMNSA TRVMNSA.;
   format  CARPOOLA CARPOOL.;
   format   LVTIMEA LVTIMEA.;
   format  TRVTIMEA TRVTIME.;
   format  LASTWRKA LASTWRK.;
   format   INDCENA INDCENA.;
   format   OCCCENA OCCCENA.;
   format    CLWKRA CLWKRA.;
   format   WRKLYRA WRKLYRA.;
   format    WEEKSA WEEKSA.;
   format    HOURSA HOURSA.;
   format    INCWSA INCWSA.;
   format    INCSEA INCSEA.;
   format   INCINTA INCINTA.;
   format    INCSSA INCSSA.;
   format   INCSSIA INCSSIA.;
   format    INCPAA INCPAA.;
   format   INCRETA INCRETA.;
   format   INCOTHA INCOTHA.;
   format   INCTOTA INCTOTA.;
quit;

