Variable created: CV_MIGRATE QNAME Variable name ================== ===================== geo_m_co_01 geo_m_co_01 geo_m_st_01 geo_m_st_01 geo_m_zip_01 geo_m_zip_01 geo_m_quality_01 geo_m_quality_01 geo_m_impute_01 geo_m_impute_01 geo_m_st_imp_zip_01 geo_m_st_imp_zip_01 geo_m_co_imp_zip_01 geo_m_co_imp_zip_01 geo_m_zip_imp_zip_01 geo_m_zip_imp_zip_01 geo_m_co_02 geo_m_co_02 geo_m_st_02 geo_m_st_02 geo_m_zip_02 geo_m_zip_02 geo_m_quality_02 geo_m_quality_02 geo_m_impute_02 geo_m_impute_02 geo_m_st_imp_zip_02 geo_m_st_imp_zip_02 geo_m_co_imp_zip_02 geo_m_co_imp_zip_02 geo_m_zip_imp_zip_02 geo_m_zip_imp_zip_02 geo_m_co_03 geo_m_co_03 geo_m_st_03 geo_m_st_03 geo_m_zip_03 geo_m_zip_03 geo_m_quality_03 geo_m_quality_03 geo_m_impute_03 geo_m_impute_03 geo_m_st_imp_zip_03 geo_m_st_imp_zip_03 geo_m_co_imp_zip_03 geo_m_co_imp_zip_03 geo_m_zip_imp_zip_03 geo_m_zip_imp_zip_03 geo_m_co_04 geo_m_co_04 geo_m_st_04 geo_m_st_04 geo_m_zip_04 geo_m_zip_04 geo_m_quality_04 geo_m_quality_04 geo_m_impute_04 geo_m_impute_04 geo_m_st_imp_zip_04 geo_m_st_imp_zip_04 geo_m_co_imp_zip_04 geo_m_co_imp_zip_04 geo_m_zip_imp_zip_04 geo_m_zip_imp_zip_04 geo_m_co_05 geo_m_co_05 geo_m_st_05 geo_m_st_05 geo_m_zip_05 geo_m_zip_05 geo_m_quality_05 geo_m_quality_05 geo_m_impute_05 geo_m_impute_05 geo_m_st_imp_zip_05 geo_m_st_imp_zip_05 geo_m_co_imp_zip_05 geo_m_co_imp_zip_05 geo_m_zip_imp_zip_05 geo_m_zip_imp_zip_05 geo_m_co_06 geo_m_co_06 geo_m_st_06 geo_m_st_06 geo_m_zip_06 geo_m_zip_06 geo_m_quality_06 geo_m_quality_06 geo_m_impute_06 geo_m_impute_06 geo_m_st_imp_zip_06 geo_m_st_imp_zip_06 geo_m_co_imp_zip_06 geo_m_co_imp_zip_06 geo_m_zip_imp_zip_06 geo_m_zip_imp_zip_06 QNAME W/SURVEY YEAR Variable name ================== ===================== cv_interview_date_d_1997 cv_interview_date_d_1997 cv_interview_date_m_1997 cv_interview_date_m_1997 cv_interview_date_y_1997 cv_interview_date_y_1997 geo01_1997 geo01_1997 geo02_1997 geo02_1997 rzip_1997 rzip_1997 cv_interview_date~d_1998 cv_interview_date_d_1998 cv_interview_date~m_1998 cv_interview_date_m_1998 cv_interview_date~y_1998 cv_interview_date_y_1998 geo01_1998 geo01_1998 geo02_1998 geo02_1998 rzip_1998 rzip_1998 yloc-120~000007_1999 $ yloc_120_000007_1999 cv_interview_date~d_1999 cv_interview_date_d_1999 cv_interview_date~m_1999 cv_interview_date_m_1999 cv_interview_date~y_1999 cv_interview_date_y_1999 rzip_1999 rzip_1999 geo01_1999 geo01_1999 geo02_1999 geo02_1999 yloc-120~000007_2000 $ yloc_120_000007_2000 cv_interview_date~d_2000 cv_interview_date_d_2000 cv_interview_date~m_2000 cv_interview_date_m_2000 cv_interview_date~y_2000 cv_interview_date_y_2000 rzip_2000 rzip_2000 geo01_2000 geo01_2000 geo02_2000 geo02_2000 yloc-120~000007_2001 $ yloc_120_000007_2001 yloc-120~000010_2001 $ yloc_120_000010_2001 cv_interview_date~d_2001 cv_interview_date_d_2001 cv_interview_date~m_2001 cv_interview_date_m_2001 cv_interview_date~y_2001 cv_interview_date_y_2001 rzip_2001 rzip_2001 geo01_2001 geo01_2001 geo02_2001 geo02_2001 yloc-120~000007_2002 $ yloc_120_000007_2002 yloc-120~000010_2002 $ yloc_120_000010_2002 cv_interview_date~d_2002 cv_interview_date_d_2002 cv_interview_date~m_2002 cv_interview_date_m_2002 cv_interview_date~y_2002 cv_interview_date_y_2002 rzip_2002 rzip_2002 geo01_2002 geo01_2002 geo02_2002 geo02_2002 cv_interview_date~d_2003 cv_interview_date_d_2003 cv_interview_date~m_2003 cv_interview_date_m_2003 cv_interview_date~y_2003 cv_interview_date_y_2003 rzip_2003 rzip_2003 geo01_2003 geo01_2003 geo02_2003 geo02_2003 yloc-120~000007_2003 $ yloc_120_000007_2003 yloc-120~000010_2003 $ yloc_120_000010_2003 cv_interview_date~d_2004 cv_interview_date_d_2004 cv_interview_date~m_2004 cv_interview_date_m_2004 cv_interview_date~y_2004 cv_interview_date_y_2004 yloc-120~000010_2004 yloc_120_000010_2004 rzip_2004 rzip_2004 geo01_2004 geo01_2004 geo02_2004 geo02_2004 cv_interview_date~d_2005 cv_interview_date_d_2005 cv_interview_date~m_2005 cv_interview_date_m_2005 cv_interview_date~y_2005 cv_interview_date_y_2005 rzip_2005 rzip_2005 geo01_2005 geo01_2005 geo02_2005 geo02_2005 yloc-120~000010_2005 yloc_120_000010_2005 cv_interview_date~d_2006 cv_interview_date_d_2006 cv_interview_date~m_2006 cv_interview_date_m_2006 cv_interview_date~y_2006 cv_interview_date_y_2006 rzip_2006 rzip_2006 geo01_2006 geo01_2006 geo02_2006 geo02_2006 yloc-120~000010_2006 yloc_120_000010_2006 rzip_2007 rzip_2007 geo01_2007 geo01_2007 geo02_2007 geo02_2007 cv_interview_date~d_2007 cv_interview_date_d_2007 cv_interview_date~m_2007 cv_interview_date_m_2007 cv_interview_date~y_2007 cv_interview_date_y_2007 yhhi_loc_120_000010_2007 yhhi_loc_120_000010_2007 yloc-120~000010_2007 yloc_120_000010_2007 rzip_2008 rzip_2008 geo01_2008 geo01_2008 geo02_2008 geo02_2008 cv_interview_date~d_2008 cv_interview_date_d_2008 cv_interview_date~m_2008 cv_interview_date_m_2008 cv_interview_date~y_2008 cv_interview_date_y_2008 yhhi_loc-120~000010_2008 yhhi_loc_120_000010_2008 yloc-120~000010_2008 yloc_120_000010_2008 cv_interview_date~d_2009 cv_interview_date_d_2009 cv_interview_date~m_2009 cv_interview_date_m_2009 cv_interview_date~y_2009 cv_interview_date_y_2009 rzip_2009 rzip_2009 geo01_2009 geo01_2009 geo02_2009 geo02_2009 yhhi-loc-120~000010_2009 yhhi_loc_120_000010_2009 cv_interview_date~d_2010 cv_interview_date_d_2010 cv_interview_date~m_2010 cv_interview_date_m_2010 cv_interview_date~y_2010 cv_interview_date_y_2010 rzip_2010 rzip_2010 geo01_2010 geo01_2010 geo02_2010 geo02_2010 yhhi-loc-120~000010_2010 yhhi_loc_120_000010_2010 cv_interview_date~d_2011 cv_interview_date_d_2011 cv_interview_date~m_2011 cv_interview_date_m_2011 cv_interview_date~y_2011 cv_interview_date_y_2011 rzip_2011 rzip_2011 geo01_2011 geo01_2011 geo02_2011 geo02_2011 yhhi-loc-120~000010_2011 yhhi_loc_120_000010_2011 cv_interview_date~d_2013 cv_interview_date_d_2013 cv_interview_date~m_2013 cv_interview_date_m_2013 cv_interview_date~y_2013 cv_interview_date_y_2013 rzip_2013 rzip_2013 geo01_2013 geo01_2013 geo02_2013 geo02_2013 yhhi-loc-120~000010_2013 yhhi_loc_120_000010_2013 cv_interview_date~d_2015 cv_interview_date_d_2015 cv_interview_date~m_2015 cv_interview_date_m_2015 cv_interview_date~y_2015 cv_interview_date_y_2015 rzip_2015 rzip_2015 geo01_2015 geo01_2015 geo02_2015 geo02_2015 yhhi-loc-120~000010_2015 yhhi_loc_120_000010_2015 cv_interview_date~d_2017 cv_interview_date_d_2017 cv_interview_date~m_2017 cv_interview_date_m_2017 cv_interview_date~y_2017 cv_interview_date_y_2017 rzip_2017 rzip_2017 geo01_2017 geo01_2017 geo02_2017 geo02_2017 yhhi-loc-120~000010_2017 yhhi_loc_120_000010_2017 cv_interview_date~m_2019 cv_interview_date_m_2019 cv_interview_date~y_2019 cv_interview_date_y_2019 rzip_2019 rzip_2019 geo01_2019 geo01_2019 geo02_2019 geo02_2019 yhhi-loc-120~000010_2019 yhhi_loc_120_000010_2019 cv_interview_date~m_2021 cv_interview_date_m_2021 cv_interview_date~y_2021 cv_interview_date_y_2021 rzip_2021 rzip_2021 geo01_2021 geo01_2021 geo02_2021 geo02_2021 yhhi-loc-120~000010_2021 yhhi_loc_120_000010_2021 =================================================================================================== if (missing(geo_m_co_01)) then geo_m_co_01 = -4; if (missing(geo_m_st_01)) then geo_m_st_01 = -4; if (missing(geo_m_zip_01)) then geo_m_zip_01 = -4; if (missing(country_1)) then country_1 = -4; if (missing(geo_m_quality_01)) then geo_m_quality_01 = -4; if (missing(geo_m_impute_01)) then geo_m_impute_01 = -4; if (missing(geo_m_st_imp_zip_01)) then geo_m_st_imp_zip_01 = -4; if (missing(geo_m_co_imp_zip_01)) then geo_m_co_imp_zip_01 = -4; if (missing(geo_m_zip_imp_zip_01)) then geo_m_zip_imp_zip_01 = -4; if (missing(geo_m_co_02)) then geo_m_co_02 = -4; if (missing(geo_m_st_02)) then geo_m_st_02 = -4; if (missing(geo_m_zip_02)) then geo_m_zip_02 = -4; if (missing(country_2)) then country_2 = -4; if (missing(geo_m_quality_02)) then geo_m_quality_02 = -4; if (missing(geo_m_impute_02)) then geo_m_impute_02 = -4; if (missing(geo_m_st_imp_zip_02)) then geo_m_st_imp_zip_02 = -4; if (missing(geo_m_co_imp_zip_02)) then geo_m_co_imp_zip_02 = -4; if (missing(geo_m_zip_imp_zip_02)) then geo_m_zip_imp_zip_02 = -4; if (missing(geo_m_co_03)) then geo_m_co_03 = -4; if (missing(geo_m_st_03)) then geo_m_st_03 = -4; if (missing(geo_m_zip_03)) then geo_m_zip_03 = -4; if (missing(country_3)) then country_3 = -4; if (missing(geo_m_quality_03)) then geo_m_quality_03 = -4; if (missing(geo_m_impute_03)) then geo_m_impute_03 = -4; if (missing(geo_m_st_imp_zip_03)) then geo_m_st_imp_zip_03 = -4; if (missing(geo_m_co_imp_zip_03)) then geo_m_co_imp_zip_03 = -4; if (missing(geo_m_zip_imp_zip_03)) then geo_m_zip_imp_zip_03 = -4; if (missing(geo_m_co_04)) then geo_m_co_04 = -4; if (missing(geo_m_st_04)) then geo_m_st_04 = -4; if (missing(geo_m_zip_04)) then geo_m_zip_04 = -4; if (missing(country_4)) then country_4 = -4; if (missing(geo_m_quality_04)) then geo_m_quality_04 = -4; if (missing(geo_m_impute_04)) then geo_m_impute_04 = -4; if (missing(geo_m_st_imp_zip_04)) then geo_m_st_imp_zip_04 = -4; if (missing(geo_m_co_imp_zip_04)) then geo_m_co_imp_zip_04 = -4; if (missing(geo_m_zip_imp_zip_04)) then geo_m_zip_imp_zip_04 = -4; if (missing(geo_m_co_05)) then geo_m_co_05 = -4; if (missing(geo_m_st_05)) then geo_m_st_05 = -4; if (missing(geo_m_zip_05)) then geo_m_zip_05 = -4; if (missing(country_5)) then country_5 = -4; if (missing(geo_m_quality_05)) then geo_m_quality_05 = -4; if (missing(geo_m_impute_05)) then geo_m_impute_05 = -4; if (missing(geo_m_st_imp_zip_05)) then geo_m_st_imp_zip_05 = -4; if (missing(geo_m_co_imp_zip_05)) then geo_m_co_imp_zip_05 = -4; if (missing(geo_m_zip_imp_zip_05)) then geo_m_zip_imp_zip_05 = -4; if (missing(geo_m_co_06)) then geo_m_co_06 = -4; if (missing(geo_m_st_06)) then geo_m_st_06 = -4; if (missing(geo_m_zip_06)) then geo_m_zip_06 = -4; if (missing(country_6)) then country_6 = -4; if (missing(geo_m_quality_06)) then geo_m_quality_06 = -4; if (missing(geo_m_impute_06)) then geo_m_impute_06 = -4; if (missing(geo_m_st_imp_zip_06)) then geo_m_st_imp_zip_06 = -4; if (missing(geo_m_co_imp_zip_06)) then geo_m_co_imp_zip_06 = -4; if (missing(geo_m_zip_imp_zip_06)) then geo_m_zip_imp_zip_06 = -4; if (any_move_scc_sdli = -5) then do; geo_m_co_01 = -5; geo_m_st_01 = -5; geo_m_zip_01 = -5; country_1 = -5; geo_m_quality_01 = -5; geo_m_impute_01 = -5; geo_m_st_imp_zip_01 = -5; geo_m_co_imp_zip_01 = -5; geo_m_zip_imp_zip_01 = -5; geo_m_co_02 = -5; geo_m_st_02 = -5; geo_m_zip_02 = -5; country_2 = -5; geo_m_quality_02 = -5; geo_m_impute_02 = -5; geo_m_st_imp_zip_02 = -5; geo_m_co_imp_zip_02 = -5; geo_m_zip_imp_zip_02 = -5; geo_m_co_03 = -5; geo_m_st_03 = -5; geo_m_zip_03 = -5; country_3 = -5; geo_m_quality_03 = -5; geo_m_impute_03 = -5; geo_m_st_imp_zip_03 = -5; geo_m_co_imp_zip_03 = -5; geo_m_zip_imp_zip_03 = -5; geo_m_co_05 = -5; geo_m_st_05 = -5; geo_m_zip_05 = -5; country_5 = -5; geo_m_quality_05 = -5; geo_m_impute_05 = -5; geo_m_st_imp_zip_05 = -5; geo_m_co_imp_zip_05 = -5; geo_m_zip_imp_zip_05 = -5; geo_m_co_06 = -5; geo_m_st_06 = -5; geo_m_zip_06 = -5; country_6 = -5; geo_m_quality_06 = -5; geo_m_impute_06 = -5; geo_m_st_imp_zip_06 = -5; geo_m_co_imp_zip_06 = -5; geo_m_zip_imp_zip_06 = -5; end; if (geo_m_st_01 = 0) then geo_m_st_01 = -4; if (geo_m_st_02 = 0) then geo_m_st_02 = -4; if (geo_m_st_03 = 0) then geo_m_st_03 = -4; if (geo_m_st_04 = 0) then geo_m_st_04 = -4; if (geo_m_st_05 = 0) then geo_m_st_05 = -4; if (geo_m_st_06 = 0) then geo_m_st_06 = -4; county_dli = -4; state_dli = -4; zip_dli = -4; country_dli = -4; dli_year = -4; if (cv_interview_date_y_2019 > 0 ) then do; dli_year = 2019; county_dli = geo01_2019; state_dli = geo02_2019; zip_dli = rzip_2019; country_dli = yhhi_loc_120_000010_2019; end; else if (cv_interview_date_y_2017 > 0) then do; dli_year = 2017; county_dli = geo01_2017; state_dli = geo02_2017; zip_dli = rzip_2017; country_dli = yhhi_loc_120_000010_2017; end; else if (cv_interview_date_y_2015 > 0) then do; dli_year = 2015; county_dli = geo01_2015; state_dli = geo02_2015; zip_dli = rzip_2015; country_dli = yhhi_loc_120_000010_2015; end; else if (cv_interview_date_y_2013 > 0) then do; dli_year = 2013; county_dli = geo01_2013; state_dli = geo02_2013; zip_dli = rzip_2013; country_dli = yhhi_loc_120_000010_2013; end; else if (cv_interview_date_y_2011 > 0) then do; dli_year = 2011; county_dli = geo01_2011; state_dli = geo02_2011; zip_dli = rzip_2011; country_dli = yhhi_loc_120_000010_2011; end; else if (cv_interview_date_y_2010 > 0) then do; dli_year = 2010; county_dli = geo01_2010; state_dli = geo02_2010; zip_dli = rzip_2010; country_dli = yhhi_loc_120_000010_2010; end; else if (cv_interview_date_y_2009 > 0) then do; dli_year = 2009; county_dli = geo01_2009; state_dli = geo02_2009; zip_dli = rzip_2009; country_dli = yhhi_loc_120_000010_2009; end; else if (cv_interview_date_y_2008 > 0) then do; dli_year = 2008; county_dli = geo01_2008; state_dli = geo02_2008; zip_dli = rzip_2008; country_dli = yhhi_loc_120_000010_2008; end; else if (cv_interview_date_y_2007 > 0) then do; dli_year = 2007; county_dli = geo01_2007; state_dli = geo02_2007; zip_dli = rzip_2007; country_dli = yhhi_loc_120_000010_2007; end; else if (cv_interview_date_y_2006 > 0) then do; dli_year = 2006; county_dli = geo01_2006; state_dli = geo02_2006; zip_dli = rzip_2006; country_dli = yloc_120_000010_2006; end; else if (cv_interview_date_y_2005 > 0) then do; dli_year = 2005; county_dli = geo01_2005; state_dli = geo02_2005; zip_dli = rzip_2005; country_dli = yloc_120_000010_2005; end; else if (cv_interview_date_y_2004 > 0) then do; dli_year = 2004; county_dli = geo01_2004; state_dli = geo02_2004; zip_dli = rzip_2004; country_dli = yloc_120_000010_2004; end; else if (cv_interview_date_y_2003 > 0) then do; dli_year = 2003; county_dli = geo01_2003; state_dli = geo02_2003; zip_dli = rzip_2003; country_dli = res_countryn_2003; end; else if (cv_interview_date_y_2002 > 0) then do; dli_year = 2002; county_dli = geo01_2002; state_dli = geo02_2002; zip_dli = rzip_2002; country_dli = res_countryn_2002; end; else if (cv_interview_date_y_2001 > 0) then do; dli_year = 2001; county_dli = geo01_2001; state_dli = geo02_2001; zip_dli = rzip_2001; country_dli = res_countryn_2001; end; else if (cv_interview_date_y_2000 > 0) then do; dli_year = 2000; county_dli = geo01_2000; state_dli = geo02_2000; zip_dli = rzip_2000; country_dli = res_countryn_2000; end; else if (cv_interview_date_y_1999 > 0) then do; dli_year = 1999; county_dli = geo01_1999; state_dli = geo02_1999; zip_dli = rzip_1999; country_dli = res_countryn_1999; end; cv_migrate_01 = -4; cv_migrate_02 = -4; cv_migrate_03 = -4; cv_migrate_04 = -4; cv_migrate_05 = -4; cv_migrate_06 = -4; *compute cv_migrate_01; if (any_move_scc_sdli = -5) then cv_migrate_01 = -5; *same county movers #1; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & geo_m_st_01 = state_dli & geo_m_co_01 > -4 & geo_m_co_01 = county_dli) then cv_migrate_01 = 1; *same state different county movers #1; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & geo_m_st_01 = state_dli & geo_m_co_01 in(-1, -2, -3) & geo_m_co_01 ~= county_dli) then cv_migrate_01 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & geo_m_st_01 = state_dli & geo_m_co_01 > -4 & geo_m_co_01 ~= county_dli) then cv_migrate_01 = 2; *different state movers #1; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & state_dli > -4 & geo_m_st_01 ~= state_dli & geo_m_co_01 > -4) then cv_migrate_01 = 3; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & geo_m_st_01 ~= state_dli & geo_m_co_01 = -4 & geo_m_st_01 = 72) then cv_migrate_01 = 3; *international movers #1; else if (any_move_scc_sdli = 1 & state_dli > -4 & county_dli > -4 & country_1 in(-1, -2, -3, -4)) then cv_migrate_01 = -3; else if (any_move_scc_sdli = 1 & state_dli > -4 & county_dli > -4 & country_1 > -4 & country_1 ~= 300) then cv_migrate_01 = 4; else if (any_move_scc_sdli = 1 & state_dli = -4 & county_dli = -4 & country_dli > -4 & country_dli ~= 300 & country_1 > -4 & country_1 ~= 300) then cv_migrate_01 = 4; else if (any_move_scc_sdli = 1 & country_dli > -4 & country_dli ~= 300 & geo_m_co_01 > -4 & geo_m_st_01 > -4) then cv_migrate_01 = 4; *remaining -3s #1; else if (any_move_scc_sdli = 1 & state_dli = -4 & county_dli = -4 & country_dli = -4 & country_1 > -4 & country_1 ~= 300) then cv_migrate_01 = -3; else if (any_move_scc_sdli = 1 & state_dli = -4 & county_dli = -4 & (country_dli = -4 | country_dli = 300) & geo_m_st_01 > -4 & geo_m_co_01 > -4) then cv_migrate_01 = -3; else if (any_move_scc_sdli = 1 & (geo_m_st_01 in(-1, -2, -3) | geo_m_co_01 in(-1, -2, -3))) then cv_migrate_01 = -3; *compute cv_migrate_02; if (any_move_scc_sdli = -5) then cv_migrate_02 = -5; *same county movers #2; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_st_01 > -4 & geo_m_st_02 = geo_m_st_01 & geo_m_co_02 > -4 & geo_m_co_02 = geo_m_co_01) then cv_migrate_02 = 1; *same state different county movers #2; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_st_01 > -4 & geo_m_st_02 = geo_m_st_01 & (geo_m_co_01 in(-1, -2, -3) | geo_m_co_02 in(-1, -2, -3))) then cv_migrate_02 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_st_01 > -4 & geo_m_st_02 = geo_m_st_01 & geo_m_co_02 > -4 & geo_m_co_02 ~= geo_m_co_01) then cv_migrate_02 = 2; *different state movers #2; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_st_01 > -4 & geo_m_st_02 ~= geo_m_st_01 & geo_m_co_02 > -4 & (country_1 in(-2, -4) | country_1 = 300)) then cv_migrate_02 = 3; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_st_02 ~= geo_m_st_01 & geo_m_co_02 = -4 & geo_m_st_02 = 72) then cv_migrate_02 = 3; *international movers #2; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & geo_m_co_01 > -4 & country_2 in(-1, -2, -3)) then cv_migrate_02 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_01 > -4 & geo_m_co_01 > -4 & country_2 > -4 & country_2 ~= 300) then cv_migrate_02 = 4; else if (any_move_scc_sdli = 1 & geo_m_st_01 = -4 & geo_m_co_01 = -4 & country_1 > -4 & country_1 ~= 300 & country_2 > -4 & country_2 ~= 300) then cv_migrate_02 = 4; else if (any_move_scc_sdli = 1 & country_1 > -4 & country_1 ~= 300 & geo_m_co_02 > -4 & geo_m_st_02 > -4) then cv_migrate_02 = 4; else if (any_move_scc_sdli = 1 & country_1 > -4 & country_1 ~= 300 & country_2 > -4 & country_2 ~= 300 & geo_m_co_02 in(-2, -4) & geo_m_st_02 in(-2, -4)) then cv_migrate_02 = 4; else if (any_move_scc_sdli = 1 & country_1 > -4 & country_1 ~= 300 & country_2 > -4 & country_2 ~= 300 & geo_m_co_02 in(-2, -4) & geo_m_st_02 = 99) then cv_migrate_02 = 4; *remaining -3s #2; else if (any_move_scc_sdli = 1 & geo_m_st_01 = -4 & geo_m_co_01 = -4 & country_1 = -4 & country_2 > -4 & country_2 ~= 300) then cv_migrate_02 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_01 = -4 & geo_m_co_01 = -4 & (country_1 = -4 | country_1 = 300) & geo_m_st_02 > -4 & geo_m_co_02 > -4) then cv_migrate_02 = -3; else if (any_move_scc_sdli = 1 & (geo_m_st_02 in(-1, -2, -3) | geo_m_co_02 in(-1, -2, -3))) then cv_migrate_02 = -3; *compute cv_migrate_03; if (any_move_scc_sdli = -5) then cv_migrate_03 = -5; *same county movers #3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_st_02 > -4 & geo_m_st_03 = geo_m_st_02 & geo_m_co_03 > -4 & geo_m_co_03 = geo_m_co_02) then cv_migrate_03 = 1; *same state different county movers #3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_st_02 > -4 & geo_m_st_03 = geo_m_st_02 & (geo_m_co_02 in(-1, -2, -3) | geo_m_co_03 in(-1, -2, -3))) then cv_migrate_03 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_st_02 > -4 & geo_m_st_03 = geo_m_st_02 & geo_m_co_03 > -4 & geo_m_co_03 ~= geo_m_co_02) then cv_migrate_03 = 2; *different state movers #3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_st_02 = -2 & geo_m_co_03 > -4 & geo_m_co_02 > -4) then cv_migrate_03 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_st_02 > -4 & geo_m_st_03 ~= geo_m_st_02 & geo_m_co_03 > -4 & (country_2 in(-2, -4) | country_2 = 300)) then cv_migrate_03 = 3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_st_03 ~= geo_m_st_02 & geo_m_co_02 = -4 & geo_m_st_03 = 72) then cv_migrate_03 = 3; *international movers #3; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_co_02 > -4 & country_3 in(-1, -2, -3)) then cv_migrate_03 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_02 > -4 & geo_m_co_02 > -4 & country_3 > -4 & country_3 ~= 300) then cv_migrate_03 = 4; else if (any_move_scc_sdli = 1 & geo_m_st_02 = -4 & geo_m_co_02 = -4 & country_2 > -4 & country_2 ~= 300 & country_3 > -4 & country_3 ~= 300) then cv_migrate_03 = 4; else if (any_move_scc_sdli = 1 & country_2 > -4 & country_2 ~= 300 & geo_m_co_03 > -4 & geo_m_st_03 > -4) then cv_migrate_03 = 4; else if (any_move_scc_sdli = 1 & country_2 > -4 & country_2 ~= 300 & country_3 > -4 & country_3 ~= 300 & geo_m_co_03 in(-2, -4) & geo_m_st_03 in(-2, -4)) then cv_migrate_03 = 4; else if (any_move_scc_sdli = 1 & country_2 > -4 & country_2 ~= 300 & country_3 > -4 & country_3 ~= 300 & geo_m_co_03 in(-2, -4) & geo_m_st_03 = 99) then cv_migrate_03 = 4; *remaining -3s #3; else if (any_move_scc_sdli = 1 & geo_m_st_02 = -4 & geo_m_co_02 = -4 & country_2 = -4 & country_3 > -4 & country_3 ~= 300) then cv_migrate_03 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_02 = -4 & geo_m_co_02 = -4 & (country_2 = -4 | country_2 = 300) & geo_m_st_03 > -4 & geo_m_co_03 > -4) then cv_migrate_03 = -3; else if (any_move_scc_sdli = 1 & (geo_m_st_03 in(-1, -2, -3) | geo_m_co_03 in(-1, -2, -3))) then cv_migrate_03 = -3; *compute cv_migrate_04; if (any_move_scc_sdli = -5) then cv_migrate_04 = -5; *same county movers #4; else if (any_move_scc_sdli = 1 & geo_m_st_04 > -4 & geo_m_st_03 > -4 & geo_m_st_04 = geo_m_st_03 & geo_m_co_04 > -4 & geo_m_co_04 = geo_m_co_03) then cv_migrate_04 = 1; *same state different county movers #4; else if (any_move_scc_sdli = 1 & geo_m_st_04 > -4 & geo_m_st_03 > -4 & geo_m_st_04 = geo_m_st_03 & (geo_m_co_03 in(-1, -2, -3) | geo_m_co_04 in(-1, -2, -3))) then cv_migrate_04 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_04 > -4 & geo_m_st_03 > -4 & geo_m_st_04 = geo_m_st_03 & geo_m_co_04 > -4 & geo_m_co_04 ~= geo_m_co_03) then cv_migrate_04 = 2; *different state movers #4; else if (any_move_scc_sdli = 1 & geo_m_st_04 > -4 & geo_m_st_03 = -2 & geo_m_co_04 > -4 & geo_m_co_03 > -4) then cv_migrate_04 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_04 > -4 & geo_m_st_03 > -4 & geo_m_st_04 ~= geo_m_st_03 & geo_m_co_04 > -4 & (country_3 in(-2, -4) | country_3 = 300)) then cv_migrate_04 = 3; else if (any_move_scc_sdli = 1 & geo_m_st_04 > -4 & geo_m_st_04 ~= geo_m_st_03 & geo_m_co_03 = -4 & geo_m_st_04 = 72) then cv_migrate_04 = 3; *international movers #4; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_co_03 > -4 & country_4 in(-1, -2, -3)) then cv_migrate_04 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_03 > -4 & geo_m_co_03 > -4 & country_4 > -4 & country_4 ~= 300) then cv_migrate_04 = 4; else if (any_move_scc_sdli = 1 & geo_m_st_03 = -4 & geo_m_co_03 = -4 & country_4 > -4 & country_3 ~= 300 & country_4 > -4 & country_4 ~= 300) then cv_migrate_04 = 4; else if (any_move_scc_sdli = 1 & country_3 > -4 & country_3 ~= 300 & geo_m_co_04 > -4 & geo_m_st_04 > -4) then cv_migrate_04 = 4; else if (any_move_scc_sdli = 1 & country_3 > -4 & country_3 ~= 300 & country_4 > -4 & country_4 ~= 300 & geo_m_co_04 in(-2, -4) & geo_m_st_04 in(-2, -4)) then cv_migrate_04 = 4; else if (any_move_scc_sdli = 1 & country_3 > -4 & country_3 ~= 300 & country_4 > -4 & country_4 ~= 300 & geo_m_co_04 in(-2, -4) & geo_m_st_04 = 99) then cv_migrate_04 = 4; *remaining -3s #4; else if (any_move_scc_sdli = 1 & geo_m_st_03 = -4 & geo_m_co_03 = -4 & country_3 = -4 & country_4 > -4 & country_4 ~= 300) then cv_migrate_04 = -3; else if (any_move_scc_sdli = 1 & geo_m_st_03 = -4 & geo_m_co_04 = -4 & (country_3 = -4 | country_3 = 300) & geo_m_st_04 > -4 & geo_m_co_04 > -4) then cv_migrate_04 = -3; else if (any_move_scc_sdli = 1 & (geo_m_st_04 in(-1, -2, -3) | geo_m_co_04 in(-1, -2, -3))) then cv_migrate_04 = -3;