Hi, I have a data set that has a measure of the temperature every 10 minutes (variable = temp) for a month. I would like to get an average of every 6 rows combined so I can calculate the average temperature per hour. An example of the first bit of my data is: data WORK.WEATHER; infile datalines dsd truncover; input date: DDMMYY10. time:TIME. temp:32.; format date DDMMYY10. time TIME.; datalines; 04/08/2018 7:00:00 18.461 04/08/2018 7:10:00 18.557 04/08/2018 7:20:00 18.675 04/08/2018 7:30:00 18.557 04/08/2018 7:40:00 18.461 04/08/2018 7:50:00 18.319 04/08/2018 8:00:00 18.39 04/08/2018 8:10:00 18.652 04/08/2018 8:20:00 19.246 04/08/2018 8:30:00 19.46 04/08/2018 8:40:00 19.793 04/08/2018 8:50:00 20.293 I would like it to look like this: 04/08/2018 7:00:00 18.505 04/08/2018 8:00:00 19.306 Thank you!
... View more