Converting Date Variables

[Guinaba]

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

[LinusH]

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).

[Guinaba]

Thank you Linus for your feedback! I will follow your suggestion.