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 🙂
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.