Aggregate hourly into daily average (time series)

[Job04]

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

[mkeintz]

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

[Job04]

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

[Tom · Accepted solution]

Why not just use PROC MEANS (aka SUMMARY)?

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

[Job04]

Works well. Thanks

[Job04]

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.