Days to 30 days interval data creation

[Zula]

I have data as daily (attached below):

I want to make as 30 days (from i2 variable)  interval data as, for example, 

ID END sum_fill_i

123699041 30 VVV (whatever sum of this fill_i between 1 and 30)

next row would be as below:

123699041 60 XXX (next summation of the fill_i).

Can you help please? Thank you.

ENROLID i2 fill_i

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

[PGStats · Accepted solution]

You can summarize in a single step with

proc sql;
create table want as
select 
    enrolid,
    30*ceil(i2/30) as end,
    sum(fill_i) as sum_fill_i
from have
group by enrolid, calculated end;
quit;