Okay. So here is a snipped of my input. I do a little bit of summarizing, but I keep the same names in the (temporary) summary table: RUNDATE, TOTE9, RATM4C, DATPT, TRIP_P, DATTT, and TRIP_T are the fields used to create the table output in my earlier post. The SAS System Sunday, February 11, 2024 05:00:00 PM 1
Obs SITE TIMESTAMP TOTE9 DATPT TRIP_P RATM4C DATTT TRIP_T FILLER RUNDATE RUNYEAR RUNMONTH RUNDAY
1 COLO_A 11FEB2024:00:54:45 30 81.0 7601 14.5 2.9 8850 23417 2024 2 11
2 COLO_A 11FEB2024:00:57:32 30 81.0 7601 14.5 2.9 8850 23417 2024 2 11
3 COLO_A 11FEB2024:01:01:06 30 81.0 7596 14.5 2.9 8850 23417 2024 2 11
4 COLO_A 11FEB2024:02:00:06 30 81.1 7538 14.5 2.9 8850 23417 2024 2 11
5 COLO_A 11FEB2024:03:00:06 30 81.1 7501 14.5 2.9 8850 23417 2024 2 11
6 COLO_A 11FEB2024:04:21:02 30 81.3 7425 14.5 2.9 8850 23417 2024 2 11
7 COLO_A 11FEB2024:05:00:06 30 81.5 7373 14.5 2.9 8850 23417 2024 2 11
8 COLO_A 11FEB2024:05:03:08 30 81.5 7370 14.5 2.9 8850 23417 2024 2 11
9 COLO_A 11FEB2024:06:00:06 30 81.6 7295 14.5 2.9 8850 23417 2024 2 11
10 COLO_A 11FEB2024:07:00:08 30 82.2 7188 14.5 2.7 8899 23417 2024 2 11
11 COLO_A 11FEB2024:08:00:09 30 83.7 7002 14.4 2.7 8899 23417 2024 2 11
12 COLO_A 11FEB2024:09:00:10 30 85.2 6846 14.4 2.7 8898 23417 2024 2 11
13 COLO_A 11FEB2024:10:00:06 30 85.7 6769 14.4 2.7 8898 23417 2024 2 11
14 COLO_A 11FEB2024:11:00:05 30 85.7 6664 14.4 2.7 8898 23417 2024 2 11
15 COLO_A 11FEB2024:12:00:05 30 85.7 6655 14.4 2.7 8898 23417 2024 2 11
16 COLO_A 11FEB2024:13:00:06 30 85.7 6612 14.4 2.7 8898 23417 2024 2 11
17 COLO_A 11FEB2024:14:00:05 30 85.8 6546 14.4 2.7 8898 23417 2024 2 11
18 COLO_A 11FEB2024:15:00:06 30 85.8 6519 14.4 2.7 8898 23417 2024 2 11
19 COLO_A 11FEB2024:16:00:05 30 85.8 6494 14.4 2.7 8898 23417 2024 2 11
20 COLO_A 11FEB2024:17:00:05 30 85.8 6491 14.4 2.7 8898 23417 2024 2 11
... View more