topic Aggregate hourly into daily average (time series) in SAS Programming

Aggregate hourly into daily average (time series)

Job04 — Thu, 24 Dec 2020 18:20:44 GMT

Hello,

I have time series data with 24 hours observations per day for an entire year . I need to transform the data into daily average. How would that be done.

Thanks

Re: Aggregate hourly into daily average (time series)

mkeintz — Thu, 24 Dec 2020 21:36:51 GMT

By "daily average", do you mean the average hourly measure for each day?

Re: Aggregate hourly into daily average (time series)

Tom — Thu, 24 Dec 2020 22:32:21 GMT

Why not just use PROC MEANS (aka SUMMARY)?

proc summary data=have ;
  by date;
  var nt ;
  output out=want mean=nt_mean ;
run;

Re: Aggregate hourly into daily average (time series)

Job04 — Fri, 25 Dec 2020 09:42:38 GMT

Works well. Thanks

Re: Aggregate hourly into daily average (time series)

Job04 — Fri, 25 Dec 2020 09:47:28 GMT

Yes, I meant the daily hourly average, also it can be considered an overall average for the day.

Re: Aggregate hourly into daily average (time series)

Job04 — Fri, 25 Dec 2020 10:07:42 GMT

Just one thing to add, this code gives the daily averages only of the first month listed in the data, but I would like to get that for every single month in the data. So my data starts with March so I got averages only for March.