<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Aggregating by rolling timeframes in SAS Programming</title>
    <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751894#M236770</link>
    <description>&lt;BLOCKQUOTE&gt;&lt;HR /&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/384582"&gt;@casmcfarland&lt;/a&gt;&amp;nbsp;wrote:&lt;BR /&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;This works, but now I need to aggregate to 6 month intervals but a rolling 6 months so 1/2006-6/2006, 2/2006-7/2006, 3/2006-8/2006 etc.&amp;nbsp;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892"&gt;@PaigeMiller&lt;/a&gt;&amp;nbsp;I have reviewed your recommendations of how to post my question; however, I do not have code that is not working, I am trying to figure out where to start. And I simply trying to get some insight of different methods to try because I am stuck. Your instructions are not helping me.&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;P&gt;I'm not asking to see your code. I am asking for a working copy of (a portion of) your data, and I linked to instructions that will allow you to provide&amp;nbsp;(a portion of) your data in a form I can work with. I can't write working code for you without a working copy of (a portion of) your data.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The general idea to sum over many different time intervals is to create a multi-label format and then do the summing in PROC SUMMARY with the multilabel format assigned to the variable. Here is the general idea:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;proc format;
    value datef (multilabel)
        '01JAN2006'd-'30JUN2006'd = '01JAN2006'
        '01FEB2006'd-'31JUL2006'd = '01FEB2006'
        /* and so on */
    ;
run;

proc summary data=yourdatasetname;
    class yourdatevariable / mlf;
    var frisk furtive /* all your variables that are supposed to be summed go here */;
    output out=sums sum=;
    format yourdatevariable datef.;
run;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;Again, I can't give you more code until I have a working copy of your data.&lt;/P&gt;</description>
    <pubDate>Sat, 03 Jul 2021 15:42:34 GMT</pubDate>
    <dc:creator>PaigeMiller</dc:creator>
    <dc:date>2021-07-03T15:42:34Z</dc:date>
    <item>
      <title>Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751743#M236686</link>
      <description>&lt;P&gt;I am trying to aggregate data into rolling timeframes so for each month/year combination within a particular census tract. I would have an aggregate of the data for 13-18 months prior, 7-12 months prior, 0-6 months prior, 0-6 months after, 7-12 months after, and 13-18 months after for each tract. So for 200801 (January 2008) I would have a sum for the following timeframes for each census tract in the data:&lt;/P&gt;&lt;P&gt;July 2006-December 2006&lt;/P&gt;&lt;P&gt;January 2007-June 2007&lt;/P&gt;&lt;P&gt;July 2007-December 2007&lt;/P&gt;&lt;P&gt;January 2008-June 2008&lt;/P&gt;&lt;P&gt;July 2008-December 2008&lt;/P&gt;&lt;P&gt;January 2009-June 2009&lt;/P&gt;</description>
      <pubDate>Fri, 02 Jul 2021 14:23:22 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751743#M236686</guid>
      <dc:creator>casmcfarland</dc:creator>
      <dc:date>2021-07-02T14:23:22Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751746#M236689</link>
      <description>&lt;P&gt;Many of us will not (or cannot) download attachments. Please include a small portion of your data in your reply following &lt;A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_self"&gt;these instrucctions&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Is the request always producing time frames that start in January and end in June, or start in July and end in December? Or could there be other 6 month intervals (and how would we know when to use other 6 month intervals)?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 02 Jul 2021 14:40:08 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751746#M236689</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-07-02T14:40:08Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751758#M236693</link>
      <description>&lt;P&gt;Data I have&lt;/P&gt;&lt;P&gt;SQFMTHYR&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Tract2010&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Friskcount&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Furtcount&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Searchcount&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Arrestcount&lt;/P&gt;&lt;P&gt;200801&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200802&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200803&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200804&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200805&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200806&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200807&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Data I want&lt;/P&gt;&lt;P&gt;SQFMTHYR&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;SQFMTHYR6A&amp;nbsp; &amp;nbsp; &amp;nbsp;Tract2010&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Friskcount&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Furtcount&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Searchcount&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Arrestcount&lt;/P&gt;&lt;P&gt;200801&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;200801-200806&amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;6&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;6&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;200802&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;200802-200807&amp;nbsp; &amp;nbsp; &amp;nbsp;36005000200&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;6&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 0&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;6&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;0&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I don't really need the SQFMTHYR6A this is just designating that this aggregate is the six months after 01/2008 and after 02/2008. I need these 6 month aggregates for each month/year timeframe and I have 6 aggregates per month/year timeframe (see above). I have ideas on how to do it and have it visualized but am at a total loss with regard to programming.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 02 Jul 2021 14:51:18 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751758#M236693</guid>
      <dc:creator>casmcfarland</dc:creator>
      <dc:date>2021-07-02T14:51:18Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751765#M236699</link>
      <description>&lt;P&gt;Here is what I have:&lt;/P&gt;&lt;TABLE&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;sqfmthyr&lt;/TD&gt;&lt;TD&gt;tract2010&lt;/TD&gt;&lt;TD&gt;friskcount&lt;/TD&gt;&lt;TD&gt;furtcount&lt;/TD&gt;&lt;TD&gt;searchcount&lt;/TD&gt;&lt;TD&gt;arrestcount&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Feb-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Feb-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Feb-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Mar-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Apr-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;May-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;May-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jun-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jun-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jun-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jun-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jul-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jul-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Jul-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Aug-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;2&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Aug-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Sep-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;Oct-06&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Here is what I need:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;TABLE&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;sqfmthyr&lt;/TD&gt;&lt;TD&gt;sqfmthyragg&lt;/TD&gt;&lt;TD&gt;tract2010&lt;/TD&gt;&lt;TD&gt;friskcount&lt;/TD&gt;&lt;TD&gt;furtcount&lt;/TD&gt;&lt;TD&gt;searchcount&lt;/TD&gt;&lt;TD&gt;arrestcount&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;200602&lt;/TD&gt;&lt;TD&gt;200602-200607&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;14&lt;/TD&gt;&lt;TD&gt;7&lt;/TD&gt;&lt;TD&gt;0&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;200603&lt;/TD&gt;&lt;TD&gt;200603-200608&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;15&lt;/TD&gt;&lt;TD&gt;9&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;200604&lt;/TD&gt;&lt;TD&gt;200604-200609&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;17&lt;/TD&gt;&lt;TD&gt;12&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD&gt;200605&lt;/TD&gt;&lt;TD&gt;200605-200610&lt;/TD&gt;&lt;TD&gt;36005000200&lt;/TD&gt;&lt;TD&gt;16&lt;/TD&gt;&lt;TD&gt;12&lt;/TD&gt;&lt;TD&gt;1&lt;/TD&gt;&lt;TD&gt;3&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;</description>
      <pubDate>Fri, 02 Jul 2021 15:34:00 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751765#M236699</guid>
      <dc:creator>casmcfarland</dc:creator>
      <dc:date>2021-07-02T15:34:00Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751767#M236700</link>
      <description>&lt;P&gt;I'm afraid this still requires more explanation on how to determine the dates in the output from the dates in the input.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I still request the data be provided according to the instructions I gave.&lt;/P&gt;</description>
      <pubDate>Fri, 02 Jul 2021 15:50:13 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751767#M236700</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-07-02T15:50:13Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751827#M236731</link>
      <description>&lt;P&gt;This is the code I used to go from individual to aggregate by year/month:&lt;/P&gt;&lt;P&gt;proc sql;&lt;BR /&gt;create table sqfagg as&lt;BR /&gt;select put(sqfmthyr, YYMMN6.) as reporting_period, tract2010, count (*) as stopcount, sum(frisk) as friskcount format=comma10. , sum(furtive) as furtcount format=comma10. ,&lt;BR /&gt;sum(search) as searchcount format=comma10. , count(*) as stopcount format=comma10., sum(arrestmade) as arrestcount format=comma10.,&lt;BR /&gt;sum(summonissue) as summonscount format=comma10., sum(physicalforce) as phyfrc format=comma10.,&lt;BR /&gt;sum(criminaldress) format=comma10. as crimdress, sum(black) format=comma10. as blackcount, sum(white) format=comma10. as whitecount, sum(hispanic) format=comma10. as hispaniccount,&lt;BR /&gt;sum(otherrace) format=comma10. as othracecount&lt;BR /&gt;from sqfmonthyear&lt;BR /&gt;group by tract2010, put(sqfmthyr, YYMMN6.) ;&lt;BR /&gt;quit;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This works, but now I need to aggregate to 6 month intervals but a rolling 6 months so 1/2006-6/2006, 2/2006-7/2006, 3/2006-8/2006 etc.&amp;nbsp;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892"&gt;@PaigeMiller&lt;/a&gt;&amp;nbsp;I have reviewed your recommendations of how to post my question; however, I do not have code that is not working, I am trying to figure out where to start. And I simply trying to get some insight of different methods to try because I am stuck. Your instructions are not helping me.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 02 Jul 2021 21:37:28 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751827#M236731</guid>
      <dc:creator>casmcfarland</dc:creator>
      <dc:date>2021-07-02T21:37:28Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751889#M236767</link>
      <description>Sounds like you want a grouping variable that collects (to aggregate) data in the 6 month window. That grouping variable would be used in a 'group by' clause. Each source row would contribute to multiple(6) 'tracts'. &lt;BR /&gt;Judging by the topic and use of SQL and 6-fold expanding of the data, it might be wise to make this expansion in a VIEW or views,  prior to aggregation.</description>
      <pubDate>Sat, 03 Jul 2021 10:45:09 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751889#M236767</guid>
      <dc:creator>Peter_C</dc:creator>
      <dc:date>2021-07-03T10:45:09Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751894#M236770</link>
      <description>&lt;BLOCKQUOTE&gt;&lt;HR /&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/384582"&gt;@casmcfarland&lt;/a&gt;&amp;nbsp;wrote:&lt;BR /&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;This works, but now I need to aggregate to 6 month intervals but a rolling 6 months so 1/2006-6/2006, 2/2006-7/2006, 3/2006-8/2006 etc.&amp;nbsp;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892"&gt;@PaigeMiller&lt;/a&gt;&amp;nbsp;I have reviewed your recommendations of how to post my question; however, I do not have code that is not working, I am trying to figure out where to start. And I simply trying to get some insight of different methods to try because I am stuck. Your instructions are not helping me.&lt;/P&gt;
&lt;HR /&gt;&lt;/BLOCKQUOTE&gt;
&lt;P&gt;I'm not asking to see your code. I am asking for a working copy of (a portion of) your data, and I linked to instructions that will allow you to provide&amp;nbsp;(a portion of) your data in a form I can work with. I can't write working code for you without a working copy of (a portion of) your data.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;The general idea to sum over many different time intervals is to create a multi-label format and then do the summing in PROC SUMMARY with the multilabel format assigned to the variable. Here is the general idea:&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;proc format;
    value datef (multilabel)
        '01JAN2006'd-'30JUN2006'd = '01JAN2006'
        '01FEB2006'd-'31JUL2006'd = '01FEB2006'
        /* and so on */
    ;
run;

proc summary data=yourdatasetname;
    class yourdatevariable / mlf;
    var frisk furtive /* all your variables that are supposed to be summed go here */;
    output out=sums sum=;
    format yourdatevariable datef.;
run;&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;Again, I can't give you more code until I have a working copy of your data.&lt;/P&gt;</description>
      <pubDate>Sat, 03 Jul 2021 15:42:34 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751894#M236770</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-07-03T15:42:34Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751926#M236790</link>
      <description>&lt;P&gt;Perhaps this will help you.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;In a thread earlier in the week, a person made a request to have sums computed over the previous year (not next six months as you are asking). You can see the solution here: &lt;A href="https://communities.sas.com/t5/SAS-Programming/Moving-average-by-site-and-date/m-p/751510#M236586" target="_blank" rel="noopener"&gt;https://communities.sas.com/t5/SAS-Programming/Moving-average-by-site-and-date/m-p/751510#M236586&lt;/A&gt;. Changing from previous one year to next six months ought to be relatively simple. Also please note that in this thread, the person asking the question provided data in a usable form, and so I was able to provide code for his exact data set.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 03 Jul 2021 19:08:44 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751926#M236790</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-07-03T19:08:44Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751968#M236807</link>
      <description>&lt;P&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892"&gt;@PaigeMiller&lt;/a&gt;&amp;nbsp; I can understand that downloading a .xlsx can be an issue. Not sure why downloading a .sas7bdat should be of any concern.&lt;/P&gt;
&lt;P&gt;Below the data step created using&amp;nbsp;&lt;A href="https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/" target="_blank" rel="noopener"&gt;https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/&lt;/A&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;data work.SQFAGGFINAL1;
  infile datalines dsd truncover;
  input sqfmthyr:YYMMN6. tract2010:F11. friskcount:32. furtcount:32. searchcount:32. arrestcount:32.;
  format sqfmthyr YYMMN6. tract2010 F11.;
  label tract2010="tract2010";
datalines4;
200602,36005000200,1,0,0,0
200602,36005000200,0,0,0,0
200602,36005000200,1,0,0,0
200603,36005000200,1,0,0,0
200604,36005000200,1,0,0,0
200605,36005000200,1,0,0,0
200605,36005000200,0,2,0,0
200606,36005000200,2,2,0,0
200606,36005000200,1,1,0,1
200606,36005000200,1,1,0,0
200606,36005000200,1,1,0,0
200607,36005000200,2,0,0,0
200607,36005000200,2,0,0,0
200607,36005000200,0,0,0,0
200608,36005000200,2,2,1,1
200608,36005000200,1,0,0,1
200609,36005000200,3,3,0,0
200610,36005000200,0,0,0,0
200612,36005000200,1,1,1,0
200612,36005000200,2,1,0,0
200612,36005000200,1,1,0,0
200701,36005000200,0,1,0,0
200701,36005000200,1,0,0,0
200701,36005000200,2,2,0,0
200702,36005000200,1,1,0,0
200703,36005000200,0,0,0,0
200703,36005000200,2,1,1,0
200704,36005000200,1,0,0,0
200705,36005000200,1,0,0,0
200705,36005000200,0,0,0,0
200705,36005000200,1,0,0,0
200705,36005000200,5,5,0,0
200705,36005000200,0,1,0,0
200706,36005000200,0,0,0,0
200706,36005000200,1,0,0,0
200706,36005000200,1,0,0,0
200708,36005000200,6,0,0,0
200709,36005000200,1,1,0,0
200709,36005000200,1,1,0,0
200710,36005000200,1,0,0,0
200710,36005000200,1,0,0,0
200710,36005000200,1,1,0,0
200711,36005000200,0,0,0,0
200712,36005000200,1,1,1,0
200712,36005000200,1,0,0,0
200801,36005000200,1,1,0,0
200801,36005000200,1,0,0,0
200801,36005000200,1,1,1,0
200802,36005000200,2,1,0,0
200802,36005000200,2,2,0,0
200803,36005000200,0,1,0,0
200803,36005000200,2,2,0,0
200804,36005000200,1,1,0,0
200804,36005000200,0,0,0,0
200804,36005000200,1,1,0,0
200805,36005000200,2,0,2,3
200805,36005000200,1,1,0,0
200805,36005000200,1,0,1,0
200806,36005000200,0,1,0,0
200806,36005000200,0,1,0,0
200807,36005000200,1,2,0,0
200807,36005000200,1,1,0,0
200807,36005000200,1,1,0,0
200808,36005000200,0,1,0,0
200808,36005000200,1,0,0,0
200808,36005000200,3,4,0,0
200808,36005000200,1,0,0,0
200809,36005000200,0,1,0,0
200809,36005000200,1,0,0,0
200809,36005000200,0,0,0,0
200809,36005000200,1,1,0,0
200809,36005000200,1,0,0,0
200809,36005000200,1,0,0,0
200809,36005000200,0,2,0,0
200810,36005000200,0,1,0,0
200810,36005000200,1,1,0,0
200810,36005000200,0,1,0,0
200810,36005000200,2,0,0,0
200811,36005000200,0,1,0,0
200901,36005000200,0,1,0,0
200901,36005000200,1,1,0,0
200901,36005000200,1,2,1,0
200902,36005000200,1,0,1,1
200902,36005000200,1,0,0,0
200902,36005000200,0,1,0,0
200902,36005000200,1,0,1,0
200902,36005000200,1,1,0,0
200902,36005000200,1,0,1,0
200903,36005000200,2,0,0,0
200903,36005000200,0,0,0,0
200904,36005000200,0,0,0,0
200904,36005000200,1,0,1,1
200904,36005000200,1,1,1,1
200905,36005000200,1,1,0,0
200905,36005000200,1,1,1,1
200906,36005000200,1,1,0,0
200906,36005000200,1,1,1,1
200907,36005000200,0,0,0,0
200907,36005000200,1,1,0,0
200907,36005000200,0,0,0,0
200907,36005000200,0,2,0,0
200908,36005000200,1,0,0,1
200908,36005000200,0,1,0,0
200908,36005000200,1,0,0,0
200908,36005000200,1,0,0,0
200909,36005000200,0,1,0,0
200909,36005000200,1,0,0,0
200911,36005000200,2,0,0,0
200911,36005000200,2,1,0,0
200911,36005000200,1,0,1,0
200912,36005000200,0,0,0,0
200912,36005000200,1,1,0,0
200912,36005000200,1,0,0,0
201001,36005000200,3,0,0,0
201001,36005000200,1,1,0,0
201001,36005000200,2,0,0,0
201001,36005000200,0,1,0,0
201002,36005000200,1,1,1,0
201003,36005000200,2,0,0,0
201003,36005000200,2,1,2,0
201003,36005000200,0,0,0,0
201003,36005000200,3,2,0,0
201004,36005000200,5,0,0,0
201004,36005000200,4,0,0,0
201004,36005000200,3,2,0,0
201004,36005000200,1,1,0,0
201005,36005000200,1,1,1,1
201005,36005000200,1,0,0,0
201005,36005000200,1,1,0,0
201005,36005000200,0,1,0,0
201005,36005000200,0,0,0,0
201006,36005000200,1,0,0,0
201006,36005000200,4,0,0,0
201006,36005000200,4,3,2,0
201006,36005000200,4,1,2,0
201007,36005000200,0,0,0,0
201007,36005000200,1,1,0,0
201007,36005000200,1,0,0,0
201007,36005000200,1,1,0,0
201008,36005000200,0,1,0,0
201008,36005000200,1,1,0,0
201008,36005000200,1,1,0,0
201008,36005000200,1,0,0,1
201008,36005000200,1,0,0,0
201008,36005000200,2,0,0,0
201009,36005000200,0,0,0,0
201009,36005000200,1,0,0,0
201009,36005000200,1,1,0,0
201009,36005000200,0,0,0,1
201010,36005000200,1,1,1,0
201010,36005000200,1,0,0,0
201011,36005000200,0,0,0,0
201011,36005000200,0,0,0,0
201011,36005000200,1,2,0,0
201011,36005000200,0,0,0,0
201012,36005000200,1,0,1,0
201101,36005000200,1,1,0,0
201101,36005000200,1,0,1,1
201101,36005000200,0,3,0,0
201102,36005000200,0,0,0,0
201103,36005000200,4,4,0,0
201103,36005000200,1,1,0,0
201104,36005000200,1,1,0,0
201105,36005000200,0,0,0,0
201106,36005000200,6,4,1,0
201106,36005000200,2,0,0,0
201107,36005000200,1,1,0,0
201107,36005000200,0,0,0,0
201107,36005000200,0,1,0,0
201108,36005000200,0,0,0,1
201108,36005000200,0,0,0,0
201108,36005000200,1,1,1,1
201109,36005000200,0,0,0,0
201110,36005000200,2,2,0,0
201110,36005000200,0,0,0,0
201110,36005000200,2,3,0,0
201110,36005000200,0,0,0,0
201110,36005000200,0,1,0,0
201110,36005000200,1,0,0,0
201110,36005000200,1,1,1,1
201111,36005000200,1,1,0,0
201111,36005000200,0,0,0,0
201111,36005000200,1,0,0,0
201111,36005000200,0,1,0,0
201111,36005000200,1,3,0,0
201111,36005000200,1,0,0,0
201111,36005000200,0,0,0,0
201112,36005000200,1,1,0,0
201112,36005000200,4,1,2,0
201112,36005000200,0,1,0,0
201112,36005000200,1,2,0,0
201112,36005000200,1,0,0,0
201112,36005000200,0,0,0,0
201112,36005000200,1,1,0,0
201112,36005000200,0,3,0,0
201201,36005000200,1,1,0,0
201201,36005000200,0,1,0,0
201201,36005000200,0,0,0,0
201201,36005000200,0,0,0,0
201201,36005000200,2,2,0,0
201201,36005000200,0,0,0,0
201201,36005000200,0,0,0,0
201202,36005000200,1,1,0,0
201202,36005000200,0,2,0,1
201202,36005000200,0,0,0,0
201202,36005000200,1,1,0,0
201203,36005000200,4,0,0,0
201203,36005000200,0,5,0,0
201203,36005000200,1,1,0,0
201203,36005000200,1,3,0,1
201203,36005000200,0,1,0,0
201203,36005000200,0,0,0,0
201204,36005000200,3,0,1,1
201204,36005000200,0,1,0,0
201204,36005000200,0,0,0,0
201205,36005000200,4,0,0,0
201205,36005000200,1,1,0,0
201205,36005000200,1,0,0,1
201205,36005000200,2,1,0,0
201205,36005000200,2,0,0,0
201205,36005000200,1,1,0,0
201205,36005000200,1,0,0,0
201205,36005000200,1,0,0,0
201205,36005000200,1,1,0,0
201205,36005000200,0,0,0,0
201205,36005000200,1,0,0,0
201206,36005000200,1,0,1,1
201206,36005000200,2,2,0,0
201206,36005000200,1,0,0,0
201207,36005000200,2,0,2,2
201208,36005000200,0,0,0,0
201208,36005000200,1,1,1,0
201209,36005000200,0,1,0,0
201210,36005000200,0,0,0,0
201210,36005000200,1,0,2,2
201210,36005000200,1,0,0,0
201211,36005000200,1,1,0,0
201211,36005000200,1,1,0,0
201211,36005000200,2,2,0,0
201211,36005000200,1,0,1,1
201301,36005000200,1,0,1,1
201302,36005000200,1,2,0,0
201302,36005000200,2,2,0,0
201302,36005000200,0,0,0,0
201302,36005000200,1,0,0,0
201302,36005000200,1,0,1,0
201302,36005000200,1,1,0,0
201303,36005000200,0,0,0,0
201303,36005000200,1,1,0,0
201305,36005000200,0,0,0,0
201305,36005000200,0,0,0,0
201306,36005000200,1,1,0,0
201404,36005000200,0,0,0,0
201508,36005000200,0,0,0,0
201509,36005000200,1,0,0,0
201612,36005000200,4,0,1,0
200601,36047030700,1,1,0,0
200601,36047030700,2,1,0,0
200601,36047030700,2,2,0,0
200601,36047030700,1,1,0,0
200601,36047030700,3,1,0,0
200601,36047030700,0,0,0,0
200601,36047030700,3,2,0,0
200601,36047030700,1,4,0,0
200601,36047030700,1,1,0,0
200601,36047030700,1,1,0,0
200601,36047030700,0,0,0,0
200601,36047030700,1,0,0,0
200601,36047030700,0,0,0,0
200601,36047030700,5,1,0,0
200601,36047030700,1,1,0,0
200601,36047030700,1,1,0,0
200601,36047030700,0,0,0,0
200601,36047030700,0,0,0,0
200601,36047030700,1,1,0,0
200601,36047030700,2,1,0,0
200601,36047030700,0,0,0,0
200601,36047030700,4,0,0,0
200601,36047030700,0,0,0,0
200601,36047030700,2,1,0,0
200602,36047030700,1,0,1,0
200602,36047030700,2,5,1,0
200602,36047030700,1,1,0,1
200602,36047030700,0,1,0,0
200602,36047030700,0,0,0,0
200602,36047030700,1,1,1,1
200602,36047030700,2,1,0,0
200602,36047030700,0,0,0,0
200602,36047030700,0,0,0,0
200602,36047030700,0,1,0,0
200602,36047030700,2,1,0,0
200602,36047030700,0,0,0,0
200602,36047030700,0,1,0,0
200602,36047030700,0,0,0,0
200602,36047030700,2,2,0,0
200602,36047030700,0,0,0,0
200602,36047030700,2,0,0,0
200602,36047030700,1,0,0,0
200602,36047030700,1,1,1,1
200602,36047030700,1,0,0,0
200602,36047030700,0,0,0,0
200603,36047030700,1,1,0,0
200603,36047030700,2,2,0,0
200603,36047030700,1,1,0,0
200603,36047030700,0,0,0,0
200603,36047030700,3,1,0,0
200603,36047030700,2,1,1,2
200603,36047030700,0,1,0,0
200603,36047030700,1,2,1,0
200603,36047030700,2,0,0,0
200603,36047030700,2,2,1,1
200603,36047030700,3,0,0,0
200603,36047030700,7,2,0,0
200603,36047030700,4,4,0,0
200603,36047030700,11,11,4,0
200603,36047030700,4,4,1,1
200603,36047030700,3,0,0,0
200603,36047030700,4,1,0,0
200603,36047030700,2,1,0,0
200603,36047030700,1,1,1,0
200603,36047030700,1,2,0,0
200603,36047030700,3,6,1,1
200603,36047030700,1,0,0,0
200603,36047030700,2,2,0,0
200603,36047030700,3,3,0,0
200603,36047030700,0,2,0,0
200603,36047030700,1,1,0,0
200603,36047030700,1,1,0,0
200604,36047030700,1,1,0,0
200604,36047030700,1,0,0,0
200604,36047030700,4,2,0,0
200604,36047030700,0,0,0,0
200604,36047030700,0,0,0,0
200604,36047030700,1,0,0,0
200604,36047030700,0,0,0,0
200604,36047030700,0,0,0,0
200604,36047030700,2,2,0,0
200604,36047030700,3,1,0,0
200604,36047030700,5,6,0,0
200604,36047030700,2,0,1,0
200604,36047030700,1,0,0,0
200604,36047030700,0,0,0,0
200604,36047030700,0,2,0,0
200604,36047030700,0,0,0,0
200604,36047030700,0,2,0,0
200604,36047030700,1,1,0,0
200604,36047030700,1,1,1,1
200604,36047030700,1,0,0,0
200604,36047030700,1,0,0,0
200604,36047030700,0,0,0,0
200604,36047030700,0,1,0,0
200604,36047030700,0,0,0,0
200604,36047030700,1,0,0,0
200605,36047030700,1,1,0,0
200605,36047030700,0,1,0,0
200605,36047030700,0,0,0,0
200605,36047030700,0,0,0,0
200605,36047030700,1,1,0,0
200605,36047030700,1,0,0,0
200605,36047030700,0,0,0,0
200605,36047030700,1,1,0,0
200605,36047030700,4,1,0,0
200605,36047030700,0,1,0,0
200605,36047030700,0,0,0,0
200605,36047030700,0,0,0,0
200605,36047030700,1,0,0,0
200605,36047030700,0,1,0,0
200605,36047030700,0,1,0,0
200605,36047030700,0,0,0,0
200605,36047030700,0,0,0,0
200605,36047030700,0,0,0,0
200605,36047030700,1,0,0,0
200605,36047030700,1,1,0,0
200605,36047030700,1,1,0,0
200605,36047030700,1,1,0,0
200605,36047030700,3,2,1,0
200605,36047030700,0,0,0,0
200605,36047030700,1,0,0,0
200605,36047030700,1,2,0,0
200606,36047030700,2,0,0,0
200606,36047030700,1,0,0,0
200606,36047030700,0,0,0,0
200606,36047030700,0,0,0,0
200606,36047030700,2,0,0,0
200606,36047030700,0,1,0,0
200606,36047030700,0,0,0,0
200606,36047030700,0,0,0,0
200606,36047030700,0,0,0,0
200606,36047030700,0,0,0,0
200606,36047030700,1,0,0,0
200606,36047030700,1,0,0,0
200606,36047030700,0,0,0,0
200606,36047030700,1,0,0,0
200606,36047030700,2,1,0,0
200606,36047030700,0,0,0,0
200606,36047030700,1,1,0,0
200607,36047030700,1,0,0,0
200607,36047030700,0,0,0,0
200607,36047030700,0,1,0,0
200607,36047030700,0,1,0,0
200607,36047030700,0,2,0,0
200607,36047030700,0,1,0,0
200607,36047030700,0,1,0,0
200607,36047030700,4,3,0,0
200607,36047030700,1,1,0,0
200607,36047030700,1,0,0,0
200607,36047030700,0,0,0,0
200607,36047030700,0,0,0,0
200607,36047030700,1,0,0,0
200607,36047030700,0,0,0,0
200607,36047030700,1,0,0,0
200607,36047030700,2,2,0,0
200607,36047030700,3,4,1,0
200608,36047030700,1,1,0,0
200608,36047030700,0,0,0,0
200608,36047030700,0,0,0,0
200608,36047030700,0,0,0,1
200608,36047030700,1,1,0,0
200608,36047030700,1,0,0,0
200608,36047030700,0,0,0,0
200608,36047030700,1,1,1,0
200608,36047030700,1,1,1,0
200608,36047030700,1,0,0,0
200608,36047030700,2,2,0,0
200608,36047030700,4,3,0,0
200608,36047030700,0,0,0,0
200608,36047030700,1,0,0,0
200608,36047030700,1,1,0,0
200608,36047030700,1,0,0,0
200609,36047030700,0,0,0,0
200609,36047030700,0,2,0,0
200609,36047030700,0,0,0,0
200609,36047030700,0,1,0,0
200609,36047030700,1,1,0,0
200609,36047030700,3,0,0,0
200609,36047030700,0,1,0,0
200609,36047030700,1,0,0,0
200609,36047030700,2,2,0,0
200610,36047030700,0,1,0,0
200610,36047030700,3,0,0,0
200610,36047030700,16,11,0,0
200610,36047030700,1,1,0,0
200610,36047030700,2,1,0,0
200610,36047030700,1,1,0,0
200610,36047030700,1,1,0,0
200610,36047030700,2,0,0,0
200610,36047030700,5,1,1,1
200610,36047030700,3,0,1,0
200610,36047030700,1,1,0,0
200610,36047030700,1,0,0,0
200610,36047030700,2,2,0,0
200610,36047030700,3,2,0,0
200610,36047030700,0,3,0,0
200610,36047030700,2,1,0,0
200610,36047030700,3,2,1,0
200610,36047030700,6,1,0,0
200611,36047030700,1,1,0,0
200611,36047030700,2,1,1,1
200611,36047030700,3,3,0,0
200611,36047030700,1,2,0,0
200611,36047030700,1,1,0,0
200611,36047030700,0,0,0,0
200611,36047030700,0,0,0,0
200611,36047030700,0,0,0,0
200611,36047030700,0,1,0,0
200611,36047030700,0,0,0,0
200611,36047030700,0,0,0,0
200611,36047030700,1,1,0,0
200611,36047030700,2,0,0,0
200611,36047030700,1,0,0,0
200611,36047030700,2,2,0,0
200611,36047030700,2,3,0,0
200611,36047030700,0,1,0,0
200611,36047030700,1,1,0,0
200611,36047030700,11,11,0,0
200611,36047030700,4,3,1,0
200612,36047030700,1,1,0,0
200612,36047030700,0,0,0,0
200612,36047030700,4,5,0,0
200612,36047030700,1,1,0,0
200612,36047030700,4,4,0,0
200612,36047030700,0,2,0,0
200612,36047030700,2,2,0,1
200612,36047030700,2,0,0,0
200612,36047030700,2,2,0,0
200612,36047030700,0,1,0,0
200612,36047030700,1,1,0,0
200612,36047030700,1,0,0,0
200612,36047030700,0,0,0,0
200612,36047030700,0,1,0,0
200612,36047030700,1,1,0,0
200701,36047030700,0,1,0,0
200701,36047030700,3,2,0,0
200701,36047030700,0,1,0,0
200701,36047030700,0,0,0,0
200701,36047030700,0,1,0,1
200701,36047030700,1,1,0,0
200701,36047030700,1,0,0,0
200701,36047030700,1,1,0,0
200701,36047030700,1,0,0,0
200701,36047030700,1,1,0,0
200701,36047030700,2,1,0,0
200701,36047030700,2,0,0,0
200701,36047030700,1,0,0,0
200701,36047030700,1,0,0,0
200701,36047030700,2,1,0,0
200701,36047030700,0,1,0,0
200701,36047030700,0,0,0,0
200701,36047030700,0,0,0,0
200701,36047030700,1,1,0,0
200701,36047030700,1,1,0,0
200701,36047030700,0,1,0,0
200702,36047030700,0,0,0,0
200702,36047030700,0,1,0,0
200702,36047030700,3,1,2,1
200702,36047030700,1,1,0,0
200702,36047030700,0,2,0,0
200702,36047030700,1,0,0,0
200702,36047030700,1,0,0,0
200702,36047030700,0,1,0,0
200702,36047030700,0,0,0,0
200702,36047030700,1,1,0,0
200702,36047030700,1,3,1,1
200702,36047030700,1,1,0,0
200702,36047030700,2,2,0,0
200702,36047030700,1,3,0,0
200702,36047030700,1,2,1,0
200702,36047030700,1,2,0,0
200702,36047030700,2,0,0,0
200702,36047030700,1,0,0,0
200702,36047030700,0,1,0,0
200702,36047030700,3,1,0,0
200702,36047030700,6,1,0,0
200703,36047030700,0,1,0,0
200703,36047030700,1,0,0,0
200703,36047030700,2,1,0,0
200703,36047030700,2,4,0,0
200703,36047030700,1,1,0,0
200703,36047030700,0,2,0,0
200703,36047030700,1,2,0,0
200703,36047030700,1,1,0,0
200703,36047030700,1,0,0,0
200703,36047030700,0,0,0,0
200703,36047030700,1,1,0,0
200703,36047030700,0,1,0,0
200703,36047030700,0,2,0,0
200703,36047030700,0,0,0,0
200703,36047030700,1,0,0,0
200703,36047030700,0,0,0,0
200703,36047030700,0,0,0,0
200703,36047030700,2,2,0,0
200703,36047030700,0,0,0,0
200703,36047030700,0,0,0,0
200704,36047030700,0,0,0,0
200704,36047030700,1,0,0,0
200704,36047030700,1,1,0,0
200704,36047030700,0,0,0,0
200704,36047030700,1,1,0,0
200704,36047030700,0,0,0,0
200704,36047030700,0,0,0,0
200704,36047030700,0,0,0,0
200704,36047030700,2,2,0,0
200704,36047030700,0,2,0,0
200704,36047030700,0,4,0,0
200704,36047030700,1,3,0,0
200704,36047030700,0,0,0,0
200704,36047030700,0,0,0,0
200704,36047030700,1,1,0,0
200704,36047030700,1,0,0,0
200704,36047030700,2,2,0,0
200704,36047030700,4,4,1,0
200704,36047030700,3,3,0,0
200704,36047030700,1,0,0,0
200705,36047030700,0,2,0,0
200705,36047030700,1,1,0,0
200705,36047030700,0,0,0,0
200705,36047030700,0,0,0,0
200705,36047030700,0,2,0,1
200705,36047030700,3,1,0,0
200705,36047030700,1,1,0,0
200705,36047030700,1,1,0,0
200705,36047030700,1,0,0,0
200705,36047030700,0,1,0,0
200705,36047030700,1,1,0,0
200705,36047030700,0,0,0,0
200705,36047030700,0,0,0,0
200705,36047030700,0,0,0,0
200705,36047030700,0,0,0,0
200705,36047030700,1,1,0,0
200706,36047030700,0,1,0,0
200706,36047030700,1,0,0,0
200706,36047030700,1,1,1,0
200706,36047030700,1,1,0,0
200706,36047030700,1,0,0,0
200706,36047030700,5,0,0,0
200706,36047030700,1,0,0,1
200706,36047030700,0,0,0,0
200706,36047030700,1,0,1,1
200706,36047030700,2,2,0,0
200706,36047030700,1,1,0,0
200707,36047030700,1,1,0,0
200707,36047030700,1,0,0,0
200707,36047030700,1,0,0,1
200707,36047030700,0,0,0,0
200707,36047030700,1,1,1,1
200707,36047030700,1,0,0,0
200707,36047030700,1,1,0,0
200707,36047030700,0,2,0,0
200707,36047030700,1,2,0,0
200707,36047030700,1,2,0,0
200707,36047030700,3,2,0,0
200707,36047030700,2,1,0,0
200707,36047030700,1,1,0,0
200708,36047030700,3,5,0,0
200708,36047030700,4,2,0,1
200708,36047030700,2,2,0,0
200708,36047030700,4,1,0,0
200708,36047030700,1,1,1,1
200708,36047030700,3,3,0,0
200708,36047030700,1,1,0,0
200708,36047030700,0,1,0,0
200708,36047030700,1,1,0,0
200708,36047030700,0,1,0,0
200708,36047030700,0,0,0,1
200708,36047030700,1,1,0,0
200708,36047030700,1,0,0,0
200708,36047030700,1,2,0,0
200708,36047030700,3,1,1,0
200708,36047030700,1,1,1,1
200708,36047030700,2,0,0,0
200708,36047030700,1,1,0,0
200708,36047030700,1,1,0,0
200709,36047030700,5,3,0,0
200709,36047030700,1,0,0,0
200709,36047030700,1,1,0,0
200709,36047030700,8,6,0,0
200709,36047030700,2,1,0,0
200709,36047030700,4,4,0,0
200709,36047030700,0,0,0,0
200709,36047030700,2,2,0,0
200709,36047030700,0,2,0,0
200709,36047030700,0,1,0,0
200709,36047030700,3,2,0,0
200709,36047030700,2,2,0,0
200709,36047030700,3,4,0,0
200709,36047030700,3,2,1,0
200709,36047030700,1,0,0,0
200709,36047030700,2,2,0,0
200709,36047030700,2,2,0,0
200709,36047030700,2,2,0,0
200709,36047030700,8,8,0,0
200709,36047030700,5,2,2,0
200709,36047030700,2,2,0,0
200709,36047030700,0,3,0,0
200709,36047030700,1,1,0,0
200709,36047030700,2,2,0,0
200709,36047030700,1,1,0,0
200709,36047030700,1,1,0,0
200710,36047030700,0,0,1,1
200710,36047030700,1,0,1,0
200710,36047030700,1,1,0,0
200710,36047030700,0,0,0,0
200710,36047030700,3,2,0,0
200710,36047030700,1,1,1,1
200710,36047030700,1,1,0,0
200710,36047030700,0,0,0,0
200710,36047030700,3,0,0,0
200710,36047030700,5,7,1,0
200710,36047030700,1,1,0,0
200710,36047030700,12,9,2,0
200710,36047030700,6,4,1,1
200710,36047030700,3,4,1,0
200710,36047030700,4,3,1,1
200710,36047030700,6,1,0,0
200710,36047030700,4,3,1,2
200710,36047030700,5,3,0,0
200710,36047030700,6,4,0,1
200710,36047030700,5,5,0,0
200710,36047030700,2,0,0,0
200710,36047030700,7,5,0,0
200710,36047030700,0,0,0,0
200710,36047030700,1,1,0,0
200710,36047030700,2,2,1,1
200710,36047030700,2,2,0,0
200710,36047030700,1,2,0,0
200710,36047030700,1,1,0,0
200710,36047030700,0,0,0,0
200710,36047030700,0,1,0,0
200711,36047030700,1,1,0,0
200711,36047030700,1,0,0,0
200711,36047030700,1,4,0,1
200711,36047030700,2,5,1,0
200711,36047030700,1,1,1,0
200711,36047030700,2,2,0,0
200711,36047030700,2,3,0,0
200711,36047030700,1,1,0,1
200711,36047030700,0,1,0,0
200711,36047030700,0,0,0,0
200711,36047030700,0,0,0,0
200711,36047030700,2,0,1,1
200711,36047030700,1,1,0,0
200711,36047030700,1,0,0,0
200711,36047030700,0,1,0,0
200711,36047030700,1,1,0,0
200711,36047030700,3,2,2,2
200711,36047030700,4,3,0,0
200711,36047030700,4,1,1,2
200711,36047030700,2,2,0,0
200712,36047030700,1,1,0,0
200712,36047030700,0,0,0,0
200712,36047030700,2,2,0,0
200712,36047030700,2,1,1,1
200712,36047030700,2,2,0,1
200712,36047030700,6,6,0,0
200712,36047030700,2,2,0,0
200712,36047030700,1,5,0,0
200712,36047030700,3,3,2,2
200712,36047030700,6,6,0,0
200712,36047030700,3,2,1,0
200712,36047030700,2,2,0,0
200712,36047030700,1,1,1,1
200712,36047030700,2,2,0,0
200801,36047030700,3,1,0,0
200801,36047030700,0,0,0,0
200801,36047030700,4,2,1,1
200801,36047030700,11,9,1,1
200801,36047030700,3,1,0,0
200801,36047030700,0,3,0,0
200801,36047030700,3,3,0,0
200801,36047030700,0,2,0,0
200801,36047030700,0,2,0,0
200801,36047030700,3,3,2,3
200801,36047030700,3,3,0,0
200801,36047030700,6,5,0,0
200801,36047030700,5,3,0,0
200801,36047030700,0,0,0,0
200801,36047030700,0,0,0,0
200801,36047030700,2,1,0,1
200801,36047030700,1,0,0,0
200801,36047030700,3,1,0,0
200801,36047030700,2,0,0,0
200801,36047030700,3,3,0,0
200801,36047030700,3,2,1,0
200802,36047030700,1,4,0,0
200802,36047030700,3,1,2,2
200802,36047030700,1,4,1,1
200802,36047030700,1,0,0,0
200802,36047030700,2,1,0,0
200802,36047030700,0,0,0,0
200802,36047030700,0,1,0,0
200802,36047030700,0,0,0,0
200802,36047030700,2,3,0,0
200802,36047030700,2,3,0,0
200802,36047030700,1,1,0,0
200802,36047030700,1,1,1,1
200802,36047030700,0,0,0,0
200802,36047030700,0,1,0,0
200802,36047030700,2,4,1,1
200802,36047030700,3,1,0,0
200802,36047030700,2,2,0,0
200803,36047030700,2,1,0,0
200803,36047030700,1,2,0,0
200803,36047030700,1,3,0,0
200803,36047030700,1,0,0,0
200803,36047030700,1,3,0,0
200803,36047030700,10,7,1,1
200803,36047030700,1,1,0,0
200803,36047030700,0,2,0,0
200803,36047030700,2,2,0,0
200803,36047030700,5,4,0,0
200803,36047030700,3,0,0,0
200803,36047030700,0,0,0,0
200803,36047030700,1,0,0,0
200803,36047030700,0,1,0,0
200803,36047030700,3,2,1,2
200803,36047030700,1,0,0,0
200803,36047030700,1,1,0,0
200803,36047030700,2,1,1,1
200803,36047030700,0,1,0,0
200803,36047030700,0,0,0,0
200803,36047030700,1,0,2,2
200803,36047030700,2,1,0,0
200803,36047030700,3,4,0,0
200803,36047030700,0,3,0,0
200804,36047030700,1,1,1,0
200804,36047030700,2,2,0,0
200804,36047030700,4,1,3,4
200804,36047030700,6,0,0,0
200804,36047030700,6,4,3,0
200804,36047030700,1,0,0,0
200804,36047030700,2,2,0,0
200804,36047030700,0,0,0,0
200804,36047030700,3,0,0,0
200804,36047030700,3,3,1,1
200804,36047030700,0,0,0,1
200804,36047030700,2,2,2,2
200804,36047030700,3,3,0,0
200804,36047030700,1,1,0,0
200804,36047030700,2,1,0,0
200804,36047030700,1,3,0,0
200804,36047030700,1,1,1,0
200804,36047030700,1,1,0,0
200805,36047030700,0,0,0,0
200805,36047030700,1,0,0,0
200805,36047030700,2,2,0,1
200805,36047030700,1,0,0,1
200805,36047030700,0,0,0,1
200805,36047030700,0,0,0,0
200805,36047030700,3,3,2,2
200805,36047030700,1,1,1,1
200805,36047030700,4,5,0,2
200805,36047030700,1,0,1,1
200805,36047030700,0,0,0,0
200805,36047030700,2,2,0,0
200805,36047030700,2,1,0,0
200805,36047030700,2,2,0,0
200805,36047030700,1,1,0,2
200805,36047030700,3,2,1,1
200805,36047030700,2,2,0,0
200805,36047030700,0,1,0,0
200805,36047030700,3,3,0,0
200805,36047030700,1,2,0,1
200805,36047030700,6,7,1,1
200805,36047030700,3,3,1,1
200805,36047030700,10,13,0,0
200806,36047030700,3,3,1,1
200806,36047030700,5,4,1,0
200806,36047030700,1,2,0,1
200806,36047030700,8,5,0,2
200806,36047030700,6,3,0,0
200806,36047030700,3,3,1,1
200806,36047030700,1,1,0,0
200806,36047030700,1,3,0,0
200806,36047030700,0,1,0,0
200806,36047030700,1,0,1,1
200806,36047030700,2,1,0,1
200806,36047030700,4,4,0,0
200806,36047030700,3,5,0,0
200806,36047030700,4,3,0,0
200806,36047030700,0,0,0,0
200806,36047030700,1,1,0,0
200806,36047030700,5,3,0,0
200806,36047030700,2,0,1,0
200806,36047030700,1,2,0,0
200806,36047030700,2,2,0,0
200806,36047030700,1,0,0,0
200806,36047030700,1,1,0,0
200806,36047030700,0,0,0,0
200806,36047030700,0,0,0,0
200807,36047030700,1,0,1,1
200807,36047030700,1,1,0,0
200807,36047030700,0,0,0,0
200807,36047030700,5,5,0,0
200807,36047030700,2,2,0,0
200807,36047030700,1,0,0,0
200807,36047030700,0,0,0,0
200807,36047030700,1,0,0,0
200807,36047030700,2,2,0,0
200807,36047030700,0,1,0,0
200807,36047030700,1,1,0,0
200807,36047030700,1,1,2,2
200807,36047030700,1,2,0,0
200807,36047030700,1,1,0,0
200807,36047030700,3,0,0,0
200807,36047030700,1,0,0,0
200807,36047030700,2,1,1,0
200808,36047030700,3,6,0,0
200808,36047030700,0,0,0,0
200808,36047030700,2,1,0,0
200808,36047030700,7,9,0,0
200808,36047030700,5,3,0,0
200808,36047030700,0,2,0,0
200808,36047030700,1,1,1,1
200808,36047030700,0,3,0,0
200808,36047030700,1,0,0,0
200808,36047030700,4,1,1,1
200808,36047030700,1,0,0,0
200808,36047030700,0,0,0,0
200808,36047030700,0,0,0,0
200808,36047030700,2,3,1,1
200808,36047030700,2,4,0,0
200808,36047030700,1,3,0,0
200808,36047030700,2,0,0,0
200808,36047030700,1,0,0,0
200808,36047030700,0,1,0,1
200808,36047030700,0,0,0,0
200808,36047030700,1,1,1,0
200808,36047030700,0,3,0,0
200808,36047030700,0,1,0,0
200808,36047030700,1,2,0,0
200808,36047030700,3,1,0,1
200808,36047030700,1,1,0,0
200809,36047030700,0,1,0,0
200809,36047030700,2,3,0,0
200809,36047030700,1,0,0,0
200809,36047030700,1,0,0,0
200809,36047030700,0,1,0,0
200809,36047030700,1,1,0,0
200809,36047030700,2,3,0,0
200809,36047030700,2,2,1,1
200809,36047030700,2,0,0,0
200809,36047030700,1,1,0,0
200809,36047030700,0,1,0,0
200809,36047030700,5,5,0,0
200809,36047030700,2,4,0,0
200809,36047030700,1,2,0,0
200809,36047030700,4,4,1,1
200809,36047030700,4,3,1,2
200809,36047030700,1,1,1,1
200809,36047030700,3,3,1,0
200809,36047030700,2,2,0,0
200809,36047030700,1,0,0,0
200809,36047030700,0,1,0,1
200809,36047030700,1,1,0,0
200810,36047030700,1,0,1,1
200810,36047030700,1,0,0,0
200810,36047030700,6,2,1,2
200810,36047030700,2,2,0,0
200810,36047030700,2,4,0,0
200810,36047030700,1,0,0,0
200810,36047030700,2,2,1,0
200810,36047030700,3,3,1,0
200810,36047030700,1,1,0,0
200810,36047030700,2,3,1,0
200810,36047030700,0,0,0,0
200810,36047030700,2,1,0,0
200810,36047030700,2,2,2,2
200810,36047030700,1,1,0,0
200810,36047030700,1,0,0,0
200810,36047030700,3,1,1,2
200810,36047030700,4,5,0,1
200810,36047030700,3,3,0,0
200810,36047030700,3,4,0,0
200810,36047030700,0,1,0,0
200810,36047030700,2,2,0,0
200810,36047030700,0,1,0,0
200810,36047030700,1,1,0,0
200810,36047030700,1,1,0,0
200810,36047030700,0,2,0,0
200811,36047030700,3,1,0,0
200811,36047030700,0,0,0,0
200811,36047030700,1,0,0,0
200811,36047030700,0,0,0,0
200811,36047030700,0,1,0,0
200811,36047030700,3,4,0,0
200811,36047030700,1,0,1,0
200811,36047030700,1,1,0,0
200811,36047030700,1,0,0,0
200811,36047030700,0,2,0,1
200811,36047030700,1,1,0,0
200811,36047030700,0,4,0,0
200811,36047030700,1,2,0,0
200811,36047030700,1,2,0,0
200811,36047030700,1,3,0,0
200811,36047030700,2,2,0,0
200811,36047030700,0,0,0,0
200811,36047030700,0,0,0,0
200811,36047030700,1,0,0,0
200811,36047030700,2,2,0,0
200812,36047030700,1,1,0,0
200812,36047030700,3,4,0,0
200812,36047030700,2,1,0,0
200812,36047030700,0,0,0,0
200812,36047030700,1,1,1,1
200812,36047030700,0,2,0,1
200812,36047030700,1,1,0,0
200812,36047030700,1,1,0,0
200812,36047030700,1,1,0,0
200812,36047030700,1,1,0,0
200812,36047030700,2,0,0,0
200812,36047030700,1,0,0,0
200812,36047030700,0,0,0,1
200812,36047030700,0,0,0,0
200812,36047030700,5,5,0,0
200812,36047030700,1,0,1,0
200812,36047030700,3,3,0,0
200812,36047030700,5,5,0,0
200901,36047030700,1,1,0,0
200901,36047030700,1,1,0,0
200901,36047030700,1,0,0,0
200901,36047030700,3,3,0,0
200901,36047030700,1,0,1,1
200901,36047030700,1,1,0,0
200901,36047030700,2,0,0,0
200901,36047030700,0,0,0,0
200901,36047030700,1,1,0,0
200901,36047030700,5,3,3,4
200901,36047030700,1,2,0,0
200901,36047030700,3,2,1,0
200901,36047030700,6,5,2,1
200901,36047030700,3,2,0,1
200901,36047030700,0,1,0,0
200901,36047030700,0,1,0,0
200901,36047030700,3,3,0,0
200901,36047030700,0,2,0,0
200901,36047030700,1,1,0,0
200901,36047030700,2,3,0,0
200901,36047030700,1,0,0,0
200901,36047030700,2,2,0,0
200901,36047030700,5,10,1,1
200901,36047030700,5,4,0,0
200901,36047030700,2,1,0,0
200901,36047030700,2,0,0,0
200901,36047030700,0,1,0,0
200902,36047030700,0,0,0,0
200902,36047030700,0,1,0,0
200902,36047030700,3,2,0,0
200902,36047030700,0,1,0,0
200902,36047030700,3,3,1,0
200902,36047030700,2,3,0,0
200902,36047030700,1,1,0,0
200902,36047030700,2,2,0,0
200902,36047030700,2,1,1,0
200902,36047030700,4,4,0,0
200902,36047030700,1,2,0,0
200902,36047030700,1,1,0,0
200902,36047030700,1,3,0,0
200902,36047030700,0,1,0,0
200902,36047030700,1,0,0,0
200902,36047030700,1,0,1,1
200902,36047030700,2,1,0,0
200902,36047030700,1,0,0,0
200902,36047030700,0,0,0,0
200902,36047030700,3,3,0,0
200902,36047030700,3,3,1,2
200903,36047030700,0,1,0,0
200903,36047030700,2,2,0,0
200903,36047030700,0,0,0,0
200903,36047030700,3,3,0,0
200903,36047030700,0,1,0,0
200903,36047030700,1,1,0,1
200903,36047030700,0,0,0,0
200903,36047030700,1,1,0,0
200903,36047030700,0,1,0,0
200903,36047030700,1,1,0,0
200903,36047030700,3,5,0,0
200903,36047030700,1,0,0,0
200903,36047030700,2,4,1,2
200903,36047030700,1,1,0,0
200903,36047030700,2,5,1,2
200903,36047030700,1,3,0,0
200903,36047030700,3,1,0,0
200903,36047030700,0,1,0,0
200903,36047030700,1,0,0,0
200903,36047030700,2,2,0,0
200903,36047030700,1,1,0,1
200903,36047030700,0,0,0,0
200903,36047030700,0,0,0,0
200904,36047030700,0,0,0,0
200904,36047030700,1,1,0,0
200904,36047030700,0,0,0,0
200904,36047030700,1,1,0,0
200904,36047030700,1,0,0,0
200904,36047030700,0,1,0,0
200904,36047030700,1,2,1,0
200904,36047030700,0,1,0,0
200904,36047030700,0,3,0,0
200904,36047030700,1,1,0,0
200904,36047030700,1,0,1,0
200904,36047030700,0,1,0,0
200904,36047030700,0,0,0,0
200904,36047030700,1,2,1,1
200904,36047030700,0,2,0,0
200904,36047030700,1,1,0,0
200904,36047030700,5,2,0,0
200904,36047030700,6,3,4,0
200904,36047030700,0,0,0,1
200904,36047030700,3,1,0,0
200904,36047030700,1,1,1,0
200904,36047030700,1,1,0,0
200904,36047030700,0,0,0,0
200904,36047030700,1,1,0,0
200905,36047030700,2,4,0,0
200905,36047030700,3,3,0,0
200905,36047030700,0,0,0,0
200905,36047030700,1,0,0,0
200905,36047030700,0,1,0,0
200905,36047030700,1,0,0,0
200905,36047030700,1,1,0,0
200905,36047030700,2,4,0,2
200905,36047030700,1,0,0,0
200905,36047030700,0,0,1,1
200905,36047030700,2,1,0,1
200905,36047030700,4,2,0,0
200905,36047030700,0,1,1,1
200905,36047030700,1,1,0,0
200905,36047030700,2,2,0,0
200905,36047030700,1,2,0,0
200905,36047030700,1,1,0,0
200905,36047030700,2,1,0,0
200905,36047030700,0,1,0,0
200905,36047030700,2,4,0,1
200905,36047030700,1,0,0,0
200905,36047030700,3,1,0,0
200905,36047030700,0,1,0,1
200905,36047030700,0,2,0,0
200906,36047030700,3,3,0,0
200906,36047030700,4,4,1,1
200906,36047030700,0,0,0,0
200906,36047030700,1,1,0,0
200906,36047030700,0,0,0,0
200906,36047030700,0,2,0,0
200906,36047030700,1,1,0,0
200906,36047030700,0,1,0,0
200906,36047030700,0,2,0,0
200906,36047030700,1,1,0,0
200906,36047030700,1,0,0,1
200906,36047030700,2,1,0,0
200906,36047030700,4,2,0,0
200906,36047030700,1,2,0,0
200906,36047030700,0,0,0,0
200906,36047030700,1,1,0,0
200906,36047030700,0,2,0,0
200907,36047030700,2,2,1,2
200907,36047030700,0,0,0,0
200907,36047030700,0,0,0,0
200907,36047030700,0,1,0,0
200907,36047030700,0,0,0,0
200907,36047030700,3,2,1,1
200907,36047030700,0,0,0,0
200907,36047030700,0,1,0,0
200907,36047030700,1,2,0,0
200907,36047030700,1,2,0,1
200907,36047030700,0,0,0,0
200907,36047030700,1,2,0,0
200907,36047030700,0,1,0,0
200907,36047030700,0,1,0,0
200907,36047030700,1,1,0,0
200907,36047030700,2,1,1,1
200907,36047030700,0,1,0,0
200907,36047030700,0,0,0,1
200907,36047030700,1,1,1,0
200907,36047030700,2,2,1,0
200907,36047030700,1,1,0,0
200907,36047030700,0,4,0,0
200907,36047030700,0,1,0,0
200907,36047030700,0,0,0,0
200907,36047030700,1,2,0,0
200907,36047030700,1,1,0,0
200908,36047030700,2,0,2,5
200908,36047030700,4,6,0,0
200908,36047030700,0,0,0,0
200908,36047030700,1,0,0,0
200908,36047030700,1,1,0,0
200908,36047030700,2,2,0,0
200908,36047030700,0,1,0,0
200908,36047030700,0,1,0,0
200908,36047030700,3,3,3,2
200908,36047030700,4,7,0,0
200908,36047030700,0,0,0,0
200908,36047030700,0,0,0,0
200908,36047030700,0,3,0,0
200908,36047030700,4,4,1,0
200908,36047030700,1,1,0,0
200908,36047030700,1,1,0,0
200908,36047030700,2,2,0,0
200908,36047030700,0,0,0,0
200909,36047030700,2,2,0,0
200909,36047030700,0,0,2,1
200909,36047030700,2,2,0,0
200909,36047030700,1,0,0,0
200909,36047030700,3,9,0,0
200909,36047030700,0,1,0,0
200909,36047030700,1,0,0,0
200909,36047030700,1,1,0,0
200909,36047030700,1,1,0,0
200909,36047030700,1,1,0,0
200909,36047030700,0,1,0,0
200909,36047030700,1,1,2,1
200909,36047030700,1,2,0,1
200909,36047030700,2,2,0,1
200909,36047030700,1,1,0,0
200909,36047030700,3,6,0,0
200909,36047030700,0,0,0,0
200909,36047030700,0,1,0,0
200909,36047030700,3,1,3,3
200909,36047030700,0,1,0,0
200909,36047030700,3,2,0,0
200909,36047030700,7,3,2,2
200909,36047030700,2,1,0,2
200909,36047030700,1,5,0,0
200909,36047030700,1,2,0,0
200909,36047030700,1,2,0,0
200910,36047030700,2,2,0,0
200910,36047030700,0,2,0,0
200910,36047030700,2,2,0,0
200910,36047030700,1,4,0,1
200910,36047030700,0,1,0,0
200910,36047030700,3,4,0,0
200910,36047030700,0,2,0,0
200910,36047030700,4,4,1,2
200910,36047030700,3,1,0,1
200910,36047030700,4,3,1,1
200910,36047030700,2,2,0,0
200910,36047030700,0,1,0,0
200910,36047030700,1,2,0,1
200910,36047030700,0,0,0,0
200910,36047030700,0,2,0,0
200910,36047030700,2,2,0,0
200910,36047030700,1,0,0,0
200910,36047030700,1,0,0,0
200910,36047030700,1,2,1,1
200910,36047030700,1,1,0,0
200910,36047030700,1,4,1,1
200910,36047030700,3,4,0,0
200910,36047030700,1,1,0,0
200910,36047030700,1,1,0,0
200910,36047030700,2,1,0,0
200910,36047030700,1,1,0,0
200910,36047030700,1,2,1,1
200910,36047030700,1,3,0,0
200910,36047030700,1,3,1,0
200911,36047030700,1,0,0,0
200911,36047030700,0,1,0,0
200911,36047030700,1,1,0,0
200911,36047030700,3,2,1,1
200911,36047030700,3,3,2,2
200911,36047030700,5,1,1,2
200911,36047030700,3,3,2,2
200911,36047030700,0,0,0,3
200911,36047030700,0,0,0,0
200911,36047030700,4,4,1,0
200911,36047030700,1,0,0,0
200911,36047030700,2,2,1,1
200911,36047030700,0,0,0,0
200911,36047030700,0,2,0,0
200911,36047030700,0,0,0,0
200911,36047030700,0,1,0,0
200911,36047030700,2,5,0,0
200911,36047030700,0,1,0,0
200911,36047030700,1,1,0,0
200911,36047030700,3,6,0,0
200911,36047030700,1,1,0,0
200911,36047030700,0,1,0,0
200911,36047030700,3,2,0,0
200911,36047030700,5,9,3,0
200911,36047030700,1,0,0,0
200912,36047030700,1,1,0,0
200912,36047030700,4,4,0,1
200912,36047030700,3,0,0,0
200912,36047030700,3,1,0,0
200912,36047030700,1,0,0,0
200912,36047030700,0,2,0,0
200912,36047030700,1,2,1,0
200912,36047030700,1,4,0,0
200912,36047030700,0,1,0,0
200912,36047030700,2,2,0,0
200912,36047030700,1,1,0,0
200912,36047030700,0,1,0,0
200912,36047030700,1,1,0,0
200912,36047030700,3,1,3,2
200912,36047030700,2,4,3,3
200912,36047030700,1,1,0,0
200912,36047030700,2,4,0,0
200912,36047030700,2,1,1,1
200912,36047030700,1,1,1,1
200912,36047030700,0,0,0,0
200912,36047030700,0,1,0,0
200912,36047030700,1,1,0,0
201001,36047030700,2,1,0,0
201001,36047030700,2,2,0,0
201001,36047030700,2,1,1,0
201001,36047030700,2,3,0,1
201001,36047030700,3,1,0,0
201001,36047030700,16,18,3,1
201001,36047030700,1,1,0,0
201001,36047030700,2,3,1,2
201001,36047030700,2,4,0,0
201001,36047030700,0,3,0,0
201001,36047030700,0,1,0,0
201001,36047030700,1,0,0,0
201001,36047030700,1,2,0,0
201001,36047030700,2,2,0,0
201001,36047030700,7,6,0,0
201001,36047030700,4,5,1,1
201001,36047030700,2,2,0,1
201001,36047030700,4,1,0,0
201001,36047030700,2,3,0,0
201001,36047030700,5,3,4,4
201001,36047030700,4,4,0,0
201001,36047030700,0,1,0,0
201001,36047030700,1,1,0,0
201001,36047030700,0,0,0,0
201001,36047030700,1,1,0,1
201001,36047030700,2,4,1,1
201002,36047030700,4,7,2,7
201002,36047030700,1,1,0,0
201002,36047030700,6,3,1,2
201002,36047030700,1,3,1,1
201002,36047030700,1,1,0,1
201002,36047030700,0,1,0,0
201002,36047030700,2,2,0,0
201002,36047030700,3,2,1,2
201002,36047030700,2,1,0,1
201002,36047030700,4,2,2,0
201002,36047030700,2,2,0,3
201002,36047030700,1,3,0,0
201002,36047030700,0,0,0,0
201002,36047030700,1,0,0,0
201002,36047030700,0,1,0,0
201002,36047030700,1,0,0,0
201002,36047030700,4,2,0,0
201002,36047030700,0,0,0,0
201002,36047030700,1,2,1,0
201002,36047030700,0,1,0,0
201002,36047030700,2,1,0,0
201002,36047030700,0,0,0,0
201002,36047030700,1,0,0,0
201003,36047030700,0,0,0,0
201003,36047030700,4,3,0,0
201003,36047030700,2,2,0,0
201003,36047030700,1,0,1,1
201003,36047030700,2,2,0,0
201003,36047030700,0,1,0,0
201003,36047030700,2,4,0,2
201003,36047030700,1,0,0,0
201003,36047030700,1,2,0,0
201003,36047030700,0,2,0,1
201003,36047030700,1,1,0,0
201003,36047030700,1,0,0,0
201003,36047030700,1,1,0,0
201003,36047030700,0,0,0,0
201003,36047030700,2,4,0,0
201003,36047030700,1,0,0,0
201003,36047030700,5,2,0,1
201003,36047030700,3,2,1,0
201003,36047030700,3,3,1,0
201003,36047030700,0,1,0,0
201003,36047030700,1,1,0,0
201003,36047030700,1,0,0,0
201003,36047030700,2,3,0,0
201004,36047030700,1,2,0,1
201004,36047030700,2,1,0,0
201004,36047030700,1,1,1,1
201004,36047030700,0,1,0,0
201004,36047030700,0,1,0,0
201004,36047030700,0,0,0,0
201004,36047030700,1,2,0,0
201004,36047030700,0,0,0,0
201004,36047030700,0,1,0,0
201004,36047030700,2,3,0,1
201004,36047030700,1,1,0,0
201004,36047030700,5,4,0,0
201004,36047030700,2,4,1,1
201004,36047030700,1,1,0,0
201004,36047030700,1,2,0,0
201004,36047030700,2,2,0,0
201004,36047030700,1,1,1,0
201004,36047030700,2,1,1,0
201004,36047030700,1,1,0,0
201004,36047030700,0,2,0,0
201004,36047030700,0,2,0,0
201004,36047030700,0,1,0,0
201004,36047030700,2,5,0,0
201005,36047030700,1,0,0,0
201005,36047030700,10,9,0,0
201005,36047030700,0,1,0,1
201005,36047030700,8,6,0,0
201005,36047030700,4,4,0,0
201005,36047030700,2,1,0,1
201005,36047030700,1,0,0,0
201005,36047030700,0,0,0,0
201005,36047030700,3,3,0,0
201005,36047030700,0,0,0,0
201005,36047030700,2,3,0,0
201005,36047030700,0,3,0,0
201005,36047030700,2,1,1,1
201005,36047030700,2,1,0,0
201005,36047030700,0,1,0,0
201005,36047030700,3,3,0,0
201005,36047030700,0,0,0,0
201005,36047030700,1,1,0,0
201005,36047030700,6,5,1,2
201005,36047030700,2,0,0,0
201005,36047030700,2,2,0,0
201005,36047030700,0,0,0,0
201005,36047030700,1,1,1,0
201006,36047030700,2,2,1,1
201006,36047030700,0,2,0,0
201006,36047030700,0,1,0,0
201006,36047030700,0,0,1,1
201006,36047030700,0,0,0,0
201006,36047030700,1,1,0,0
201006,36047030700,1,1,0,0
201006,36047030700,2,1,1,1
201006,36047030700,1,1,0,1
201006,36047030700,4,3,1,1
201006,36047030700,0,5,0,0
201006,36047030700,0,1,0,0
201006,36047030700,3,2,0,0
201006,36047030700,0,1,0,0
201006,36047030700,1,1,0,0
201006,36047030700,0,1,0,0
201006,36047030700,1,2,0,1
201006,36047030700,1,0,0,0
201006,36047030700,2,2,0,0
201006,36047030700,0,1,0,0
201007,36047030700,3,4,1,1
201007,36047030700,2,3,0,0
201007,36047030700,0,1,0,0
201007,36047030700,1,0,0,0
201007,36047030700,1,1,0,0
201007,36047030700,0,1,0,0
201007,36047030700,0,0,0,0
201007,36047030700,0,1,0,0
201007,36047030700,0,1,0,1
201007,36047030700,2,3,0,1
201007,36047030700,0,1,0,0
201007,36047030700,3,1,2,2
201007,36047030700,0,0,0,0
201007,36047030700,0,0,0,0
201007,36047030700,0,1,0,0
201007,36047030700,0,1,0,0
201007,36047030700,1,1,1,0
201007,36047030700,1,1,0,0
201007,36047030700,0,2,0,0
201007,36047030700,7,7,0,0
201008,36047030700,4,3,0,0
201008,36047030700,2,1,1,0
201008,36047030700,1,1,0,0
201008,36047030700,3,2,0,1
201008,36047030700,0,1,0,0
201008,36047030700,1,0,0,0
201008,36047030700,2,4,0,0
201008,36047030700,3,3,1,1
201008,36047030700,0,1,0,0
201008,36047030700,0,1,0,0
201008,36047030700,1,2,0,0
201008,36047030700,1,7,0,0
201008,36047030700,3,4,0,0
201008,36047030700,1,1,0,0
201008,36047030700,3,4,0,0
201008,36047030700,4,4,0,0
201008,36047030700,3,3,0,0
201008,36047030700,1,2,0,0
201008,36047030700,0,2,0,0
201008,36047030700,4,3,0,0
201008,36047030700,2,2,0,0
201008,36047030700,6,6,0,0
201008,36047030700,2,2,0,0
201008,36047030700,1,5,0,0
201008,36047030700,7,8,0,1
201008,36047030700,0,3,0,0
201008,36047030700,1,0,0,0
201009,36047030700,2,1,2,2
201009,36047030700,0,1,0,1
201009,36047030700,0,0,0,1
201009,36047030700,5,2,1,0
201009,36047030700,3,2,0,0
201009,36047030700,0,0,0,0
201009,36047030700,0,1,0,0
201009,36047030700,1,2,0,0
201009,36047030700,0,0,0,0
201009,36047030700,6,2,0,0
201009,36047030700,0,2,0,0
201009,36047030700,1,0,0,0
201009,36047030700,1,1,0,0
201009,36047030700,2,2,1,0
201009,36047030700,1,1,0,0
201009,36047030700,3,3,1,1
201009,36047030700,2,3,1,2
201009,36047030700,1,1,0,0
201009,36047030700,1,1,0,1
201009,36047030700,1,2,0,0
201009,36047030700,0,0,0,0
201009,36047030700,1,1,0,0
201009,36047030700,1,1,0,0
201009,36047030700,0,0,0,0
201009,36047030700,0,0,0,0
201009,36047030700,3,3,0,0
201010,36047030700,1,1,0,0
201010,36047030700,3,3,0,0
201010,36047030700,6,9,0,0
201010,36047030700,1,1,0,0
201010,36047030700,0,0,0,0
201010,36047030700,0,1,0,0
201010,36047030700,1,1,0,0
201010,36047030700,0,0,1,1
201010,36047030700,0,1,0,0
201010,36047030700,0,2,0,0
201010,36047030700,5,1,2,2
201010,36047030700,1,0,0,0
201010,36047030700,0,1,0,2
201010,36047030700,1,0,1,0
201010,36047030700,4,7,1,0
201010,36047030700,0,1,0,0
201010,36047030700,0,0,0,0
201010,36047030700,2,2,1,1
201010,36047030700,1,0,0,0
201010,36047030700,1,1,0,0
201010,36047030700,0,0,0,0
201010,36047030700,5,3,0,1
201010,36047030700,1,1,0,0
201010,36047030700,2,2,0,0
201010,36047030700,2,3,1,1
201010,36047030700,1,2,0,0
201010,36047030700,3,1,0,0
201010,36047030700,2,2,0,0
201011,36047030700,1,0,1,1
201011,36047030700,3,3,0,0
201011,36047030700,1,1,0,0
201011,36047030700,0,0,0,0
201011,36047030700,2,4,2,2
201011,36047030700,3,2,0,0
201011,36047030700,1,1,0,0
201011,36047030700,1,1,0,0
201011,36047030700,1,2,0,0
201011,36047030700,5,5,0,0
201011,36047030700,2,1,0,0
201011,36047030700,0,0,0,0
201011,36047030700,0,0,0,0
201011,36047030700,1,2,0,0
201011,36047030700,1,1,0,0
201011,36047030700,1,1,0,0
201011,36047030700,3,2,0,0
201011,36047030700,0,0,0,0
201011,36047030700,0,0,0,0
201012,36047030700,1,1,0,0
201012,36047030700,1,1,0,0
201012,36047030700,3,2,1,0
201012,36047030700,6,6,0,0
201012,36047030700,2,3,0,0
201012,36047030700,2,0,2,0
201012,36047030700,2,2,0,0
201012,36047030700,5,5,0,0
201012,36047030700,3,8,0,0
201012,36047030700,6,7,1,1
201012,36047030700,1,1,0,0
201012,36047030700,0,1,0,0
201012,36047030700,2,2,1,1
201012,36047030700,2,2,0,1
201012,36047030700,6,0,1,0
201012,36047030700,7,6,0,2
201012,36047030700,1,1,0,0
201012,36047030700,1,4,0,0
201012,36047030700,2,2,0,0
201012,36047030700,1,0,0,0
201012,36047030700,1,0,1,1
201012,36047030700,0,0,0,0
201101,36047030700,1,1,0,0
201101,36047030700,1,1,0,1
201101,36047030700,2,2,0,0
201101,36047030700,2,2,1,1
201101,36047030700,2,3,2,3
201101,36047030700,2,2,1,1
201101,36047030700,1,1,0,0
201101,36047030700,0,4,0,0
201101,36047030700,1,0,1,0
201101,36047030700,1,1,0,0
201101,36047030700,3,4,1,1
201101,36047030700,0,1,0,0
201101,36047030700,0,0,0,0
201101,36047030700,1,4,0,0
201101,36047030700,2,1,1,0
201101,36047030700,0,0,0,0
201101,36047030700,0,1,0,0
201101,36047030700,0,0,0,0
201101,36047030700,3,0,0,0
201101,36047030700,0,4,0,0
201101,36047030700,1,1,0,0
201101,36047030700,2,3,0,0
201101,36047030700,0,0,0,0
201101,36047030700,0,0,0,0
201101,36047030700,0,3,0,0
201101,36047030700,2,4,0,1
201101,36047030700,0,0,0,1
201102,36047030700,2,3,0,0
201102,36047030700,1,0,1,1
201102,36047030700,7,7,3,2
201102,36047030700,7,6,3,1
201102,36047030700,2,1,1,2
201102,36047030700,0,1,0,0
201102,36047030700,1,1,0,0
201102,36047030700,1,1,0,0
201102,36047030700,3,3,1,1
201102,36047030700,1,1,0,0
201102,36047030700,1,1,1,1
201102,36047030700,2,2,1,1
201102,36047030700,2,4,0,0
201102,36047030700,2,0,0,0
201102,36047030700,1,1,0,0
201102,36047030700,1,2,0,0
201102,36047030700,4,2,0,0
201102,36047030700,6,6,2,0
201102,36047030700,1,2,1,1
201102,36047030700,1,3,0,0
201102,36047030700,1,1,0,0
201102,36047030700,4,3,0,0
201102,36047030700,1,0,0,0
201102,36047030700,6,6,0,0
201102,36047030700,2,2,2,2
201102,36047030700,5,4,1,3
201102,36047030700,2,2,0,0
201103,36047030700,1,0,1,1
201103,36047030700,2,1,1,0
201103,36047030700,3,1,0,0
201103,36047030700,4,1,0,0
201103,36047030700,0,0,1,1
201103,36047030700,2,3,0,1
201103,36047030700,2,1,1,2
201103,36047030700,4,3,0,3
201103,36047030700,2,3,1,1
201103,36047030700,1,1,0,0
201103,36047030700,0,0,0,0
201103,36047030700,0,1,0,0
201103,36047030700,3,1,2,2
201103,36047030700,0,0,0,0
201103,36047030700,4,4,0,0
201103,36047030700,5,5,1,1
201103,36047030700,1,1,1,1
201103,36047030700,0,0,0,0
201103,36047030700,2,2,0,0
201103,36047030700,0,0,0,0
201103,36047030700,0,1,0,0
201103,36047030700,2,0,1,1
201103,36047030700,2,1,0,1
201103,36047030700,0,1,0,0
201103,36047030700,0,1,0,0
201104,36047030700,1,1,0,0
201104,36047030700,7,6,1,1
201104,36047030700,7,9,0,1
201104,36047030700,2,3,0,0
201104,36047030700,7,8,2,2
201104,36047030700,4,2,1,1
201104,36047030700,3,3,1,1
201104,36047030700,2,1,1,1
201104,36047030700,4,6,1,1
201104,36047030700,0,1,0,0
201104,36047030700,1,1,0,0
201104,36047030700,1,2,0,0
201104,36047030700,1,3,0,0
201104,36047030700,1,2,0,0
201104,36047030700,1,4,0,0
201104,36047030700,0,1,0,1
201104,36047030700,0,1,0,0
201104,36047030700,1,0,0,0
201104,36047030700,1,1,0,0
201104,36047030700,2,1,0,0
201104,36047030700,3,3,0,0
201104,36047030700,5,5,1,1
201104,36047030700,1,3,0,0
201104,36047030700,0,0,0,0
201104,36047030700,5,5,0,0
201104,36047030700,0,1,0,0
201104,36047030700,3,1,1,1
201104,36047030700,1,0,0,0
201105,36047030700,0,0,0,0
201105,36047030700,0,0,0,0
201105,36047030700,4,3,0,0
201105,36047030700,1,1,1,0
201105,36047030700,1,2,0,0
201105,36047030700,1,1,0,0
201105,36047030700,1,1,0,1
201105,36047030700,0,0,0,0
201105,36047030700,4,2,1,0
201105,36047030700,1,1,0,0
201105,36047030700,1,0,0,0
201105,36047030700,1,1,0,0
201105,36047030700,2,2,1,0
201105,36047030700,0,0,0,0
201105,36047030700,4,3,1,0
201105,36047030700,2,1,0,0
201105,36047030700,4,1,0,1
201105,36047030700,3,3,0,0
201105,36047030700,1,1,0,1
201105,36047030700,1,0,0,0
201106,36047030700,1,3,1,0
201106,36047030700,0,0,0,0
201106,36047030700,2,2,0,0
201106,36047030700,2,0,1,1
201106,36047030700,1,1,0,0
201106,36047030700,2,0,0,0
201106,36047030700,2,2,1,0
201106,36047030700,0,0,0,0
201106,36047030700,1,0,0,0
201106,36047030700,1,1,0,0
201106,36047030700,0,1,0,0
201106,36047030700,2,2,0,0
201106,36047030700,2,2,0,0
201106,36047030700,4,4,0,0
201106,36047030700,2,2,0,0
201107,36047030700,2,3,0,1
201107,36047030700,0,0,1,1
201107,36047030700,4,6,0,0
201107,36047030700,1,0,1,1
201107,36047030700,3,3,0,0
201107,36047030700,0,1,0,1
201107,36047030700,1,1,0,0
201107,36047030700,1,2,0,0
201107,36047030700,1,2,0,0
201107,36047030700,2,3,0,0
201107,36047030700,2,2,0,0
201107,36047030700,1,1,0,0
201107,36047030700,0,1,0,0
201107,36047030700,2,1,0,0
201107,36047030700,0,0,0,0
201107,36047030700,2,3,0,0
201107,36047030700,1,1,0,0
201107,36047030700,1,1,0,0
201107,36047030700,3,1,0,0
201107,36047030700,2,1,0,0
201107,36047030700,1,2,0,0
201107,36047030700,2,0,0,0
201107,36047030700,1,1,0,0
201107,36047030700,7,3,0,2
201108,36047030700,0,2,0,1
201108,36047030700,0,4,0,1
201108,36047030700,1,1,0,0
201108,36047030700,0,0,0,0
201108,36047030700,0,1,0,0
201108,36047030700,3,2,2,1
201108,36047030700,2,4,0,0
201108,36047030700,7,6,1,1
201108,36047030700,0,0,0,0
201108,36047030700,1,0,0,0
201108,36047030700,0,1,0,0
201108,36047030700,0,0,0,0
201108,36047030700,0,3,0,0
201108,36047030700,0,1,0,0
201108,36047030700,1,1,0,0
201108,36047030700,0,0,0,0
201108,36047030700,1,0,0,0
201108,36047030700,0,0,0,0
201108,36047030700,1,1,0,0
201108,36047030700,0,0,0,0
201108,36047030700,0,1,0,0
201108,36047030700,2,2,0,0
201109,36047030700,1,1,0,0
201109,36047030700,1,1,1,0
201109,36047030700,4,2,1,0
201109,36047030700,3,0,0,0
201109,36047030700,1,1,0,0
201109,36047030700,1,1,0,0
201109,36047030700,3,3,0,0
201109,36047030700,0,0,0,0
201109,36047030700,1,2,1,1
201109,36047030700,2,2,0,0
201109,36047030700,0,0,0,0
201109,36047030700,4,2,0,0
201109,36047030700,0,0,0,0
201109,36047030700,3,2,2,2
201109,36047030700,6,6,0,0
201109,36047030700,3,3,1,1
201109,36047030700,1,1,0,0
201109,36047030700,1,0,0,0
201109,36047030700,0,2,0,0
201109,36047030700,1,1,0,0
201109,36047030700,2,2,0,0
201109,36047030700,0,0,0,0
201110,36047030700,0,1,0,0
201110,36047030700,3,5,1,0
201110,36047030700,1,1,0,0
201110,36047030700,3,3,0,0
201110,36047030700,0,0,0,0
201110,36047030700,6,3,2,5
201110,36047030700,1,1,0,0
201110,36047030700,1,1,0,0
201110,36047030700,2,4,0,0
201110,36047030700,7,6,0,0
201110,36047030700,2,1,1,0
201110,36047030700,1,1,0,0
201110,36047030700,2,2,1,2
201110,36047030700,0,1,0,0
201110,36047030700,2,1,0,0
201110,36047030700,1,1,0,0
201110,36047030700,0,2,0,0
201110,36047030700,0,1,0,0
201110,36047030700,1,0,0,0
201110,36047030700,1,0,0,0
201111,36047030700,1,1,0,0
201111,36047030700,1,1,0,0
201111,36047030700,0,1,0,0
201111,36047030700,2,1,0,0
201111,36047030700,1,1,0,0
201111,36047030700,4,4,0,0
201111,36047030700,2,4,0,0
201111,36047030700,1,2,0,0
201111,36047030700,1,1,0,1
201111,36047030700,1,1,0,0
201111,36047030700,0,1,0,0
201111,36047030700,5,1,1,1
201111,36047030700,0,1,0,0
201111,36047030700,1,1,0,0
201111,36047030700,0,1,0,0
201111,36047030700,0,0,0,0
201111,36047030700,2,2,0,0
201111,36047030700,1,1,0,0
201111,36047030700,3,1,0,0
201111,36047030700,1,1,0,0
201111,36047030700,2,1,0,1
201112,36047030700,2,3,0,0
201112,36047030700,0,1,0,0
201112,36047030700,1,1,0,0
201112,36047030700,1,1,0,0
201112,36047030700,2,7,0,0
201112,36047030700,0,0,0,1
201112,36047030700,2,0,1,0
201112,36047030700,0,0,0,0
201112,36047030700,2,6,0,0
201112,36047030700,0,2,0,0
201112,36047030700,2,3,0,0
201112,36047030700,0,2,0,1
201112,36047030700,0,0,0,0
201112,36047030700,0,1,0,0
201112,36047030700,0,0,0,0
201112,36047030700,0,1,0,0
201112,36047030700,6,2,0,0
201112,36047030700,1,0,0,0
201112,36047030700,2,0,0,0
201112,36047030700,5,5,1,1
201112,36047030700,1,0,0,0
201112,36047030700,0,1,0,1
201112,36047030700,3,0,0,0
201112,36047030700,1,0,0,0
201201,36047030700,0,1,0,0
201201,36047030700,2,1,0,0
201201,36047030700,4,3,1,3
201201,36047030700,2,3,0,1
201201,36047030700,2,2,0,0
201201,36047030700,0,0,0,0
201201,36047030700,3,2,0,0
201201,36047030700,1,2,0,0
201201,36047030700,1,1,0,0
201201,36047030700,1,1,0,0
201201,36047030700,1,1,0,0
201201,36047030700,1,3,0,0
201201,36047030700,1,0,0,0
201201,36047030700,4,6,0,0
201201,36047030700,0,0,0,0
201201,36047030700,3,4,1,1
201201,36047030700,1,1,1,0
201201,36047030700,0,1,0,0
201201,36047030700,0,1,0,0
201201,36047030700,1,1,1,0
201201,36047030700,5,1,2,1
201201,36047030700,1,1,0,1
201201,36047030700,3,2,0,1
201201,36047030700,3,2,1,0
201201,36047030700,1,1,0,0
201201,36047030700,5,3,0,0
201202,36047030700,3,3,0,0
201202,36047030700,1,1,0,0
201202,36047030700,1,1,0,0
201202,36047030700,0,1,0,0
201202,36047030700,1,0,0,0
201202,36047030700,1,2,0,0
201202,36047030700,2,2,1,1
201202,36047030700,0,1,0,0
201202,36047030700,0,1,0,0
201202,36047030700,1,2,0,0
201202,36047030700,2,2,0,0
201202,36047030700,1,2,0,0
201202,36047030700,2,0,3,1
201202,36047030700,1,0,0,0
201202,36047030700,2,2,0,0
201202,36047030700,1,1,0,0
201202,36047030700,1,0,0,0
201202,36047030700,1,2,0,0
201202,36047030700,2,1,0,0
201202,36047030700,1,1,0,0
201202,36047030700,1,0,0,0
201202,36047030700,1,3,0,0
201202,36047030700,1,2,0,0
201202,36047030700,1,1,0,0
201202,36047030700,2,1,0,0
201202,36047030700,1,1,0,0
201203,36047030700,1,2,0,0
201203,36047030700,5,4,1,2
201203,36047030700,1,2,0,0
201203,36047030700,1,3,0,0
201203,36047030700,0,0,0,0
201203,36047030700,1,1,0,0
201203,36047030700,6,4,2,0
201203,36047030700,1,1,0,0
201203,36047030700,0,2,0,0
201203,36047030700,1,6,0,0
201203,36047030700,0,0,0,0
201203,36047030700,2,1,0,1
201203,36047030700,3,3,0,0
201203,36047030700,3,2,0,0
201203,36047030700,0,0,0,0
201203,36047030700,0,0,0,0
201203,36047030700,0,0,0,0
201203,36047030700,3,3,0,1
201203,36047030700,1,0,0,0
201203,36047030700,1,1,0,0
201203,36047030700,2,2,0,0
201203,36047030700,4,4,1,3
201203,36047030700,5,3,0,1
201203,36047030700,0,2,0,0
201203,36047030700,0,1,0,0
201203,36047030700,0,1,0,1
201203,36047030700,1,2,0,0
201203,36047030700,0,3,0,0
201204,36047030700,1,1,1,0
201204,36047030700,4,1,3,1
201204,36047030700,1,2,0,0
201204,36047030700,0,0,0,0
201204,36047030700,1,2,1,0
201204,36047030700,0,2,0,0
201204,36047030700,2,1,0,1
201204,36047030700,0,0,0,0
201204,36047030700,3,3,0,0
201204,36047030700,3,3,0,0
201204,36047030700,1,1,0,0
201204,36047030700,0,1,0,0
201204,36047030700,2,2,0,0
201204,36047030700,0,1,0,0
201204,36047030700,1,2,0,0
201204,36047030700,1,0,0,0
201204,36047030700,3,3,0,0
201204,36047030700,1,1,0,0
201204,36047030700,4,2,0,0
201204,36047030700,3,3,0,0
201204,36047030700,4,2,2,0
201204,36047030700,1,0,0,0
201205,36047030700,2,0,0,1
201205,36047030700,2,3,0,0
201205,36047030700,1,2,0,0
201205,36047030700,2,3,0,0
201205,36047030700,0,1,0,0
201205,36047030700,2,0,2,0
201205,36047030700,0,1,0,0
201205,36047030700,1,0,1,1
201205,36047030700,3,4,1,0
201205,36047030700,3,4,0,0
201205,36047030700,0,0,0,0
201205,36047030700,2,1,0,0
201205,36047030700,1,0,1,1
201205,36047030700,1,1,0,0
201205,36047030700,0,0,0,0
201205,36047030700,1,0,1,0
201205,36047030700,2,4,0,0
201205,36047030700,0,2,0,1
201205,36047030700,1,1,0,0
201205,36047030700,5,0,0,0
201205,36047030700,0,0,0,0
201205,36047030700,1,2,1,1
201205,36047030700,1,0,0,0
201206,36047030700,3,4,0,0
201206,36047030700,1,1,0,0
201206,36047030700,1,1,0,0
201206,36047030700,0,0,0,0
201206,36047030700,2,2,0,0
201206,36047030700,7,5,0,0
201206,36047030700,1,0,1,1
201206,36047030700,1,6,0,1
201206,36047030700,0,3,0,0
201206,36047030700,0,1,0,0
201206,36047030700,3,0,1,0
201206,36047030700,1,0,0,0
201206,36047030700,2,1,0,0
201206,36047030700,1,2,1,1
201206,36047030700,1,2,0,0
201206,36047030700,0,7,0,0
201206,36047030700,0,0,0,0
201206,36047030700,2,1,0,1
201206,36047030700,4,7,0,1
201206,36047030700,1,4,0,0
201206,36047030700,0,1,0,0
201206,36047030700,7,5,1,0
201206,36047030700,3,2,1,0
201206,36047030700,3,5,0,0
201207,36047030700,6,7,0,0
201207,36047030700,4,2,0,0
201207,36047030700,1,1,0,1
201207,36047030700,0,2,0,0
201207,36047030700,2,2,0,0
201207,36047030700,2,0,0,0
201207,36047030700,3,2,0,2
201207,36047030700,2,1,1,1
201207,36047030700,2,2,0,0
201207,36047030700,3,0,1,1
201207,36047030700,4,1,3,0
201207,36047030700,0,2,0,0
201207,36047030700,0,2,0,0
201207,36047030700,0,0,0,0
201207,36047030700,1,1,1,0
201207,36047030700,0,0,0,0
201207,36047030700,1,2,0,0
201207,36047030700,0,1,0,0
201207,36047030700,2,2,1,0
201207,36047030700,1,1,0,0
201208,36047030700,0,0,0,0
201208,36047030700,1,1,0,0
201208,36047030700,3,0,3,0
201208,36047030700,1,0,0,0
201208,36047030700,1,1,0,0
201208,36047030700,1,0,0,0
201208,36047030700,1,1,0,0
201208,36047030700,0,1,0,0
201208,36047030700,1,3,0,0
201208,36047030700,1,0,0,0
201209,36047030700,1,1,0,0
201209,36047030700,1,1,0,0
201209,36047030700,2,3,0,0
201209,36047030700,1,1,0,0
201209,36047030700,0,1,0,0
201209,36047030700,1,1,0,0
201209,36047030700,1,1,0,0
201209,36047030700,1,3,0,0
201209,36047030700,1,4,0,0
201209,36047030700,2,3,0,0
201209,36047030700,4,1,3,0
201209,36047030700,1,1,1,1
201209,36047030700,1,0,0,0
201209,36047030700,1,1,1,0
201209,36047030700,2,1,0,0
201209,36047030700,0,0,0,0
201209,36047030700,3,2,0,0
201209,36047030700,1,0,0,0
201209,36047030700,0,1,0,0
201209,36047030700,0,0,0,0
201209,36047030700,2,1,0,0
201210,36047030700,0,1,0,0
201210,36047030700,2,3,0,0
201210,36047030700,2,2,1,0
201210,36047030700,1,0,0,0
201210,36047030700,1,1,0,0
201210,36047030700,1,2,0,0
201210,36047030700,1,1,0,0
201210,36047030700,1,0,0,0
201210,36047030700,1,1,0,0
201210,36047030700,2,5,0,0
201210,36047030700,0,0,0,1
201210,36047030700,0,0,0,0
201211,36047030700,1,1,0,1
201211,36047030700,1,0,0,0
201211,36047030700,1,0,0,0
201211,36047030700,1,1,0,0
201211,36047030700,0,1,0,1
201211,36047030700,1,0,1,1
201211,36047030700,0,1,0,0
201211,36047030700,0,0,0,0
201211,36047030700,0,0,0,0
201211,36047030700,1,1,0,1
201212,36047030700,2,2,0,0
201212,36047030700,1,1,0,0
201212,36047030700,3,2,0,0
201212,36047030700,1,1,0,0
201212,36047030700,2,3,0,0
201212,36047030700,1,2,0,1
201212,36047030700,2,2,0,0
201212,36047030700,4,4,0,0
201212,36047030700,2,2,0,0
201212,36047030700,2,2,0,0
201212,36047030700,1,1,0,0
201212,36047030700,3,3,0,0
201212,36047030700,2,0,0,1
201212,36047030700,2,1,0,0
201212,36047030700,1,1,0,0
201212,36047030700,3,0,0,0
201212,36047030700,2,1,0,1
201212,36047030700,1,1,0,0
201212,36047030700,1,2,0,0
201301,36047030700,2,0,0,0
201301,36047030700,2,1,0,1
201301,36047030700,0,0,0,0
201301,36047030700,0,2,0,0
201301,36047030700,1,1,0,0
201301,36047030700,0,0,0,1
201301,36047030700,2,3,0,1
201301,36047030700,1,1,0,1
201301,36047030700,1,0,0,1
201301,36047030700,4,0,0,1
201301,36047030700,1,0,0,0
201301,36047030700,1,1,0,0
201301,36047030700,1,3,0,0
201301,36047030700,0,0,0,0
201301,36047030700,2,2,0,0
201301,36047030700,6,2,0,2
201301,36047030700,1,0,1,0
201301,36047030700,0,0,0,0
201301,36047030700,3,0,0,0
201301,36047030700,0,1,0,0
201301,36047030700,1,0,0,0
201302,36047030700,1,0,0,0
201302,36047030700,1,0,0,0
201302,36047030700,2,1,1,2
201302,36047030700,0,1,0,0
201302,36047030700,1,1,0,0
201302,36047030700,2,2,2,2
201302,36047030700,9,6,2,0
201302,36047030700,0,0,0,0
201302,36047030700,2,2,0,1
201302,36047030700,3,0,0,2
201302,36047030700,0,2,0,0
201302,36047030700,1,5,0,0
201302,36047030700,2,2,0,0
201302,36047030700,2,0,0,0
201302,36047030700,0,0,0,1
201302,36047030700,0,1,0,0
201302,36047030700,1,0,1,1
201302,36047030700,2,0,0,0
201302,36047030700,3,2,0,2
201302,36047030700,4,4,0,0
201303,36047030700,2,2,0,0
201303,36047030700,2,2,0,0
201303,36047030700,6,4,0,0
201303,36047030700,5,5,0,0
201303,36047030700,3,2,0,2
201303,36047030700,1,1,0,0
201303,36047030700,0,2,0,0
201303,36047030700,3,0,0,0
201303,36047030700,2,2,0,0
201303,36047030700,2,1,0,0
201303,36047030700,1,1,1,0
201303,36047030700,1,1,0,0
201303,36047030700,2,2,0,0
201303,36047030700,1,3,0,1
201303,36047030700,2,3,0,1
201303,36047030700,2,2,0,0
201303,36047030700,3,2,0,0
201303,36047030700,1,1,0,0
201303,36047030700,1,1,0,1
201303,36047030700,0,0,0,0
201304,36047030700,1,1,0,0
201304,36047030700,1,0,0,0
201304,36047030700,1,0,0,0
201304,36047030700,1,0,0,0
201304,36047030700,0,3,0,0
201304,36047030700,3,0,0,0
201304,36047030700,1,0,0,0
201304,36047030700,2,2,0,0
201304,36047030700,1,1,0,0
201304,36047030700,0,1,0,0
201304,36047030700,1,1,0,0
201304,36047030700,1,1,0,0
201304,36047030700,0,0,0,0
201305,36047030700,0,1,0,0
201305,36047030700,2,2,0,0
201305,36047030700,1,1,0,0
201305,36047030700,1,1,0,0
201305,36047030700,1,2,1,1
201305,36047030700,1,1,0,0
201305,36047030700,2,1,0,0
201305,36047030700,2,1,0,0
201305,36047030700,3,0,0,0
201305,36047030700,0,0,0,0
201305,36047030700,1,0,1,1
201305,36047030700,1,0,0,1
201305,36047030700,2,1,0,0
201306,36047030700,2,1,0,0
201306,36047030700,2,0,2,2
201306,36047030700,0,0,0,0
201306,36047030700,1,1,0,1
201306,36047030700,0,0,0,0
201306,36047030700,2,0,0,0
201306,36047030700,2,0,0,0
201306,36047030700,1,1,0,0
201306,36047030700,1,1,0,0
201306,36047030700,3,2,0,0
201306,36047030700,0,0,0,0
201306,36047030700,1,1,0,0
201306,36047030700,1,1,0,0
201306,36047030700,1,0,1,0
201306,36047030700,2,0,0,0
201307,36047030700,0,1,0,0
201307,36047030700,2,3,0,0
201307,36047030700,2,2,0,0
201307,36047030700,1,3,0,0
201307,36047030700,1,0,0,0
201307,36047030700,0,0,0,0
201307,36047030700,0,0,1,1
201307,36047030700,0,1,0,0
201307,36047030700,1,0,0,0
201307,36047030700,0,1,0,0
201308,36047030700,0,0,0,0
201308,36047030700,0,2,0,0
201308,36047030700,1,0,0,1
201308,36047030700,1,1,0,0
201309,36047030700,1,1,0,0
201309,36047030700,2,0,2,2
201310,36047030700,0,1,1,1
201310,36047030700,1,1,1,1
201310,36047030700,1,0,0,0
201311,36047030700,0,0,0,2
201311,36047030700,1,0,0,0
201311,36047030700,1,0,1,1
201312,36047030700,1,1,0,0
201401,36047030700,0,1,0,0
201401,36047030700,1,0,1,0
201401,36047030700,2,0,0,0
201402,36047030700,1,1,1,1
201402,36047030700,1,0,0,0
201402,36047030700,0,1,0,0
201402,36047030700,0,1,0,1
201402,36047030700,0,0,0,1
201402,36047030700,0,0,1,1
201403,36047030700,0,0,0,1
201403,36047030700,1,1,0,0
201403,36047030700,1,0,0,0
201403,36047030700,0,1,0,1
201403,36047030700,0,2,1,1
201404,36047030700,1,1,1,1
201404,36047030700,2,0,2,1
201404,36047030700,0,0,0,0
201405,36047030700,1,0,0,0
201405,36047030700,0,0,0,0
201405,36047030700,0,0,0,1
201406,36047030700,1,0,0,0
201406,36047030700,1,1,1,0
201407,36047030700,1,0,0,0
201407,36047030700,1,0,0,0
201408,36047030700,1,0,0,0
201408,36047030700,1,0,1,1
201409,36047030700,1,0,0,0
201409,36047030700,1,0,1,0
201410,36047030700,1,1,0,0
201410,36047030700,0,0,0,0
201411,36047030700,0,0,0,0
201412,36047030700,1,1,0,0
201412,36047030700,3,0,0,0
201501,36047030700,3,3,0,0
201503,36047030700,0,0,0,0
201507,36047030700,3,3,0,0
201509,36047030700,1,0,0,0
201511,36047030700,3,0,0,0
201511,36047030700,1,0,0,0
201511,36047030700,1,1,0,0
201601,36047030700,1,0,0,0
201603,36047030700,0,0,0,0
201603,36047030700,1,0,0,1
201605,36047030700,1,0,0,0
201608,36047030700,1,0,1,0
201608,36047030700,0,0,0,0
201609,36047030700,1,0,0,0
201611,36047030700,0,0,0,0
;;;;
&lt;/CODE&gt;&lt;/PRE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sun, 04 Jul 2021 10:39:06 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751968#M236807</guid>
      <dc:creator>Patrick</dc:creator>
      <dc:date>2021-07-04T10:39:06Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751970#M236808</link>
      <description>&lt;BLOCKQUOTE&gt;
&lt;P&gt;I can understand that downloading .xlsx can be an issue. Not sure why downloading a .sas7bdat should be of any concern.&lt;/P&gt;
&lt;/BLOCKQUOTE&gt;
&lt;P&gt;&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/12447"&gt;@Patrick&lt;/a&gt;: My personal opinion about computer security, I do not (never ever) download any files whatsoever in any forum that I participate in.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Nor do I consider it inappropriate to ask the person who wants a question answered, to provide data in a reasonable format, they do the work that they are capable of doing, so I don't have to do the work that they are capable of doing.&lt;/P&gt;</description>
      <pubDate>Sun, 04 Jul 2021 12:35:22 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751970#M236808</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-07-04T12:35:22Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751977#M236809</link>
      <description>&lt;P&gt;Here is my code, thanks to &lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/12447"&gt;@Patrick&lt;/a&gt; for doing the work to provide the data in a usable form&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;&lt;CODE class=" language-sas"&gt;/* Create next six months */
data next6;
	set sqfaggfinal1(keep=sqfmthyr);
	do i=0 to 5;
	    sqfmthyr1=intnx('month',sqfmthyr,i,'b');
	    output;
    end;
    drop i sqfmthyr;
run;
proc sql; /* Find distinct months */
    create table next6 as select distinct sqfmthyr1 from next6;
quit;

/* Create multi-label format */
data dates1;
    set next6;
    start=sqfmthyr1;
    end=intnx('month',start,5,'b');
    fmtname='datef';
    hlo='M';
    label=put(start,yymmn6.);
run;
proc format cntlin=dates1;
run;

/* Compute N and SUM by TRACT and six-month interval */
/* with variable sqfmthyr being the first month of the six month interval */
proc summary nway data=sqfaggfinal1;
    class tract2010;
    class sqfmthyr/mlf;
    format sqfmthyr datef.;
    var friskcount--arrestcount;
    output out=want sum=;
run;&lt;/CODE&gt;&lt;/PRE&gt;</description>
      <pubDate>Sun, 04 Jul 2021 12:25:32 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751977#M236809</guid>
      <dc:creator>PaigeMiller</dc:creator>
      <dc:date>2021-07-04T12:25:32Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751978#M236810</link>
      <description>&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892"&gt;@PaigeMiller&lt;/a&gt; My apologies for not providing the data in that manner, I am very new to sas. This code worked perfectly...THANK YOU SO MUCH!!!!</description>
      <pubDate>Sun, 04 Jul 2021 12:46:13 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751978#M236810</guid>
      <dc:creator>casmcfarland</dc:creator>
      <dc:date>2021-07-04T12:46:13Z</dc:date>
    </item>
    <item>
      <title>Re: Aggregating by rolling timeframes</title>
      <link>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751980#M236811</link>
      <description>&lt;a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/12447"&gt;@Patrick&lt;/a&gt;: Thank you so much for your assistance. I know now what I need to do to get the data typed out. I appreciate it.</description>
      <pubDate>Sun, 04 Jul 2021 12:47:33 GMT</pubDate>
      <guid>https://communities.sas.com/t5/SAS-Programming/Aggregating-by-rolling-timeframes/m-p/751980#M236811</guid>
      <dc:creator>casmcfarland</dc:creator>
      <dc:date>2021-07-04T12:47:33Z</dc:date>
    </item>
  </channel>
</rss>

