08-20-2013 04:08 AM
My data set is composed of days from a specific month. Does anyone know how can I aggregate these observation from daily to weekly?
08-20-2013 05:03 AM
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).