cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
casmcfarland
Calcite | Level 5 casmcfarland
Calcite | Level 5
Go to Solution

Aggregating by rolling timeframes

Posted 07-02-2021 10:23 AM (1092 views)

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:

July 2006-December 2006

January 2007-June 2007

July 2007-December 2007

January 2008-June 2008

July 2008-December 2008

January 2009-June 2009

sqfaggfinal1.sas7bdat
0 Likes
1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-04-2021 07:50 AM (898 views)  |   In reply to PaigeMiller

Here is my code, thanks to @Patrick for doing the work to provide the data in a usable form

 

/* 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;
--
Paige Miller

View solution in original post

0 Likes
13 REPLIES 13
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-02-2021 10:38 AM (1079 views)  |   In reply to casmcfarland

Many of us will not (or cannot) download attachments. Please include a small portion of your data in your reply following these instrucctions.

 

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)?

 

 

--
Paige Miller
0 Likes
Patrick
Opal | Level 21 Patrick
Opal | Level 21

Re: Aggregating by rolling timeframes

Posted 07-04-2021 06:35 AM (912 views)  |   In reply to PaigeMiller

@PaigeMiller  I can understand that downloading a .xlsx can be an issue. Not sure why downloading a .sas7bdat should be of any concern.

Below the data step created using https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/ 

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
;;;;

 

0 Likes
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-04-2021 06:40 AM (908 views)  |   In reply to Patrick

I can understand that downloading .xlsx can be an issue. Not sure why downloading a .sas7bdat should be of any concern.

@Patrick: My personal opinion about computer security, I do not (never ever) download any files whatsoever in any forum that I participate in.

 

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.

--
Paige Miller
0 Likes
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-04-2021 07:50 AM (899 views)  |   In reply to PaigeMiller

Here is my code, thanks to @Patrick for doing the work to provide the data in a usable form

 

/* 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;
--
Paige Miller
0 Likes
casmcfarland
Calcite | Level 5 casmcfarland
Calcite | Level 5

Re: Aggregating by rolling timeframes

Posted 07-04-2021 08:46 AM (887 views)  |   In reply to PaigeMiller
@PaigeMiller My apologies for not providing the data in that manner, I am very new to sas. This code worked perfectly...THANK YOU SO MUCH!!!!
0 Likes
casmcfarland
Calcite | Level 5 casmcfarland
Calcite | Level 5

Re: Aggregating by rolling timeframes

Posted 07-04-2021 08:47 AM (887 views)  |   In reply to Patrick
@Patrick: Thank you so much for your assistance. I know now what I need to do to get the data typed out. I appreciate it.
0 Likes
casmcfarland
Calcite | Level 5 casmcfarland
Calcite | Level 5

Re: Aggregating by rolling timeframes

Posted 07-02-2021 10:51 AM (831 views)  |   In reply to casmcfarland

Data I have

SQFMTHYR            Tract2010        Friskcount          Furtcount               Searchcount             Arrestcount

200801                   36005000200       1                          0                             1                             0

200802                   36005000200       1                          0                             1                             0

200803                   36005000200       1                          0                             1                             0

200804                   36005000200       1                          0                             1                             0

200805                   36005000200       1                          0                             1                             0

200806                   36005000200       1                          0                             1                             0

200807                   36005000200       1                          0                             1                             0

 

 

Data I want

SQFMTHYR       SQFMTHYR6A     Tract2010        Friskcount          Furtcount               Searchcount             Arrestcount

200801               200801-200806     36005000200       6                          0                             6                             0

200802               200802-200807     36005000200       6                          0                             6                             0

 

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.

 

0 Likes
casmcfarland
Calcite | Level 5 casmcfarland
Calcite | Level 5

Re: Aggregating by rolling timeframes

Posted 07-02-2021 11:34 AM (1053 views)  |   In reply to casmcfarland

Here is what I have:

sqfmthyrtract2010friskcountfurtcountsearchcountarrestcount
Feb-06360050002001000
Feb-06360050002000000
Feb-06360050002001000
Mar-06360050002001000
Apr-06360050002001000
May-06360050002001000
May-06360050002000200
Jun-06360050002002200
Jun-06360050002001101
Jun-06360050002001100
Jun-06360050002001100
Jul-06360050002002000
Jul-06360050002002000
Jul-06360050002000000
Aug-06360050002002211
Aug-06360050002001001
Sep-06360050002003300
Oct-06360050002000000

 

Here is what I need:

 

sqfmthyrsqfmthyraggtract2010friskcountfurtcountsearchcountarrestcount
200602200602-2006073600500020014701
200603200603-2006083600500020015913
200604200604-20060936005000200171213
200605200605-20061036005000200161213
0 Likes
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-02-2021 11:50 AM (1046 views)  |   In reply to casmcfarland

I'm afraid this still requires more explanation on how to determine the dates in the output from the dates in the input.

 

I still request the data be provided according to the instructions I gave.

--
Paige Miller
0 Likes
casmcfarland
Calcite | Level 5 casmcfarland
Calcite | Level 5

Re: Aggregating by rolling timeframes

Posted 07-02-2021 05:37 PM (1012 views)  |   In reply to PaigeMiller

This is the code I used to go from individual to aggregate by year/month:

proc sql;
create table sqfagg as
select put(sqfmthyr, YYMMN6.) as reporting_period, tract2010, count (*) as stopcount, sum(frisk) as friskcount format=comma10. , sum(furtive) as furtcount format=comma10. ,
sum(search) as searchcount format=comma10. , count(*) as stopcount format=comma10., sum(arrestmade) as arrestcount format=comma10.,
sum(summonissue) as summonscount format=comma10., sum(physicalforce) as phyfrc format=comma10.,
sum(criminaldress) format=comma10. as crimdress, sum(black) format=comma10. as blackcount, sum(white) format=comma10. as whitecount, sum(hispanic) format=comma10. as hispaniccount,
sum(otherrace) format=comma10. as othracecount
from sqfmonthyear
group by tract2010, put(sqfmthyr, YYMMN6.) ;
quit;

 

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. @PaigeMiller 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.

 

 

0 Likes
Peter_C
Rhodochrosite | Level 12 Peter_C
Rhodochrosite | Level 12

Re: Aggregating by rolling timeframes

Posted 07-03-2021 06:45 AM (987 views)  |   In reply to casmcfarland
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'.
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.
0 Likes
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-03-2021 07:05 AM (981 views)  |   In reply to casmcfarland
@casmcfarland wrote:

 

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. @PaigeMiller 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.

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 (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.

 

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:

 

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;

Again, I can't give you more code until I have a working copy of your data.

--
Paige Miller
PaigeMiller
Diamond | Level 26 PaigeMiller
Diamond | Level 26

Re: Aggregating by rolling timeframes

Posted 07-03-2021 03:07 PM (944 views)  |   In reply to casmcfarland

Perhaps this will help you.

 

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: https://communities.sas.com/t5/SAS-Programming/Moving-average-by-site-and-date/m-p/751510#M236586. 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.

 

--
Paige Miller

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Watch How to Concatenate Values on YouTube

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 13 replies
  • ‎07-02-2021 10:23 AM
  • 1093 views
  • 3 likes
  • 4 in conversation