topic Converting Date Variables in SAS Procedures

Converting Date Variables

Guinaba — Tue, 20 Aug 2013 08:08:40 GMT

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

Re: Converting Date Variables

LinusH — Tue, 20 Aug 2013 09:03:27 GMT

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

Re: Converting Date Variables

Guinaba — Wed, 21 Aug 2013 00:27:56 GMT

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