Proc timeseries

Louise_svk274 — Thu, 02 Dec 2021 16:35:58 GMT

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 🙂

Re: Proc timeseries

Reeza — Thu, 02 Dec 2021 16:44:45 GMT

What happens if you explicitly specify your start/end datetimes using START/END?

topic Re: Proc timeseries in SAS Programming

Proc timeseries

Re: Proc timeseries