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
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;
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)?
@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
;;;;
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.
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;
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.
Here is what I have:
sqfmthyr | tract2010 | friskcount | furtcount | searchcount | arrestcount |
Feb-06 | 36005000200 | 1 | 0 | 0 | 0 |
Feb-06 | 36005000200 | 0 | 0 | 0 | 0 |
Feb-06 | 36005000200 | 1 | 0 | 0 | 0 |
Mar-06 | 36005000200 | 1 | 0 | 0 | 0 |
Apr-06 | 36005000200 | 1 | 0 | 0 | 0 |
May-06 | 36005000200 | 1 | 0 | 0 | 0 |
May-06 | 36005000200 | 0 | 2 | 0 | 0 |
Jun-06 | 36005000200 | 2 | 2 | 0 | 0 |
Jun-06 | 36005000200 | 1 | 1 | 0 | 1 |
Jun-06 | 36005000200 | 1 | 1 | 0 | 0 |
Jun-06 | 36005000200 | 1 | 1 | 0 | 0 |
Jul-06 | 36005000200 | 2 | 0 | 0 | 0 |
Jul-06 | 36005000200 | 2 | 0 | 0 | 0 |
Jul-06 | 36005000200 | 0 | 0 | 0 | 0 |
Aug-06 | 36005000200 | 2 | 2 | 1 | 1 |
Aug-06 | 36005000200 | 1 | 0 | 0 | 1 |
Sep-06 | 36005000200 | 3 | 3 | 0 | 0 |
Oct-06 | 36005000200 | 0 | 0 | 0 | 0 |
Here is what I need:
sqfmthyr | sqfmthyragg | tract2010 | friskcount | furtcount | searchcount | arrestcount |
200602 | 200602-200607 | 36005000200 | 14 | 7 | 0 | 1 |
200603 | 200603-200608 | 36005000200 | 15 | 9 | 1 | 3 |
200604 | 200604-200609 | 36005000200 | 17 | 12 | 1 | 3 |
200605 | 200605-200610 | 36005000200 | 16 | 12 | 1 | 3 |
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.
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.
@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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.