Variable Created CV_HRS_PER_WEEK.xx (HOURS)--number of hours usually worked per week at each job This program creates a variable for each job in each survey round reporting the usual number of hours worked per week. If a job lasts 13 weeks or less, the program uses hours reported as of the job's start date. For jobs lasting longer than 13 weeks, the variable provides hours usually worked as of the end date or the most recent report (for example, the interview date). The number of hours reported in this created variable is also the number used to calculate the created hourly rate of pay (CV_HRLY_PAY) and hourly compensation (HRLY_COMPENSATION) variables described elsewhere in this appendix. /****************************** Variables used in the program***************************** Name in the prog Name in the gator ----------------- ----- PUBID PUBID_1997 r1UID1 YEMP_UID.01_1997 r1UID2 YEMP_UID.02_1997 r1UID3 YEMP_UID.03_1997 r1UID4 YEMP_UID.04_1997 r1UID5 YEMP_UID.05_1997 r1UID6 YEMP_UID.06_1997 r1UID7 YEMP_UID.07_1997 r1HRS1 CV_HRS_PER_WEEK.01_1997 r1HRS2 CV_HRS_PER_WEEK.02_1997 r1HRS3 CV_HRS_PER_WEEK.03_1997 r1HRS4 CV_HRS_PER_WEEK.04_1997 r1HRS5 CV_HRS_PER_WEEK.05_1997 r1HRS6 CV_HRS_PER_WEEK.06_1997 r1HRS7 CV_HRS_PER_WEEK.07_1997 r2UID1 YEMP_UID.01_1998 r2UID2 YEMP_UID.02_1998 r2UID3 YEMP_UID.03_1998 r2UID4 YEMP_UID.04_1998 r2UID5 YEMP_UID.05_1998 r2UID6 YEMP_UID.06_1998 r2UID7 YEMP_UID.07_1998 r2UID8 YEMP_UID.08_1998 r2UID9 YEMP_UID.09_1998 r2HRS1 CV_HRS_PER_WEEK.01_1998 r2HRS2 CV_HRS_PER_WEEK.02_1998 r2HRS3 CV_HRS_PER_WEEK.03_1998 r2HRS4 CV_HRS_PER_WEEK.04_1998 r2HRS5 CV_HRS_PER_WEEK.05_1998 r2HRS6 CV_HRS_PER_WEEK.06_1998 r2HRS7 CV_HRS_PER_WEEK.07_1998 r2HRS8 CV_HRS_PER_WEEK.08_1998 r2HRS9 CV_HRS_PER_WEEK.09_1998 r3UID1 YEMP_UID.01_1999 r3UID2 YEMP_UID.02_1999 r3UID3 YEMP_UID.03_1999 r3UID4 YEMP_UID.04_1999 r3UID5 YEMP_UID.05_1999 r3UID6 YEMP_UID.06_1999 r3UID7 YEMP_UID.07_1999 r3UID8 YEMP_UID.08_1999 r3UID9 YEMP_UID.09_1999 r3HRS1 CV_HRS_PER_WEEK.01_1999 r3HRS2 CV_HRS_PER_WEEK.02_1999 r3HRS3 CV_HRS_PER_WEEK.03_1999 r3HRS4 CV_HRS_PER_WEEK.04_1999 r3HRS5 CV_HRS_PER_WEEK.05_1999 r3HRS6 CV_HRS_PER_WEEK.06_1999 r3HRS7 CV_HRS_PER_WEEK.07_1999 r3HRS8 CV_HRS_PER_WEEK.08_1999 r3HRS9 CV_HRS_PER_WEEK.09_1999 r4UID1 YEMP_UID.01_2000 r4UID2 YEMP_UID.02_2000 r4UID3 YEMP_UID.03_2000 r4UID4 YEMP_UID.04_2000 r4UID5 YEMP_UID.05_2000 r4UID6 YEMP_UID.06_2000 r4UID7 YEMP_UID.07_2000 r4UID8 YEMP_UID.08_2000 r4UID9 YEMP_UID.09_2000 r4HRS1 CV_HRS_PER_WEEK.01_2000 r4HRS2 CV_HRS_PER_WEEK.02_2000 r4HRS3 CV_HRS_PER_WEEK.03_2000 r4HRS4 CV_HRS_PER_WEEK.04_2000 r4HRS5 CV_HRS_PER_WEEK.05_2000 r4HRS6 CV_HRS_PER_WEEK.06_2000 r4HRS7 CV_HRS_PER_WEEK.07_2000 r4HRS8 CV_HRS_PER_WEEK.08_2000 r4HRS9 CV_HRS_PER_WEEK.09_2000 r5UID1 YEMP_UID.01_2001 r5UID2 YEMP_UID.02_2001 r5UID3 YEMP_UID.03_2001 r5UID4 YEMP_UID.04_2001 r5UID5 YEMP_UID.05_2001 r5UID6 YEMP_UID.06_2001 r5UID7 YEMP_UID.07_2001 r5UID8 YEMP_UID.08_2001 r5HRS1 CV_HRS_PER_WEEK.01_2001 r5HRS2 CV_HRS_PER_WEEK.02_2001 r5HRS3 CV_HRS_PER_WEEK.03_2001 r5HRS4 CV_HRS_PER_WEEK.04_2001 r5HRS5 CV_HRS_PER_WEEK.05_2001 r5HRS6 CV_HRS_PER_WEEK.06_2001 r5HRS7 CV_HRS_PER_WEEK.07_2001 r5HRS8 CV_HRS_PER_WEEK.08_2001 r6UID01 YEMP_UID.01_2002 r6UID02 YEMP_UID.02_2002 r6UID03 YEMP_UID.03_2002 r6UID04 YEMP_UID.04_2002 r6UID05 YEMP_UID.05_2002 r6UID06 YEMP_UID.06_2002 r6UID07 YEMP_UID.07_2002 r6UID08 YEMP_UID.08_2002 r6UID09 YEMP_UID.09_2002 r6UID10 YEMP_UID.10_2002 r6UID11 YEMP_UID.11_2002 r6HRS01 CV_HRS_PER_WEEK.01_2002 r6HRS02 CV_HRS_PER_WEEK.02_2002 r6HRS03 CV_HRS_PER_WEEK.03_2002 r6HRS04 CV_HRS_PER_WEEK.04_2002 r6HRS05 CV_HRS_PER_WEEK.05_2002 r6HRS06 CV_HRS_PER_WEEK.06_2002 r6HRS07 CV_HRS_PER_WEEK.07_2002 r6HRS08 CV_HRS_PER_WEEK.08_2002 r6HRS09 CV_HRS_PER_WEEK.09_2002 r6HRS10 CV_HRS_PER_WEEK.10_2002 r6HRS11 CV_HRS_PER_WEEK.11_2002 r7HRS01 CV_HRS_PER_WEEK.01_2003 r7HRS02 CV_HRS_PER_WEEK.02_2003 r7HRS03 CV_HRS_PER_WEEK.03_2003 r7HRS04 CV_HRS_PER_WEEK.04_2003 r7HRS05 CV_HRS_PER_WEEK.05_2003 r7HRS06 CV_HRS_PER_WEEK.06_2003 r7HRS07 CV_HRS_PER_WEEK.07_2003 r7HRS08 CV_HRS_PER_WEEK.08_2003 r7HRS09 CV_HRS_PER_WEEK.09_2003 r7HRS10 CV_HRS_PER_WEEK.10_2003 r7UID01 YEMP_UID.01_2003 r7UID02 YEMP_UID.02_2003 r7UID03 YEMP_UID.03_2003 r7UID04 YEMP_UID.04_2003 r7UID05 YEMP_UID.05_2003 r7UID06 YEMP_UID.06_2003 r7UID07 YEMP_UID.07_2003 r7UID08 YEMP_UID.08_2003 r7UID09 YEMP_UID.09_2003 r7UID10 YEMP_UID.10_2003 r8HRS1 CV_HRS_PER_WEEK.01_2004 r8HRS2 CV_HRS_PER_WEEK.02_2004 r8HRS3 CV_HRS_PER_WEEK.03_2004 r8HRS4 CV_HRS_PER_WEEK.04_2004 r8HRS5 CV_HRS_PER_WEEK.05_2004 r8HRS6 CV_HRS_PER_WEEK.06_2004 r8HRS7 CV_HRS_PER_WEEK.07_2004 r8UID1 YEMP_UID.01_2004 r8UID2 YEMP_UID.02_2004 r8UID3 YEMP_UID.03_2004 r8UID4 YEMP_UID.04_2004 r8UID5 YEMP_UID.05_2004 r8UID6 YEMP_UID.06_2004 r8UID7 YEMP_UID.07_2004 r9HRS1 CV_HRS_PER_WEEK.01_2005 r9HRS2 CV_HRS_PER_WEEK.02_2005 r9HRS3 CV_HRS_PER_WEEK.03_2005 r9HRS4 CV_HRS_PER_WEEK.04_2005 r9HRS5 CV_HRS_PER_WEEK.05_2005 r9HRS6 CV_HRS_PER_WEEK.06_2005 r9HRS7 CV_HRS_PER_WEEK.07_2005 r9HRS8 CV_HRS_PER_WEEK.08_2005 r9HRS9 CV_HRS_PER_WEEK.09_2005 r9UID1 YEMP_UID.01_2005 r9UID2 YEMP_UID.02_2005 r9UID3 YEMP_UID.03_2005 r9UID4 YEMP_UID.04_2005 r9UID5 YEMP_UID.05_2005 r9UID6 YEMP_UID.06_2005 r9UID7 YEMP_UID.07_2005 r9UID8 YEMP_UID.08_2005 r9UID9 YEMP_UID.09_2005 r10HRS1 CV_HRS_PER_WEEK.01_2006 r10HRS2 CV_HRS_PER_WEEK.02_2006 r10HRS3 CV_HRS_PER_WEEK.03_2006 r10HRS4 CV_HRS_PER_WEEK.04_2006 r10HRS5 CV_HRS_PER_WEEK.05_2006 r10HRS6 CV_HRS_PER_WEEK.06_2006 r10HRS7 CV_HRS_PER_WEEK.07_2006 r10HRS8 CV_HRS_PER_WEEK.08_2006 r10HRS9 CV_HRS_PER_WEEK.09_2006 r10UID1 YEMP_UID.01_2006 r10UID2 YEMP_UID.02_2006 r10UID3 YEMP_UID.03_2006 r10UID4 YEMP_UID.04_2006 r10UID5 YEMP_UID.05_2006 r10UID6 YEMP_UID.06_2006 r10UID7 YEMP_UID.07_2006 r10UID8 YEMP_UID.08_2006 r10UID9 YEMP_UID.09_2006 r11HRS1 CV_HRS_PER_WEEK.01_2007 r11HRS2 CV_HRS_PER_WEEK.02_2007 r11HRS3 CV_HRS_PER_WEEK.03_2007 r11HRS4 CV_HRS_PER_WEEK.04_2007 r11HRS5 CV_HRS_PER_WEEK.05_2007 r11HRS6 CV_HRS_PER_WEEK.06_2007 r11HRS7 CV_HRS_PER_WEEK.07_2007 r11HRS8 CV_HRS_PER_WEEK.08_2007 r11UID1 YEMP_UID.01_2007 r11UID2 YEMP_UID.02_2007 r11UID3 YEMP_UID.03_2007 r11UID4 YEMP_UID.04_2007 r11UID5 YEMP_UID.05_2007 r11UID6 YEMP_UID.06_2007 r11UID7 YEMP_UID.07_2007 r11UID8 YEMP_UID.08_2007 r12HRS1 CV_HRS_PER_WEEK.01_2008 r12HRS2 CV_HRS_PER_WEEK.02_2008 r12HRS3 CV_HRS_PER_WEEK.03_2008 r12HRS4 CV_HRS_PER_WEEK.04_2008 r12HRS5 CV_HRS_PER_WEEK.05_2008 r12HRS6 CV_HRS_PER_WEEK.06_2008 r12HRS7 CV_HRS_PER_WEEK.07_2008 r12HRS8 CV_HRS_PER_WEEK.08_2008 r12UID1 YEMP_UID.01_2008 r12UID2 YEMP_UID.02_2008 r12UID3 YEMP_UID.03_2008 r12UID4 YEMP_UID.04_2008 r12UID5 YEMP_UID.05_2008 r12UID6 YEMP_UID.06_2008 r12UID7 YEMP_UID.07_2008 r12UID8 YEMP_UID.08_2008 r13HRS1 CV_HRS_PER_WEEK.01_2009 r13HRS2 CV_HRS_PER_WEEK.02_2009 r13HRS3 CV_HRS_PER_WEEK.03_2009 r13HRS4 CV_HRS_PER_WEEK.04_2009 r13HRS5 CV_HRS_PER_WEEK.05_2009 r13HRS6 CV_HRS_PER_WEEK.06_2009 r13HRS7 CV_HRS_PER_WEEK.07_2009 r13HRS8 CV_HRS_PER_WEEK.08_2009 r13HRS9 CV_HRS_PER_WEEK.09_2009 r13UID1 YEMP_UID.01_2009 r13UID2 YEMP_UID.02_2009 r13UID3 YEMP_UID.03_2009 r13UID4 YEMP_UID.04_2009 r13UID5 YEMP_UID.05_2009 r13UID6 YEMP_UID.06_2009 r13UID7 YEMP_UID.07_2009 r13UID8 YEMP_UID.08_2009 r13UID9 YEMP_UID.09_2009 r14HRS1 CV_HRS_PER_WEEK.01_2010 r14HRS2 CV_HRS_PER_WEEK.02_2010 r14HRS3 CV_HRS_PER_WEEK.03_2010 r14HRS4 CV_HRS_PER_WEEK.04_2010 r14HRS5 CV_HRS_PER_WEEK.05_2010 r14HRS6 CV_HRS_PER_WEEK.06_2010 r14HRS7 CV_HRS_PER_WEEK.07_2010 r14HRS8 CV_HRS_PER_WEEK.08_2010 r14HRS9 CV_HRS_PER_WEEK.09_2010 r14UID1 YEMP_UID.01_2010 r14UID2 YEMP_UID.02_2010 r14UID3 YEMP_UID.03_2010 r14UID4 YEMP_UID.04_2010 r14UID5 YEMP_UID.05_2010 r14UID6 YEMP_UID.06_2010 r14UID7 YEMP_UID.07_2010 r14UID8 YEMP_UID.08_2010 r14UID9 YEMP_UID.09_2010 r15HRS01 CV_HRS_PER_WEEK.01_2011 r15HRS02 CV_HRS_PER_WEEK.02_2011 r15HRS03 CV_HRS_PER_WEEK.03_2011 r15HRS04 CV_HRS_PER_WEEK.04_2011 r15HRS05 CV_HRS_PER_WEEK.05_2011 r15HRS06 CV_HRS_PER_WEEK.06_2011 r15HRS07 CV_HRS_PER_WEEK.07_2011 r15HRS08 CV_HRS_PER_WEEK.08_2011 r15HRS09 CV_HRS_PER_WEEK.09_2011 r15HRS10 CV_HRS_PER_WEEK.10_2011 r15HRS11 CV_HRS_PER_WEEK.11_2011 r15HRS12 CV_HRS_PER_WEEK.12_2011 r15HRS13 CV_HRS_PER_WEEK.13_2011 r15UID01 YEMP_UID.01_2011 r15UID02 YEMP_UID.02_2011 r15UID03 YEMP_UID.03_2011 r15UID04 YEMP_UID.04_2011 r15UID05 YEMP_UID.05_2011 r15UID06 YEMP_UID.06_2011 r15UID07 YEMP_UID.07_2011 r15UID08 YEMP_UID.08_2011 r15UID09 YEMP_UID.09_2011 r15UID10 YEMP_UID.10_2011 r15UID11 YEMP_UID.11_2011 r15UID12 YEMP_UID.12_2011 r15UID13 YEMP_UID.13_2011 r16HRS01 CV_HRS_PER_WEEK.01_2013 r16HRS02 CV_HRS_PER_WEEK.02_2013 r16HRS03 CV_HRS_PER_WEEK.03_2013 r16HRS04 CV_HRS_PER_WEEK.04_2013 r16HRS05 CV_HRS_PER_WEEK.05_2013 r16HRS06 CV_HRS_PER_WEEK.06_2013 r16HRS07 CV_HRS_PER_WEEK.07_2013 r16HRS08 CV_HRS_PER_WEEK.08_2013 r16HRS09 CV_HRS_PER_WEEK.09_2013 r16HRS10 CV_HRS_PER_WEEK.10_2013 r16UID01 YEMP_UID.01_2013 r16UID02 YEMP_UID.02_2013 r16UID03 YEMP_UID.03_2013 r16UID04 YEMP_UID.04_2013 r16UID05 YEMP_UID.05_2013 r16UID06 YEMP_UID.06_2013 r16UID07 YEMP_UID.07_2013 r16UID08 YEMP_UID.08_2013 r16UID09 YEMP_UID.09_2013 r16UID10 YEMP_UID.10_2013 r17HRS01 CV_HRS_PER_WEEK.01_2015 r17HRS02 CV_HRS_PER_WEEK.02_2015 r17HRS03 CV_HRS_PER_WEEK.03_2015 r17HRS04 CV_HRS_PER_WEEK.04_2015 r17HRS05 CV_HRS_PER_WEEK.05_2015 r17HRS06 CV_HRS_PER_WEEK.06_2015 r17HRS07 CV_HRS_PER_WEEK.07_2015 r17HRS08 CV_HRS_PER_WEEK.08_2015 r17HRS09 CV_HRS_PER_WEEK.09_2015 r17HRS10 CV_HRS_PER_WEEK.10_2015 r17HRS11 CV_HRS_PER_WEEK.11_2015 r17HRS12 CV_HRS_PER_WEEK.12_2015 r17UID01 YEMP_UID.01_2015 r17UID02 YEMP_UID.02_2015 r17UID03 YEMP_UID.03_2015 r17UID04 YEMP_UID.04_2015 r17UID05 YEMP_UID.05_2015 r17UID06 YEMP_UID.06_2015 r17UID07 YEMP_UID.07_2015 r17UID08 YEMP_UID.08_2015 r17UID09 YEMP_UID.09_2015 r17UID10 YEMP_UID.10_2015 r17UID11 YEMP_UID.11_2015 r17UID12 YEMP_UID.12_2015 E2390101 YEMP-23901.01_2019 E2390102 YEMP-23901.02_2019 E2390103 YEMP-23901.03_2019 E2390104 YEMP-23901.04_2019 E2390105 YEMP-23901.05_2019 E2390106 YEMP-23901.06_2019 E2390107 YEMP-23901.07_2019 E2390108 YEMP-23901.08_2019 E2390110 YEMP-23901.10_2019 E3440201 YEMP-34402.01_2019 E3440202 YEMP-34402.02_2019 E3440203 YEMP-34402.03_2019 E3440204 YEMP-34402.04_2019 E3440205 YEMP-34402.05_2019 E3440206 YEMP-34402.06_2019 E3440207 YEMP-34402.07_2019 E3440208 YEMP-34402.08_2019 E3440209 YEMP-34402.09_2019 E3440210 YEMP-34402.10_2019 E3442801 YEMP-34428.01_2019 E3442802 YEMP-34428.02_2019 E3442803 YEMP-34428.03_2019 E3442804 YEMP-34428.04_2019 E3442805 YEMP-34428.05_2019 E3442806 YEMP-34428.06_2019 E3770101 YEMP-37701.01_2019 E3770102 YEMP-37701.02_2019 E3770103 YEMP-37701.03_2019 E3770104 YEMP-37701.04_2019 E3770105 YEMP-37701.05_2019 E3770106 YEMP-37701.06_2019 E3770107 YEMP-37701.07_2019 E3770108 YEMP-37701.08_2019 E3770109 YEMP-37701.09_2019 E3770110 YEMP-37701.10_2019 E37901B01 YEMP-37901B.01_2019 E37901B02 YEMP-37901B.02_2019 E37901B03 YEMP-37901B.03_2019 E37901B04 YEMP-37901B.04_2019 E37901B05 YEMP-37901B.05_2019 E37901B06 YEMP-37901B.06_2019 E37901B07 YEMP-37901B.07_2019 E37901B08 YEMP-37901B.08_2019 E37901B09 YEMP-37901B.09_2019 E37901B10 YEMP-37901B.10_2019 E38000B01 YEMP-38000B.01_2019 E38000B02 YEMP-38000B.02_2019 E38000B03 YEMP-38000B.03_2019 E38000B04 YEMP-38000B.04_2019 E38000B05 YEMP-38000B.05_2019 E38000B06 YEMP-38000B.06_2019 E38000B07 YEMP-38000B.07_2019 E38000B08 YEMP-38000B.08_2019 E38000B09 YEMP-38000B.09_2019 E38000B10 YEMP-38000B.10_2019 E38000F01 YEMP-38000F.01_2019 E38000F02 YEMP-38000F.02_2019 E38000F03 YEMP-38000F.03_2019 E38000F04 YEMP-38000F.04_2019 E38000F05 YEMP-38000F.05_2019 E38000F06 YEMP-38000F.06_2019 E38000F07 YEMP-38000F.07_2019 E3800201 YEMP-38002.01_2019 E3800202 YEMP-38002.02_2019 E3800203 YEMP-38002.03_2019 E3800204 YEMP-38002.04_2019 E3800205 YEMP-38002.05_2019 E3810101 YEMP-38101.01_2019 E3810102 YEMP-38101.02_2019 E3810103 YEMP-38101.03_2019 E3810104 YEMP-38101.04_2019 E3810106 YEMP-38101.06_2019 E3810201 YEMP-38102.01_2019 E3810202 YEMP-38102.02_2019 E3810203 YEMP-38102.03_2019 E3810204 YEMP-38102.04_2019 E3810206 YEMP-38102.06_2019 E3810301 YEMP-38103.01_2019 E3810302 YEMP-38103.02_2019 E3810303 YEMP-38103.03_2019 E3810304 YEMP-38103.04_2019 E3810306 YEMP-38103.06_2019 E5820101 YEMP-58201.01_2019 E5820102 YEMP-58201.02_2019 E5820103 YEMP-58201.03_2019 E5820104 YEMP-58201.04_2019 E5820105 YEMP-58201.05_2019 E5820106 YEMP-58201.06_2019 E5820107 YEMP-58201.07_2019 E5820108 YEMP-58201.08_2019 E5820109 YEMP-58201.09_2019 E5820111 YEMP-58201.11_2019 E5990001 YEMP-59900.01_2019 E5990002 YEMP-59900.02_2019 E5990003 YEMP-59900.03_2019 E5990004 YEMP-59900.04_2019 E5990005 YEMP-59900.05_2019 E5990006 YEMP-59900.06_2019 E5990007 YEMP-59900.07_2019 E5990008 YEMP-59900.08_2019 E5990009 YEMP-59900.09_2019 E5990011 YEMP-59900.11_2019 E8800001 YEMP-88000.01_2019 E8800002 YEMP-88000.02_2019 E8800003 YEMP-88000.03_2019 E8800004 YEMP-88000.04_2019 E8800005 YEMP-88000.05_2019 E8800006 YEMP-88000.06_2019 E8800007 YEMP-88000.07_2019 E8800008 YEMP-88000.08_2019 E9840201 YEMP-98402.01_2019 E9840202 YEMP-98402.02_2019 E9840203 YEMP-98402.03_2019 E9840204 YEMP-98402.04_2019 E9840205 YEMP-98402.05_2019 E9840206 YEMP-98402.06_2019 E9840207 YEMP-98402.07_2019 E9840211 YEMP-98402.11_2019 E9842901 YEMP-98429.01_2019 E9842902 YEMP-98429.02_2019 E9842903 YEMP-98429.03_2019 E9842904 YEMP-98429.04_2019 E9842906 YEMP-98429.06_2019 E5840101 YEMP-58401.01_2019 E5840102 YEMP-58401.02_2019 E5840103 YEMP-58401.03_2019 E5840104 YEMP-58401.04_2019 E5840105 YEMP-58401.05_2019 E5840106 YEMP-58401.06_2019 E5840107 YEMP-58401.07_2019 E5840108 YEMP-58401.08_2019 E5840109 YEMP-58401.09_2019 E5840110 YEMP-58401.10_2019 E5840111 YEMP-58401.11_2019 UID01 YEMP_UID.01_2019 UID02 YEMP_UID.02_2019 UID03 YEMP_UID.03_2019 UID04 YEMP_UID.04_2019 UID05 YEMP_UID.05_2019 UID06 YEMP_UID.06_2019 UID07 YEMP_UID.07_2019 UID08 YEMP_UID.08_2019 UID09 YEMP_UID.09_2019 UID10 YEMP_UID.10_2019 UID11 YEMP_UID.11_2019 MIL01 YEMP_MILFLAG.01_2019 MIL02 YEMP_MILFLAG.02_2019 MIL03 YEMP_MILFLAG.03_2019 MIL04 YEMP_MILFLAG.04_2019 MIL05 YEMP_MILFLAG.05_2019 MIL06 YEMP_MILFLAG.06_2019 MIL07 YEMP_MILFLAG.07_2019 MIL08 YEMP_MILFLAG.08_2019 MIL09 YEMP_MILFLAG.09_2019 MIL10 YEMP_MILFLAG.10_2019 MIL11 YEMP_MILFLAG.11_2019 SAS Code for Variable Creation *********************************** define arrays ****************************************; * job length; array e37701 e3770101-e3770111; array e37901b e37901b01-e37901b11; array e58201 e5820101-e5820111; array e58401 e5840101-e5840111; array e59900 e5990001-e5990011; * starting hours; array e23901 e2390101-e2390111; array e34402 e3440201-e3440211; array e34428 e3442801-e3442811; array e88000 e8800001-e8800011; array e98402 e9840201-e9840211; array e98429 e9842901-e9842911; * ending hours; array e38000b e38000b01-e38000b11; array e38000f e38000f01-e38000f11; array e38101 e3810101-e3810111; array e38102 e3810201-e3810211; array e38103 e3810301-e3810311; array e38002 e3800201-e3800211; * other variables; array euid uid01-uid11; array mil mil01-mil11; * created variables; array le13wk le13wk01-le13wk11; array hoursb hoursb01-hoursb11; array hours hours01-hours11; ******************************* job lasts at least 26 weeks NEW **************************; do i=1 to 11; le13wk[i]=-4; end; do i=1 to 11; 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 11; hoursb[i]=-4; hours[i]=-4; end; do i=1 to 11; 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-hours11; array euid uid01-uid11; array mil mil01-mil15; array le13wk le13wk01-le13wk11; *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; 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_91=0; flag1_92=0; flag1_93=0; do i=1 to 11; if euid[i]>0 and mil[i] ne 1 and hours[i]=-4 then do; flag1=1; if le13wk[i]=1 & 9700