Hej,
I'm working with time series data where I have observation from 24 of may 2020 to 20 of jun 2020 for Co2.
I have observations for co2 emissions every five minutes. I wish to aggregate to a daily average, by using 'proc timeseries' but it will only let me aggregate to a hourly average.
When I run the following proc timeseries code:
proc timeseries data=co2 out=co2_average_hour;
id minutes5dk interval=day accumulate=average setmissing=missing;
var co2;
run;
It comes out with an error that says "The ID variable value Minutes5DK=24MAY2020:00:05:00 is extreme and invalid at observation number 2 in data set WORK.CO2." But if I change hour to day, it has no problem running the code.
I have copied a example of the data set so you cans what I'm working with. The data continues until the 24. of jun.
Hope you can help me with aggregating to daily average 🙂