Hi,
My data set is composed of days from a specific month. Does anyone know how can I aggregate these observation from daily to weekly?
1/8 | 2/8 | 3/8 | 4/8 | 5/8 | 6/8 | 7/8 | 8/8 |
---|---|---|---|---|---|---|---|
34 | 33 | 11 | 54 | 87 | 56 | 45 | 45 |
44 | 21 | 56 | 90 | 43 | 34 | 34 | 35 |
Regards,
Gilly
Is this really your data set layout?
It's more complicated to aggregate columns than rows, so I strongly recommend to transpose your table.
After doing that, you could use a week format, or the INTNX function to make your dates weeks.
By doing that, you have a variety of options to aggregate the data, PROC SQL, PROC SUMMARY and many other reporting procedures (TABULATE, REPORT etc).
Thank you Linus for your feedback! I will follow your suggestion.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.