topic Re: Days to 30 days interval data creation in SAS Programming https://communities.sas.com/t5/SAS-Programming/Days-to-30-days-interval-data-creation/m-p/448043#M283401 <P>You can summarize in a single step with</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc sql; create table want as select enrolid, 30*ceil(i2/30) as end, sum(fill_i) as sum_fill_i from have group by enrolid, calculated end; quit;</CODE></PRE> Fri, 23 Mar 2018 03:31:24 GMT PGStats 2018-03-23T03:31:24Z Days to 30 days interval data creation https://communities.sas.com/t5/SAS-Programming/Days-to-30-days-interval-data-creation/m-p/448036#M283400 <DIV class="gmail_default">I have data as daily (attached below):</DIV><DIV class="gmail_default">I want to make as 30 days (from i2 variable) &nbsp;interval data as, for example,&nbsp;</DIV><DIV class="gmail_default">ID END sum_fill_i</DIV><DIV class="gmail_default">123699041 30 VVV (whatever sum of this fill_i between 1 and 30)</DIV><DIV class="gmail_default">next row would be as below:</DIV><DIV class="gmail_default"><SPAN>123699041&nbsp;</SPAN>60 XXX (next summation of the fill_i).</DIV><DIV class="gmail_default">&nbsp;</DIV><DIV class="gmail_default">Can you help please? Thank you.</DIV><DIV class="gmail_default">&nbsp;</DIV><DIV class="gmail_default"><DIV align="center">ENROLID i2 fill_i <TABLE cellspacing="0" cellpadding="5"><TBODY><TR><TD>1236990401</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>2</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>3</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>4</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>5</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>6</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>7</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>8</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>9</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>10</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>11</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>12</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>13</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>14</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>15</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>16</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>17</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>18</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>19</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>20</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>21</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>22</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>23</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>24</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>25</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>26</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>27</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>28</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>29</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>30</TD><TD>1</TD></TR><TR><TD>1236990401</TD><TD>32</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>33</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>34</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>35</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>36</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>37</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>38</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>39</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>40</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>41</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>42</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>43</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>44</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>45</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>46</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>47</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>48</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>49</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>50</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>51</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>52</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>53</TD><TD>32</TD></TR><TR><TD>1236990401</TD><TD>54</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>55</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>56</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>57</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>58</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>59</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>60</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>61</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>62</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>63</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>64</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>65</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>66</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>67</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>68</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>69</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>70</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>71</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>72</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>73</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>74</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>75</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>76</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>77</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>78</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>79</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>80</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>81</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>82</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>83</TD><TD>54</TD></TR><TR><TD>1236990401</TD><TD>92</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>93</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>94</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>95</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>96</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>97</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>98</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>99</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>100</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>101</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>102</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>103</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>104</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>105</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>106</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>107</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>108</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>109</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>110</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>111</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>112</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>113</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>114</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>115</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>116</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>117</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>118</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>119</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>120</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>121</TD><TD>92</TD></TR><TR><TD>1236990401</TD><TD>171</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>172</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>173</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>174</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>175</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>176</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>177</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>178</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>179</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>180</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>181</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>182</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>183</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>184</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>185</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>186</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>187</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>188</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>189</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>190</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>191</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>192</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>193</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>194</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>195</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>196</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>197</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>198</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>199</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>200</TD><TD>171</TD></TR><TR><TD>1236990401</TD><TD>228</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>229</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>230</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>231</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>232</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>233</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>234</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>235</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>236</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>237</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>238</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>239</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>240</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>241</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>242</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>243</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>244</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>245</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>246</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>247</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>248</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>249</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>250</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>251</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>252</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>253</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>254</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>255</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>256</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>257</TD><TD>228</TD></TR><TR><TD>1236990401</TD><TD>268</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>269</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>270</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>271</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>272</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>273</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>274</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>275</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>276</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>277</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>278</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>279</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>280</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>281</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>282</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>283</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>284</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>285</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>286</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>287</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>288</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>289</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>290</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>291</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>292</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>293</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>294</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>295</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>296</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>297</TD><TD>268</TD></TR><TR><TD>1236990401</TD><TD>299</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>300</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>301</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>302</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>303</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>304</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>305</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>306</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>307</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>308</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>309</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>310</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>311</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>312</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>313</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>314</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>315</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>316</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>317</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>318</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>319</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>320</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>321</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>322</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>323</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>324</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>325</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>326</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>327</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>328</TD><TD>299</TD></TR><TR><TD>1236990401</TD><TD>347</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>348</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>349</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>350</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>351</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>352</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>353</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>354</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>355</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>356</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>357</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>358</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>359</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>360</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>361</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>362</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>363</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>364</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>365</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>366</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>367</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>368</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>369</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>370</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>371</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>372</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>373</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>374</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>375</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>376</TD><TD>347</TD></TR><TR><TD>1236990401</TD><TD>409</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>410</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>411</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>412</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>413</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>414</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>415</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>416</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>417</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>418</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>419</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>420</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>421</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>422</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>423</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>424</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>425</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>426</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>427</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>428</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>429</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>430</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>431</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>432</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>433</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>434</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>435</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>436</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>437</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>438</TD><TD>409</TD></TR><TR><TD>1236990401</TD><TD>443</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>444</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>445</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>446</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>447</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>448</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>449</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>450</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>451</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>452</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>453</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>454</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>455</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>456</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>457</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>458</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>459</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>460</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>461</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>462</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>463</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>464</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>465</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>466</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>467</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>468</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>469</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>470</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>471</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>472</TD><TD>443</TD></TR><TR><TD>1236990401</TD><TD>474</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>475</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>476</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>477</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>478</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>479</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>480</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>481</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>482</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>483</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>484</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>485</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>486</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>487</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>488</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>489</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>490</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>491</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>492</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>493</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>494</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>495</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>496</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>497</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>498</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>499</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>500</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>501</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>502</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>503</TD><TD>474</TD></TR><TR><TD>1236990401</TD><TD>822</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>823</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>824</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>825</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>826</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>827</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>828</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>829</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>830</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>831</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>832</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>833</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>834</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>835</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>836</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>837</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>838</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>839</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>840</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>841</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>842</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>843</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>844</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>845</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>846</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>847</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>848</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>849</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>850</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>851</TD><TD>822</TD></TR><TR><TD>1236990401</TD><TD>1116</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1117</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1118</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1119</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1120</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1121</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1122</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1123</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1124</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1125</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1126</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1127</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1128</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1129</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1130</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1131</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1132</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1133</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1134</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1135</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1136</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1137</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1138</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1139</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1140</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1141</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1142</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1143</TD><TD>1116</TD></TR><TR><TD>1236990401</TD><TD>1146</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1147</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1148</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1149</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1150</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1151</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1152</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1153</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1154</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1155</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1156</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1157</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1158</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1159</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1160</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1161</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1162</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1163</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1164</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1165</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1166</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1167</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1168</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1169</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1170</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1171</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1172</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1173</TD><TD>1146</TD></TR><TR><TD>1236990401</TD><TD>1181</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1182</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1183</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1184</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1185</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1186</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1187</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1188</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1189</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1190</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1191</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1192</TD><TD>1181</TD></TR><TR><TD>1236990401</TD><TD>1193</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1194</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1195</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1196</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1197</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1198</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1199</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1200</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1201</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1202</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1203</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1204</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1205</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1206</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1207</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1208</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1209</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1210</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1211</TD><TD>1193</TD></TR><TR><TD>1236990401</TD><TD>1212</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1213</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1214</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1215</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1216</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1217</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1218</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1219</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1220</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1221</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1222</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1223</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1224</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1225</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1226</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1227</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1228</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1229</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1230</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1231</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1232</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1233</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1234</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1235</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1236</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1237</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1238</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1239</TD><TD>1212</TD></TR><TR><TD>1236990401</TD><TD>1240</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1241</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1242</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1243</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1244</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1245</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1246</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1247</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1248</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1249</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1250</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1251</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1252</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1253</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1254</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1255</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1256</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1257</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1258</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1259</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1260</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1261</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1262</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1263</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1264</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1265</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1266</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1267</TD><TD>1240</TD></TR><TR><TD>1236990401</TD><TD>1268</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1269</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1270</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1271</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1272</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1273</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1274</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1275</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1276</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1277</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1278</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1279</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1280</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1281</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1282</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1283</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1284</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1285</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1286</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1287</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1288</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1289</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1290</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1291</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1292</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1293</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1294</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1295</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1296</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1297</TD><TD>1268</TD></TR><TR><TD>1236990401</TD><TD>1317</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1318</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1319</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1320</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1321</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1322</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1323</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1324</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1325</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1326</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1327</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1328</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1329</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1330</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1331</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1332</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1333</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1334</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1335</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1336</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1337</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1338</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1339</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1340</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1341</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1342</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1343</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1344</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1345</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1346</TD><TD>1317</TD></TR><TR><TD>1236990401</TD><TD>1376</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1377</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1378</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1379</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1380</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1381</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1382</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1383</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1384</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1385</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1386</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1387</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1388</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1389</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1390</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1391</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1392</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1393</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1394</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1395</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1396</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1397</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1398</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1399</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1400</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1401</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1402</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1403</TD><TD>1376</TD></TR><TR><TD>1236990401</TD><TD>1422</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1423</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1424</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1425</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1426</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1427</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1428</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1429</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1430</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1431</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1432</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1433</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1434</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1435</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1436</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1437</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1438</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1439</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1440</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1441</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1442</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1443</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1444</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1445</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1446</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1447</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1448</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1449</TD><TD>1422</TD></TR><TR><TD>1236990401</TD><TD>1509</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1510</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1511</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1512</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1513</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1514</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1515</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1516</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1517</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1518</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1519</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1520</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1521</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1522</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1523</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1524</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1525</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1526</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1527</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1528</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1529</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1530</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1531</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1532</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1533</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1534</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1535</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1536</TD><TD>1509</TD></TR><TR><TD>1236990401</TD><TD>1554</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1555</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1556</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1557</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1558</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1559</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1560</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1561</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1562</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1563</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1564</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1565</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1566</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1567</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1568</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1569</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1570</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1571</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1572</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1573</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1574</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1575</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1576</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1577</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1578</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1579</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1580</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1581</TD><TD>1554</TD></TR><TR><TD>1236990401</TD><TD>1734</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1735</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1736</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1737</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1738</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1739</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1740</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1741</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1742</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1743</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1744</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1745</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1746</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1747</TD><TD>1734</TD></TR><TR><TD>1236990401</TD><TD>1748</TD><TD>1734</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE></DIV></DIV> Fri, 23 Mar 2018 02:57:13 GMT https://communities.sas.com/t5/SAS-Programming/Days-to-30-days-interval-data-creation/m-p/448036#M283400 Zula 2018-03-23T02:57:13Z Re: Days to 30 days interval data creation https://communities.sas.com/t5/SAS-Programming/Days-to-30-days-interval-data-creation/m-p/448043#M283401 <P>You can summarize in a single step with</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc sql; create table want as select enrolid, 30*ceil(i2/30) as end, sum(fill_i) as sum_fill_i from have group by enrolid, calculated end; quit;</CODE></PRE> Fri, 23 Mar 2018 03:31:24 GMT https://communities.sas.com/t5/SAS-Programming/Days-to-30-days-interval-data-creation/m-p/448043#M283401 PGStats 2018-03-23T03:31:24Z