Solved: Re: Aggregate hourly into daily average (time series)

Job04 · Posted 12-24-2020 01:20 PM

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

Tom · Posted 12-24-2020 05:32 PM

Why not just use PROC MEANS (aka SUMMARY)?

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

View solution in original post

mkeintz · Posted 12-24-2020 04:36 PM

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

--------------------------
The hash OUTPUT method will overwrite a SAS data set, but not append. That can be costly. Consider voting for Add a HASH object method which would append a hash object to an existing SAS data set

Would enabling PROC SORT to simultaneously output multiple datasets be useful? Then vote for
Allow PROC SORT to output multiple datasets

--------------------------

Job04 · Posted 12-25-2020 04:47 AM

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

Tom · Posted 12-24-2020 05:32 PM

Why not just use PROC MEANS (aka SUMMARY)?

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

Job04 · Posted 12-25-2020 04:42 AM

Works well. Thanks

Job04 · Posted 12-25-2020 05:07 AM

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.

SAS Innovate 2025: Call for Content

Classroom Training Available!