. count 3289 . di "Cases where 2005 and 2011 file differ in CBSA variable" Cases where 2005 and 2011 file differ in CBSA variable . count if cbsa != cbsa2005 22 . list fipscounty ssacounty cbsa cbsa2005 cbsaname cbsaname2005 if cbsa != cbsa2005 +-----------------------------------------------------------------------------------------------------------------------------+ | fipsco~y ssacou~y cbsa cbsa2005 cbsaname cbsaname2005 | |-----------------------------------------------------------------------------------------------------------------------------| 118. | 04015 03070 29420 Lake Havasu City-Kingman, AZ | 329. | 09005 07020 25540 Hartford-West Hartford-East Hartford, C | 357. | 12035 10170 37380 Palm Coast, FL | 370. | 12061 10300 42680 46940 Sebastian-Vero Beach,FL Vero Beach, FL | 380. | 12081 10400 35840 42260 North Port-Bradenton-Sarasota-Venice, FL Sarasota-Bradenton-Venice, FL | |-----------------------------------------------------------------------------------------------------------------------------| 386. | 12091 10450 18880 23020 Crestview-Fort Walton Beach-Destin, FL Fort Walton Beach-Crestview-Destin, FL | 398. | 12115 10570 35840 42260 North Port-Bradenton-Sarasota-Venice, FL Sarasota-Bradenton-Venice, FL | 621. | 17003 14010 16020 Cape Girardeau-Jackson, MO-IL | 946. | 20061 17300 31740 Mahattan, KS | 990. | 20149 17740 31740 Mahattan, KS | |-----------------------------------------------------------------------------------------------------------------------------| 996. | 20161 17800 31740 Mahattan, KS | 1254. | 25009 22040 37764 21604 Peabody, MA Essex County, MA | 1355. | 27013 24060 31860 Mankato-North Mankato, MN | 1400. | 27103 24510 31860 Mankato-North Mankato, MN | 1528. | 29017 26080 16020 Cape Girardeau-Jackson, MO-IL | |-----------------------------------------------------------------------------------------------------------------------------| 1535. | 29031 26150 16020 Cape Girardeau-Jackson, MO-IL | 1812. | 33013 30060 31700 Manchester-Nashua, NH | 1879. | 36013 33060 27460 | 2131. | 39081 36420 44600 48260 Steubenville-Weirton, WV-OH Weirton-Steubenville, WV-OH | 2203. | 40047 37230 21420 | |-----------------------------------------------------------------------------------------------------------------------------| 3062. | 54009 51040 44600 48260 Steubenville-Weirton, WV-OH Weirton-Steubenville, WV-OH | 3072. | 54029 51140 44600 48260 Steubenville-Weirton, WV-OH Weirton-Steubenville, WV-OH | +-----------------------------------------------------------------------------------------------------------------------------+ . di "Cases where 2005 and 2011 file differ in CBSA variable because CBSA is missing in 2011" Cases where 2005 and 2011 file differ in CBSA variable because CBSA is missing in 2011 . count if cbsa != cbsa2005 & missing(cbsa) 4 . list fipscounty ssacounty cbsa cbsa2005 cbsaname cbsaname2005 if cbsa != cbsa2005 & missing(cbsa) +--------------------------------------------------------------------------------------------+ | fipsco~y ssacou~y cbsa cbsa2005 cbsaname cbsaname2005 | |--------------------------------------------------------------------------------------------| 329. | 09005 07020 25540 Hartford-West Hartford-East Hartford, C | 1812. | 33013 30060 31700 Manchester-Nashua, NH | 1879. | 36013 33060 27460 | 2203. | 40047 37230 21420 | +--------------------------------------------------------------------------------------------+ . di "Cases where 2005 and 2011 file differ in CBSA variable because CBSA is missing in 2005" Cases where 2005 and 2011 file differ in CBSA variable because CBSA is missing in 2005 . count if cbsa != cbsa2005 & missing(cbsa2005) 10 . list fipscounty ssacounty cbsa cbsa2005 cbsaname cbsaname2005 if cbsa != cbsa2005 & missing(cbsa2005) +-----------------------------------------------------------------------------------+ | fipsco~y ssacou~y cbsa cbsa2005 cbsaname cbsana~5 | |-----------------------------------------------------------------------------------| 118. | 04015 03070 29420 Lake Havasu City-Kingman, AZ | 357. | 12035 10170 37380 Palm Coast, FL | 621. | 17003 14010 16020 Cape Girardeau-Jackson, MO-IL | 946. | 20061 17300 31740 Mahattan, KS | 990. | 20149 17740 31740 Mahattan, KS | |-----------------------------------------------------------------------------------| 996. | 20161 17800 31740 Mahattan, KS | 1355. | 27013 24060 31860 Mankato-North Mankato, MN | 1400. | 27103 24510 31860 Mankato-North Mankato, MN | 1528. | 29017 26080 16020 Cape Girardeau-Jackson, MO-IL | 1535. | 29031 26150 16020 Cape Girardeau-Jackson, MO-IL | +-----------------------------------------------------------------------------------+ . count if cbsa != cbsa2005 & !missing(cbsa) & !missing(cbsa2005) 8 . di "Cases where 2005 and 2011 file differ in CBSA variable and CBSA is not missing either year" Cases where 2005 and 2011 file differ in CBSA variable and CBSA is not missing either year . list fipscounty ssacounty cbsa cbsa2005 cbsaname cbsaname2005 if cbsa != cbsa2005 & !missing(cbsa) & !missing(cbsa2005) +----------------------------------------------------------------------------------------------------------------------------+ | fipsco~y ssacou~y cbsa cbsa2005 cbsaname cbsaname2005 | |----------------------------------------------------------------------------------------------------------------------------| 370. | 12061 10300 42680 46940 Sebastian-Vero Beach,FL Vero Beach, FL | 380. | 12081 10400 35840 42260 North Port-Bradenton-Sarasota-Venice, FL Sarasota-Bradenton-Venice, FL | 386. | 12091 10450 18880 23020 Crestview-Fort Walton Beach-Destin, FL Fort Walton Beach-Crestview-Destin, FL | 398. | 12115 10570 35840 42260 North Port-Bradenton-Sarasota-Venice, FL Sarasota-Bradenton-Venice, FL | 1254. | 25009 22040 37764 21604 Peabody, MA Essex County, MA | |----------------------------------------------------------------------------------------------------------------------------| 2131. | 39081 36420 44600 48260 Steubenville-Weirton, WV-OH Weirton-Steubenville, WV-OH | 3062. | 54009 51040 44600 48260 Steubenville-Weirton, WV-OH Weirton-Steubenville, WV-OH | 3072. | 54029 51140 44600 48260 Steubenville-Weirton, WV-OH Weirton-Steubenville, WV-OH | +----------------------------------------------------------------------------------------------------------------------------+ . end of do-file . exit,clear