* The program is to create "regular hours worked per week" for round 20. created variables: CV_HRS_PER_WEEK.01-CV_HRS_PER_WEEK.10 (HOURS01-HOURS10); * If a job lasts less than or equal to 13 weeks, we use the hours when job is started. If the job lasts more than 13 weeks, we use the hours either when the job is ended or the most recently reported hours; * When the stop year for a job is an invalid skip, rather than -3 the created variables, we use the "hours worked per week" most recently reported by the respondents instead; ****************************************************************************************** PUBID = PUBID YEMP_UID.01_1997 = r1UID1 YEMP_UID.02_1997 = r1UID2 YEMP_UID.03_1997 = r1UID3 YEMP_UID.04_1997 = r1UID4 YEMP_UID.05_1997 = r1UID5 YEMP_UID.06_1997 = r1UID6 YEMP_UID.07_1997 = r1UID7 CV_HRS_PER_WEEK.01_1997 = r1HRS1 CV_HRS_PER_WEEK.02_1997 = r1HRS2 CV_HRS_PER_WEEK.03_1997 = r1HRS3 CV_HRS_PER_WEEK.04_1997 = r1HRS4 CV_HRS_PER_WEEK.05_1997 = r1HRS5 CV_HRS_PER_WEEK.06_1997 = r1HRS6 CV_HRS_PER_WEEK.07_1997 = r1HRS7 YEMP_UID.01_1998 = r2UID1 YEMP_UID.02_1998 = r2UID2 YEMP_UID.03_1998 = r2UID3 YEMP_UID.04_1998 = r2UID4 YEMP_UID.05_1998 = r2UID5 YEMP_UID.06_1998 = r2UID6 YEMP_UID.07_1998 = r2UID7 YEMP_UID.08_1998 = r2UID8 YEMP_UID.09_1998 = r2UID9 CV_HRS_PER_WEEK.01_1998 = r2HRS1 CV_HRS_PER_WEEK.02_1998 = r2HRS2 CV_HRS_PER_WEEK.03_1998 = r2HRS3 CV_HRS_PER_WEEK.04_1998 = r2HRS4 CV_HRS_PER_WEEK.05_1998 = r2HRS5 CV_HRS_PER_WEEK.06_1998 = r2HRS6 CV_HRS_PER_WEEK.07_1998 = r2HRS7 CV_HRS_PER_WEEK.08_1998 = r2HRS8 CV_HRS_PER_WEEK.09_1998 = r2HRS9 YEMP_UID.01_1999 = r3UID1 YEMP_UID.02_1999 = r3UID2 YEMP_UID.03_1999 = r3UID3 YEMP_UID.04_1999 = r3UID4 YEMP_UID.05_1999 = r3UID5 YEMP_UID.06_1999 = r3UID6 YEMP_UID.07_1999 = r3UID7 YEMP_UID.08_1999 = r3UID8 YEMP_UID.09_1999 = r3UID9 CV_HRS_PER_WEEK.01_1999 = r3HRS1 CV_HRS_PER_WEEK.02_1999 = r3HRS2 CV_HRS_PER_WEEK.03_1999 = r3HRS3 CV_HRS_PER_WEEK.04_1999 = r3HRS4 CV_HRS_PER_WEEK.05_1999 = r3HRS5 CV_HRS_PER_WEEK.06_1999 = r3HRS6 CV_HRS_PER_WEEK.07_1999 = r3HRS7 CV_HRS_PER_WEEK.08_1999 = r3HRS8 CV_HRS_PER_WEEK.09_1999 = r3HRS9 YEMP_UID.01_2000 = r4UID1 YEMP_UID.02_2000 = r4UID2 YEMP_UID.03_2000 = r4UID3 YEMP_UID.04_2000 = r4UID4 YEMP_UID.05_2000 = r4UID5 YEMP_UID.06_2000 = r4UID6 YEMP_UID.07_2000 = r4UID7 YEMP_UID.08_2000 = r4UID8 YEMP_UID.09_2000 = r4UID9 CV_HRS_PER_WEEK.01_2000 = r4HRS1 CV_HRS_PER_WEEK.02_2000 = r4HRS2 CV_HRS_PER_WEEK.03_2000 = r4HRS3 CV_HRS_PER_WEEK.04_2000 = r4HRS4 CV_HRS_PER_WEEK.05_2000 = r4HRS5 CV_HRS_PER_WEEK.06_2000 = r4HRS6 CV_HRS_PER_WEEK.07_2000 = r4HRS7 CV_HRS_PER_WEEK.08_2000 = r4HRS8 CV_HRS_PER_WEEK.09_2000 = r4HRS9 YEMP_UID.01_2001 = r5UID1 YEMP_UID.02_2001 = r5UID2 YEMP_UID.03_2001 = r5UID3 YEMP_UID.04_2001 = r5UID4 YEMP_UID.05_2001 = r5UID5 YEMP_UID.06_2001 = r5UID6 YEMP_UID.07_2001 = r5UID7 YEMP_UID.08_2001 = r5UID8 CV_HRS_PER_WEEK.01_2001 = r5HRS1 CV_HRS_PER_WEEK.02_2001 = r5HRS2 CV_HRS_PER_WEEK.03_2001 = r5HRS3 CV_HRS_PER_WEEK.04_2001 = r5HRS4 CV_HRS_PER_WEEK.05_2001 = r5HRS5 CV_HRS_PER_WEEK.06_2001 = r5HRS6 CV_HRS_PER_WEEK.07_2001 = r5HRS7 CV_HRS_PER_WEEK.08_2001 = r5HRS8 YEMP_UID.01_2002 = r6UID01 YEMP_UID.02_2002 = r6UID02 YEMP_UID.03_2002 = r6UID03 YEMP_UID.04_2002 = r6UID04 YEMP_UID.05_2002 = r6UID05 YEMP_UID.06_2002 = r6UID06 YEMP_UID.07_2002 = r6UID07 YEMP_UID.08_2002 = r6UID08 YEMP_UID.09_2002 = r6UID09 YEMP_UID.10_2002 = r6UID10 YEMP_UID.11_2002 = r6UID11 CV_HRS_PER_WEEK.01_2002 = r6HRS01 CV_HRS_PER_WEEK.02_2002 = r6HRS02 CV_HRS_PER_WEEK.03_2002 = r6HRS03 CV_HRS_PER_WEEK.04_2002 = r6HRS04 CV_HRS_PER_WEEK.05_2002 = r6HRS05 CV_HRS_PER_WEEK.06_2002 = r6HRS06 CV_HRS_PER_WEEK.07_2002 = r6HRS07 CV_HRS_PER_WEEK.08_2002 = r6HRS08 CV_HRS_PER_WEEK.09_2002 = r6HRS09 CV_HRS_PER_WEEK.10_2002 = r6HRS10 CV_HRS_PER_WEEK.11_2002 = r6HRS11 CV_HRS_PER_WEEK.01_2003 = r7HRS01 CV_HRS_PER_WEEK.02_2003 = r7HRS02 CV_HRS_PER_WEEK.03_2003 = r7HRS03 CV_HRS_PER_WEEK.04_2003 = r7HRS04 CV_HRS_PER_WEEK.05_2003 = r7HRS05 CV_HRS_PER_WEEK.06_2003 = r7HRS06 CV_HRS_PER_WEEK.07_2003 = r7HRS07 CV_HRS_PER_WEEK.08_2003 = r7HRS08 CV_HRS_PER_WEEK.09_2003 = r7HRS09 CV_HRS_PER_WEEK.10_2003 = r7HRS10 YEMP_UID.01_2003 = r7UID01 YEMP_UID.02_2003 = r7UID02 YEMP_UID.03_2003 = r7UID03 YEMP_UID.04_2003 = r7UID04 YEMP_UID.05_2003 = r7UID05 YEMP_UID.06_2003 = r7UID06 YEMP_UID.07_2003 = r7UID07 YEMP_UID.08_2003 = r7UID08 YEMP_UID.09_2003 = r7UID09 YEMP_UID.10_2003 = r7UID10 CV_HRS_PER_WEEK.01_2004 = r8HRS1 CV_HRS_PER_WEEK.02_2004 = r8HRS2 CV_HRS_PER_WEEK.03_2004 = r8HRS3 CV_HRS_PER_WEEK.04_2004 = r8HRS4 CV_HRS_PER_WEEK.05_2004 = r8HRS5 CV_HRS_PER_WEEK.06_2004 = r8HRS6 CV_HRS_PER_WEEK.07_2004 = r8HRS7 YEMP_UID.01_2004 = r8UID1 YEMP_UID.02_2004 = r8UID2 YEMP_UID.03_2004 = r8UID3 YEMP_UID.04_2004 = r8UID4 YEMP_UID.05_2004 = r8UID5 YEMP_UID.06_2004 = r8UID6 YEMP_UID.07_2004 = r8UID7 CV_HRS_PER_WEEK.01_2005 = r9HRS1 CV_HRS_PER_WEEK.02_2005 = r9HRS2 CV_HRS_PER_WEEK.03_2005 = r9HRS3 CV_HRS_PER_WEEK.04_2005 = r9HRS4 CV_HRS_PER_WEEK.05_2005 = r9HRS5 CV_HRS_PER_WEEK.06_2005 = r9HRS6 CV_HRS_PER_WEEK.07_2005 = r9HRS7 CV_HRS_PER_WEEK.08_2005 = r9HRS8 CV_HRS_PER_WEEK.09_2005 = r9HRS9 YEMP_UID.01_2005 = r9UID1 YEMP_UID.02_2005 = r9UID2 YEMP_UID.03_2005 = r9UID3 YEMP_UID.04_2005 = r9UID4 YEMP_UID.05_2005 = r9UID5 YEMP_UID.06_2005 = r9UID6 YEMP_UID.07_2005 = r9UID7 YEMP_UID.08_2005 = r9UID8 YEMP_UID.09_2005 = r9UID9 CV_HRS_PER_WEEK.01_2006 = r10HRS1 CV_HRS_PER_WEEK.02_2006 = r10HRS2 CV_HRS_PER_WEEK.03_2006 = r10HRS3 CV_HRS_PER_WEEK.04_2006 = r10HRS4 CV_HRS_PER_WEEK.05_2006 = r10HRS5 CV_HRS_PER_WEEK.06_2006 = r10HRS6 CV_HRS_PER_WEEK.07_2006 = r10HRS7 CV_HRS_PER_WEEK.08_2006 = r10HRS8 CV_HRS_PER_WEEK.09_2006 = r10HRS9 YEMP_UID.01_2006 = r10UID1 YEMP_UID.02_2006 = r10UID2 YEMP_UID.03_2006 = r10UID3 YEMP_UID.04_2006 = r10UID4 YEMP_UID.05_2006 = r10UID5 YEMP_UID.06_2006 = r10UID6 YEMP_UID.07_2006 = r10UID7 YEMP_UID.08_2006 = r10UID8 YEMP_UID.09_2006 = r10UID9 CV_HRS_PER_WEEK.01_2007 = r11HRS1 CV_HRS_PER_WEEK.02_2007 = r11HRS2 CV_HRS_PER_WEEK.03_2007 = r11HRS3 CV_HRS_PER_WEEK.04_2007 = r11HRS4 CV_HRS_PER_WEEK.05_2007 = r11HRS5 CV_HRS_PER_WEEK.06_2007 = r11HRS6 CV_HRS_PER_WEEK.07_2007 = r11HRS7 CV_HRS_PER_WEEK.08_2007 = r11HRS8 YEMP_UID.01_2007 = r11UID1 YEMP_UID.02_2007 = r11UID2 YEMP_UID.03_2007 = r11UID3 YEMP_UID.04_2007 = r11UID4 YEMP_UID.05_2007 = r11UID5 YEMP_UID.06_2007 = r11UID6 YEMP_UID.07_2007 = r11UID7 YEMP_UID.08_2007 = r11UID8 CV_HRS_PER_WEEK.01_2008 = r12HRS1 CV_HRS_PER_WEEK.02_2008 = r12HRS2 CV_HRS_PER_WEEK.03_2008 = r12HRS3 CV_HRS_PER_WEEK.04_2008 = r12HRS4 CV_HRS_PER_WEEK.05_2008 = r12HRS5 CV_HRS_PER_WEEK.06_2008 = r12HRS6 CV_HRS_PER_WEEK.07_2008 = r12HRS7 CV_HRS_PER_WEEK.08_2008 = r12HRS8 YEMP_UID.01_2008 = r12UID1 YEMP_UID.02_2008 = r12UID2 YEMP_UID.03_2008 = r12UID3 YEMP_UID.04_2008 = r12UID4 YEMP_UID.05_2008 = r12UID5 YEMP_UID.06_2008 = r12UID6 YEMP_UID.07_2008 = r12UID7 YEMP_UID.08_2008 = r12UID8 CV_HRS_PER_WEEK.01_2009 = r13HRS1 CV_HRS_PER_WEEK.02_2009 = r13HRS2 CV_HRS_PER_WEEK.03_2009 = r13HRS3 CV_HRS_PER_WEEK.04_2009 = r13HRS4 CV_HRS_PER_WEEK.05_2009 = r13HRS5 CV_HRS_PER_WEEK.06_2009 = r13HRS6 CV_HRS_PER_WEEK.07_2009 = r13HRS7 CV_HRS_PER_WEEK.08_2009 = r13HRS8 CV_HRS_PER_WEEK.09_2009 = r13HRS9 YEMP_UID.01_2009 = r13UID1 YEMP_UID.02_2009 = r13UID2 YEMP_UID.03_2009 = r13UID3 YEMP_UID.04_2009 = r13UID4 YEMP_UID.05_2009 = r13UID5 YEMP_UID.06_2009 = r13UID6 YEMP_UID.07_2009 = r13UID7 YEMP_UID.08_2009 = r13UID8 YEMP_UID.09_2009 = r13UID9 CV_HRS_PER_WEEK.01_2010 = r14HRS1 CV_HRS_PER_WEEK.02_2010 = r14HRS2 CV_HRS_PER_WEEK.03_2010 = r14HRS3 CV_HRS_PER_WEEK.04_2010 = r14HRS4 CV_HRS_PER_WEEK.05_2010 = r14HRS5 CV_HRS_PER_WEEK.06_2010 = r14HRS6 CV_HRS_PER_WEEK.07_2010 = r14HRS7 CV_HRS_PER_WEEK.08_2010 = r14HRS8 CV_HRS_PER_WEEK.09_2010 = r14HRS9 YEMP_UID.01_2010 = r14UID1 YEMP_UID.02_2010 = r14UID2 YEMP_UID.03_2010 = r14UID3 YEMP_UID.04_2010 = r14UID4 YEMP_UID.05_2010 = r14UID5 YEMP_UID.06_2010 = r14UID6 YEMP_UID.07_2010 = r14UID7 YEMP_UID.08_2010 = r14UID8 YEMP_UID.09_2010 = r14UID9 CV_HRS_PER_WEEK.01_2011 = r15HRS01 CV_HRS_PER_WEEK.02_2011 = r15HRS02 CV_HRS_PER_WEEK.03_2011 = r15HRS03 CV_HRS_PER_WEEK.04_2011 = r15HRS04 CV_HRS_PER_WEEK.05_2011 = r15HRS05 CV_HRS_PER_WEEK.06_2011 = r15HRS06 CV_HRS_PER_WEEK.07_2011 = r15HRS07 CV_HRS_PER_WEEK.08_2011 = r15HRS08 CV_HRS_PER_WEEK.09_2011 = r15HRS09 CV_HRS_PER_WEEK.10_2011 = r15HRS10 CV_HRS_PER_WEEK.11_2011 = r15HRS11 CV_HRS_PER_WEEK.12_2011 = r15HRS12 CV_HRS_PER_WEEK.13_2011 = r15HRS13 YEMP_UID.01_2011 = r15UID01 YEMP_UID.02_2011 = r15UID02 YEMP_UID.03_2011 = r15UID03 YEMP_UID.04_2011 = r15UID04 YEMP_UID.05_2011 = r15UID05 YEMP_UID.06_2011 = r15UID06 YEMP_UID.07_2011 = r15UID07 YEMP_UID.08_2011 = r15UID08 YEMP_UID.09_2011 = r15UID09 YEMP_UID.10_2011 = r15UID10 YEMP_UID.11_2011 = r15UID11 YEMP_UID.12_2011 = r15UID12 YEMP_UID.13_2011 = r15UID13 CV_HRS_PER_WEEK.01_2013 = r16HRS01 CV_HRS_PER_WEEK.02_2013 = r16HRS02 CV_HRS_PER_WEEK.03_2013 = r16HRS03 CV_HRS_PER_WEEK.04_2013 = r16HRS04 CV_HRS_PER_WEEK.05_2013 = r16HRS05 CV_HRS_PER_WEEK.06_2013 = r16HRS06 CV_HRS_PER_WEEK.07_2013 = r16HRS07 CV_HRS_PER_WEEK.08_2013 = r16HRS08 CV_HRS_PER_WEEK.09_2013 = r16HRS09 CV_HRS_PER_WEEK.10_2013 = r16HRS10 YEMP_UID.01_2013 = r16UID01 YEMP_UID.02_2013 = r16UID02 YEMP_UID.03_2013 = r16UID03 YEMP_UID.04_2013 = r16UID04 YEMP_UID.05_2013 = r16UID05 YEMP_UID.06_2013 = r16UID06 YEMP_UID.07_2013 = r16UID07 YEMP_UID.08_2013 = r16UID08 YEMP_UID.09_2013 = r16UID09 YEMP_UID.10_2013 = r16UID10 CV_HRS_PER_WEEK.01_2015 = r17HRS01 CV_HRS_PER_WEEK.02_2015 = r17HRS02 CV_HRS_PER_WEEK.03_2015 = r17HRS03 CV_HRS_PER_WEEK.04_2015 = r17HRS04 CV_HRS_PER_WEEK.05_2015 = r17HRS05 CV_HRS_PER_WEEK.06_2015 = r17HRS06 CV_HRS_PER_WEEK.07_2015 = r17HRS07 CV_HRS_PER_WEEK.08_2015 = r17HRS08 CV_HRS_PER_WEEK.09_2015 = r17HRS09 CV_HRS_PER_WEEK.10_2015 = r17HRS10 CV_HRS_PER_WEEK.11_2015 = r17HRS11 CV_HRS_PER_WEEK.12_2015 = r17HRS12 YEMP_UID.01_2015 = r17UID01 YEMP_UID.02_2015 = r17UID02 YEMP_UID.03_2015 = r17UID03 YEMP_UID.04_2015 = r17UID04 YEMP_UID.05_2015 = r17UID05 YEMP_UID.06_2015 = r17UID06 YEMP_UID.07_2015 = r17UID07 YEMP_UID.08_2015 = r17UID08 YEMP_UID.09_2015 = r17UID09 YEMP_UID.10_2015 = r17UID10 YEMP_UID.11_2015 = r17UID11 YEMP_UID.12_2015 = r17UID12 CV_HRS_PER_WEEK.01_2017 = r18HRS01 CV_HRS_PER_WEEK.02_2017 = r18HRS02 CV_HRS_PER_WEEK.03_2017 = r18HRS03 CV_HRS_PER_WEEK.04_2017 = r18HRS04 CV_HRS_PER_WEEK.05_2017 = r18HRS05 CV_HRS_PER_WEEK.06_2017 = r18HRS06 CV_HRS_PER_WEEK.07_2017 = r18HRS07 CV_HRS_PER_WEEK.08_2017 = r18HRS08 CV_HRS_PER_WEEK.09_2017 = r18HRS09 CV_HRS_PER_WEEK.10_2017 = r18HRS10 CV_HRS_PER_WEEK.11_2017 = r18HRS11 CV_HRS_PER_WEEK.12_2017 = r18HRS12 CV_HRS_PER_WEEK.13_2017 = r18HRS13 CV_HRS_PER_WEEK.14_2017 = r18HRS14 CV_HRS_PER_WEEK.15_2017 = r18HRS15 YEMP_UID.01_2017 = r18UID01 YEMP_UID.02_2017 = r18UID02 YEMP_UID.03_2017 = r18UID03 YEMP_UID.04_2017 = r18UID04 YEMP_UID.05_2017 = r18UID05 YEMP_UID.06_2017 = r18UID06 YEMP_UID.07_2017 = r18UID07 YEMP_UID.08_2017 = r18UID08 YEMP_UID.09_2017 = r18UID09 YEMP_UID.10_2017 = r18UID10 YEMP_UID.11_2017 = r18UID11 YEMP_UID.12_2017 = r18UID12 YEMP_UID.13_2017 = r18UID13 YEMP_UID.14_2017 = r18UID14 YEMP_UID.15_2017 = r18UID15 CV_HRS_PER_WEEK.01_2019 = r19HRS01 CV_HRS_PER_WEEK.02_2019 = r19HRS02 CV_HRS_PER_WEEK.03_2019 = r19HRS03 CV_HRS_PER_WEEK.04_2019 = r19HRS04 CV_HRS_PER_WEEK.05_2019 = r19HRS05 CV_HRS_PER_WEEK.06_2019 = r19HRS06 CV_HRS_PER_WEEK.07_2019 = r19HRS07 CV_HRS_PER_WEEK.08_2019 = r19HRS08 CV_HRS_PER_WEEK.09_2019 = r19HRS09 CV_HRS_PER_WEEK.10_2019 = r19HRS10 CV_HRS_PER_WEEK.11_2019 = r19HRS11 YEMP_UID.01_2019 = r19UID01 YEMP_UID.02_2019 = r19UID02 YEMP_UID.03_2019 = r19UID03 YEMP_UID.04_2019 = r19UID04 YEMP_UID.05_2019 = r19UID05 YEMP_UID.06_2019 = r19UID06 YEMP_UID.07_2019 = r19UID07 YEMP_UID.08_2019 = r19UID08 YEMP_UID.09_2019 = r19UID09 YEMP_UID.10_2019 = r19UID10 YEMP_UID.11_2019 = r19UID11 YEMP-23901.01_2021 = E2390101 YEMP-23901.02_2021 = E2390102 YEMP-23901.03_2021 = E2390103 YEMP-23901.04_2021 = E2390104 YEMP-23901.05_2021 = E2390105 YEMP-23901.06_2021 = E2390106 YEMP-23901.07_2021 = E2390107 YEMP-23901.08_2021 = E2390108 YEMP-34402.01_2021 = E3440201 YEMP-34402.02_2021 = E3440202 YEMP-34402.03_2021 = E3440203 YEMP-34402.04_2021 = E3440204 YEMP-34402.05_2021 = E3440205 YEMP-34402.06_2021 = E3440206 YEMP-34428.01_2021 = E3442801 YEMP-34428.02_2021 = E3442802 YEMP-34428.03_2021 = E3442803 YEMP-37701.01_2021 = E3770101 YEMP-37701.02_2021 = E3770102 YEMP-37701.03_2021 = E3770103 YEMP-37701.04_2021 = E3770104 YEMP-37701.05_2021 = E3770105 YEMP-37701.06_2021 = E3770106 YEMP-37701.07_2021 = E3770107 YEMP-37701.08_2021 = E3770108 YEMP-37901B.01_2021 = E37901B01 YEMP-37901B.02_2021 = E37901B02 YEMP-37901B.03_2021 = E37901B03 YEMP-37901B.04_2021 = E37901B04 YEMP-37901B.05_2021 = E37901B05 YEMP-37901B.06_2021 = E37901B06 YEMP-37901B.07_2021 = E37901B07 YEMP-37901B.08_2021 = E37901B08 YEMP-38000B.01_2021 = E38000B01 YEMP-38000B.02_2021 = E38000B02 YEMP-38000B.03_2021 = E38000B03 YEMP-38000B.04_2021 = E38000B04 YEMP-38000B.05_2021 = E38000B05 YEMP-38000B.06_2021 = E38000B06 YEMP-38000B.07_2021 = E38000B07 YEMP-38000F.01_2021 = E38000F01 YEMP-38000F.02_2021 = E38000F02 YEMP-38000F.03_2021 = E38000F03 YEMP-38000F.04_2021 = E38000F04 YEMP-38000F.06_2021 = E38000F06 YEMP-38002.01_2021 = E3800201 YEMP-38002.02_2021 = E3800202 YEMP-38002.03_2021 = E3800203 YEMP-38002.04_2021 = E3800204 YEMP-38002.06_2021 = E3800206 YEMP-38101.01_2021 = E3810101 YEMP-38101.02_2021 = E3810102 YEMP-38101.03_2021 = E3810103 YEMP-38101.04_2021 = E3810104 YEMP-38101.05_2021 = E3810105 YEMP-38102.01_2021 = E3810201 YEMP-38102.02_2021 = E3810202 YEMP-38102.03_2021 = E3810203 YEMP-38102.04_2021 = E3810204 YEMP-38103.01_2021 = E3810301 YEMP-38103.02_2021 = E3810302 YEMP-38103.03_2021 = E3810303 YEMP-38103.04_2021 = E3810304 YEMP-58201.01_2021 = E5820101 YEMP-58201.02_2021 = E5820102 YEMP-58201.03_2021 = E5820103 YEMP-58201.04_2021 = E5820104 YEMP-58201.05_2021 = E5820105 YEMP-58201.06_2021 = E5820106 YEMP-58201.07_2021 = E5820107 YEMP-58201.08_2021 = E5820108 YEMP-58201.09_2021 = E5820109 YEMP-58201.10_2021 = E5820110 YEMP-59900.01_2021 = E5990001 YEMP-59900.02_2021 = E5990002 YEMP-59900.03_2021 = E5990003 YEMP-59900.04_2021 = E5990004 YEMP-59900.05_2021 = E5990005 YEMP-59900.06_2021 = E5990006 YEMP-59900.07_2021 = E5990007 YEMP-59900.08_2021 = E5990008 YEMP-59900.09_2021 = E5990009 YEMP-88000.01_2021 = E8800001 YEMP-88000.02_2021 = E8800002 YEMP-88000.03_2021 = E8800003 YEMP-88000.04_2021 = E8800004 YEMP-88000.05_2021 = E8800005 YEMP-88000.06_2021 = E8800006 YEMP-88000.07_2021 = E8800007 YEMP-88000.08_2021 = E8800008 YEMP-88000.09_2021 = E8800009 YEMP-98402.01_2021 = E9840201 YEMP-98402.02_2021 = E9840202 YEMP-98402.03_2021 = E9840203 YEMP-98402.04_2021 = E9840204 YEMP-98402.05_2021 = E9840205 YEMP-98402.06_2021 = E9840206 YEMP-98402.07_2021 = E9840207 YEMP-98402.09_2021 = E9840209 YEMP-98429.01_2021 = E9842901 YEMP-98429.02_2021 = E9842902 YEMP-98429.03_2021 = E9842903 YEMP-98429.04_2021 = E9842904 YEMP-98429.05_2021 = E9842905 YEMP-58401.01_2021 = E5840101 YEMP-58401.02_2021 = E5840102 YEMP-58401.03_2021 = E5840103 YEMP-58401.04_2021 = E5840104 YEMP-58401.05_2021 = E5840105 YEMP-58401.06_2021 = E5840106 YEMP-58401.07_2021 = E5840107 YEMP-58401.08_2021 = E5840108 YEMP-58401.09_2021 = E5840109 YEMP-58401.10_2021 = E5840110 YEMP_UID.01_2021 = UID01 YEMP_UID.02_2021 = UID02 YEMP_UID.03_2021 = UID03 YEMP_UID.04_2021 = UID04 YEMP_UID.05_2021 = UID05 YEMP_UID.06_2021 = UID06 YEMP_UID.07_2021 = UID07 YEMP_UID.08_2021 = UID08 YEMP_UID.09_2021 = UID09 YEMP_UID.10_2021 = UID10 YEMP_MILFLAG.01_2021 = MIL01 YEMP_MILFLAG.02_2021 = MIL02 YEMP_MILFLAG.03_2021 = MIL03 YEMP_MILFLAG.04_2021 = MIL04 YEMP_MILFLAG.05_2021 = MIL05 YEMP_MILFLAG.06_2021 = MIL06 YEMP_MILFLAG.07_2021 = MIL07 YEMP_MILFLAG.08_2021 = MIL08 YEMP_MILFLAG.09_2021 = MIL09 YEMP_MILFLAG.10_2021 = MIL10 */ *********************************** define arrays ****************************************; * job length; array e37701 e3770101-e3770110; array e37901b e37901b01-e37901b10; array e58201 e5820101-e5820110; array e58401 e5840101-e5840110; array e59900 e5990001-e5990010; * starting hours; array e23901 e2390101-e2390110; array e34402 e3440201-e3440210; array e34428 e3442801-e3442810; array e88000 e8800001-e8800010; array e98402 e9840201-e9840210; array e98429 e9842901-e9842910; * ending hours; array e38000b e38000b01-e38000b10; array e38000f e38000f01-e38000f10; array e38101 e3810101-e3810110; array e38102 e3810201-e3810210; array e38103 e3810301-e3810310; array e38002 e3800201-e3800210; * other variables; array euid uid01-uid10; array mil mil01-mil10; * created variables; array le13wk le13wk01-le13wk10; array hoursb hoursb01-hoursb10; array hours hours01-hours10; ******************************* job lasts at least 26 weeks NEW **************************; do i=1 to 10; le13wk[i]=-4; end; do i=1 to 10; if mil[i] ne 1 and euid[i]>0 then do; if E37701[i]=0 or E37901B[i]=0 then le13wk[i]=1; else if E58201[i]=0 or E59900[i]=0 then le13wk[i]=1; else if E58401[i]=1 then le13wk[i]=1; else if E37901B[i]=1 or E59900[i]=1 then le13wk[i]=0; else if E37901B[i] in (-1,-2,-3) or E59900[i] in (-1,-2,-3) then le13wk[i]=-3; end; if uid01=-5 then le13wk[i]=-5; end; ******************** Generate Variables using current round info ***********************; do i=1 to 10; hoursb[i]=-4; hours[i]=-4; end; do i=1 to 10; if e23901[i] not in (.,-4,-5) then hoursb[i]=e23901[i]; if e34402[i] not in (.,-4,-5) then hoursb[i]=e34402[i]; if e34428[i] not in (.,-4,-5) then hoursb[i]=e34428[i]; if e88000[i] not in (.,-4,-5) then hoursb[i]=e88000[i]; if e98402[i] not in (.,-4,-5) then hoursb[i]=e98402[i]; if e98429[i] not in (.,-4,-5) then hoursb[i]=e98429[i]; if e38000f[i] not in (.,-4,-5) then hoursb[i]=e38000f[i]; if e38002[i] in (.,-4,0) then hours[i]=hoursb[i]; else if e38002[i] lt 0 and e38002[i] ne -5 then hours[i]=-3; else if e38002[i] gt 0 then do; if hoursb[i] gt 0 & hoursb[i]>=e38002[i] then hours[i]=hoursb[i]-e38002[i]; else hours[i]=-3; end; if e38000b[i] lt 0 and e38000b[i] not in (-4,-5,.) then hours[i]=-3; if e38102[i] in (1,3) and e38103[i] not in (.,-4,-5) then hours[i]=e38103[i]; if e38102[i] lt 0 and e38102[i] not in (-4,-5, .) then hours[i]=-3; if hours[i] in (-1, -2, -3) then hours[i]=-3; if euid[i]=-4 and le13wk[i]=-4 then hours[i]=-4; if uid01=-5 then hours[i]=-5; end; run; data hours2; set hours1; array hours hours01-hours10; array euid uid01-uid10; array mil mil01-mil10; array le13wk le13wk01-le13wk10; *created variables from previous rounds; array R1hrs R1hrs1-R1hrs7; array R1uid R1uid1-R1uid7; array R2hrs R2hrs1-R2hrs9; array R2uid R2uid1-R2uid9; array R3hrs R3hrs1-R3hrs9; array R3uid R3uid1-R3uid9; array R4hrs R4hrs1-R4hrs9; array R4uid R4uid1-R4uid9; array R5hrs R5hrs1-R5hrs8; array R5uid R5uid1-R5uid8; array R6hrs R6hrs01-R6hrs11; array R6uid R6uid01-R6uid11; array R7hrs R7hrs01-R7hrs10; array R7uid R7uid01-R7uid10; array R8hrs R8hrs1-R8hrs7; array R8uid R8uid1-R8uid7; array R9hrs R9hrs1-R9hrs9; array R9uid R9uid1-R9uid9; array R10hrs R10hrs1-R10hrs9; array R10uid R10uid1-R10uid9; array R11hrs R11hrs1-R11hrs8; array R11uid R11uid1-R11uid8; array R12hrs R12hrs1-R12hrs8; array R12uid R12uid1-R12uid8; array R13hrs R13hrs1-R13hrs9; array R13uid R13uid1-R13uid9; array R14hrs R14hrs1-R14hrs9; array R14uid R14uid1-R14uid9; array R15hrs R15hrs01-R15hrs13; array R15uid R15uid01-R15uid13; array R16hrs R16hrs01-R16hrs10; array R16uid R16uid01-R16uid10; array R17hrs R17hrs01-R17hrs12; array R17uid R17uid01-R17uid12; array R18hrs R18hrs01-R18hrs15; array R18uid R18uid01-R18uid15; array R19hrs R19hrs01-R19hrs11; array R19uid R19uid01-R19uid11; ***** To be consistent with created hourly wage and comp and job length, the rules here are the same as those for hourly wage and comp; *1) If the job lasts 26 weeks or less, and the job is from previous rounds, we use hours from the previous rounds; *2) If the job lasts 26 weeks or less, and the job is a new job, we -3 hours; *3) If the job lasts more than 26 weeks or the job length is -3, we -3 hours; *The reason to -3 case 2) and case 3) is that they really should have answered hours info in the curr round; flag1=0; flag11=0; flag12=0; flag13=0; flag14=0; flag15=0; flag16=0; flag17=0; flag18=0; flag19=0; flag1_10=0; flag1_11=0; flag1_12=0; flag1_13=0; flag1_14=0; flag1_15=0; flag1_16=0; flag1_17=0; flag1_18=0; flag1_19=0; flag1_91=0; flag1_92=0; flag1_93=0; do i=1 to 10; if euid[i]>0 and mil[i] ne 1 and hours[i]=-4 then do; flag1=1; if le13wk[i]=1 & 97000 and mil[i] ne 1 and hours[i]=-4 and flag1_93 ne 1 then do; flag2=1; hours[i]=-3; end; end; ***** pick the cases with uid -4, but hours not -4; flag3=0; do i=1 to 10; if euid[i]=-4 and (hours[i] ne -4 or le13wk[i] ne -4) then flag3=1; end; flag_tot=flag11+flag12+flag13+flag14+flag15+flag16+flag17+flag18+flag19+flag1_10+flag1_11+flag1_12+flag1_13+flag1_14+ flag1_15+flag1_16+flag1_17+flag1_18+flag1_19; run; data hours.out_hoursR20; set hours2; keep norcid hours01-hours10; rename hours01='CV_HRS_PER_WEEK.01'n hours02='CV_HRS_PER_WEEK.02'n hours03='CV_HRS_PER_WEEK.03'n hours04='CV_HRS_PER_WEEK.04'n hours05='CV_HRS_PER_WEEK.05'n hours06='CV_HRS_PER_WEEK.06'n hours07='CV_HRS_PER_WEEK.07'n hours08='CV_HRS_PER_WEEK.08'n hours09='CV_HRS_PER_WEEK.09'n hours10='CV_HRS_PER_WEEK.10'n; run;