Create a dummy variable (shock) that is equal to one, if the year is 2006 and forward and 0 otherwise. Also, create the one year lag of the Housing start (Hsi)

state Year Quarter Unemployment rate Housing starts Real GSP|Growth in Real GSP Sales of dimensional lumber TX 1998 Sales of sheet goods Sales of misc. hardware 4.97 22859 801462 143 TX 1998 67 4 90 82 24001 801462 145 TX 1998 67 78 5.00 25140 801462 6 151 TX 71 1998 4.90 86 25812 801462 6 TX 155 77 1999 99 4.70 25253 835845 TX 158 79 92 1999 4.73 24736 835845 TX 157 76 79 1999 4.80 25253 835845 161 TX 81 89 1999 4.67 24262 835845 165 TX 85 106 2000 4.57 27173 870111 173 81 TX 101 2000 4.47 25036 87011 TX 176 84 116 2000 4.30 26111 87011 177 TX 79 97 2000 4.20 27271 87011 TX 183 86 109 2001 4.30 27520 891618 TX 186 92 112 2001 4.73 27886 891618 185 TX 95 109 2001 5.23 26738 891618 191 85 TX 111 2001 5.80 27553 891618 191 93 TX 2002 99 6.20 28418 912837 TX 198 91 112 2002 N N 6.37 30297 TX 912837 202 93 125 2002 6.40 30468 912837 TX 204 97 120 2002 6.53 31291 912837 205 93 TX 116 2003 6.67 30741 914892 TX 205 96 121 2003 6.83 31882 914892 93 117 TX 206 2003 6.80 35414 914892 TX 210 112 2003 6.50 127 33715 914892 TX 215 98 116 2004 6.23 35268 964924 216 TX 103 127 2004 6.07 35494 964924 218 108 114 TX 2004 5.93 35854 964924 TX 217 108 2004 5.83 35898 964924 221 105 136 TX 2005 5.60 37776 968553 228 110 139 TX 2005 5.40 39176 968553 TX 233 116 140 2005 LAWN 5.30 41906 968553 239 TX 122 2005 5.20 45821 968553 242 112 134 TX 2006 5.10 43965 1016315 247 159 TX 120 2006 5.07 41509 TX 1016315 242 119 143 W N 2006 4.90 37650 1016315 TX 241 115 143 2006 4.60 35797 1016315 235 116 133 TX 2007 4.40 33977 TX 1071592 241 109 2007 4.30 30134 242 146 TX 1071592 120 2007 4.30 27351 1071592 TX 4.40 238 113 144 2007 24693 1071592 TX 232 114 127 2008 4.37 TX 22366 1077144 229 108 121 2008 4.57 21449 1077144 TX 230 106 140 2008 LAWN 5.07 18949 1077144 224 103 119 TX 2008 5.73 14586 1077144 208 86 105 TX 2009 6.57 13817 1057675 191 TX 80 2009 7.37 15732 1057675 193 TX 85 2009 7.93 18630 1057675 TX 199 93 2009 8.13 18024 1057675 TX 93 88 2010 8.20 18634 111310 197 85 TX 2010 W N - A W N - A W N- 8.17 16717 1113104 195 88 TX 2010 8.13 14619 1113104 192 87 8 8 8 8 9 8 8 8 9 6 8 TX 2010 8.20 15265 1113104 185 82 TX 2011 8.03 14991 1149908 75 TX 2011 8.07 5584 1149908 85 TX 2011 8.03 16223 1149908 85 TX 2011 7.60 17201 1149908 196 90