Help using Base SAS procedures

Converting Date Variables

Reply
Occasional Contributor
Posts: 15

Converting Date Variables

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/82/83/84/85/86/87/88/8
3433115487564545
4421569043343435

Regards,

Gilly

Super User
Posts: 5,255

Re: Converting Date Variables

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

Data never sleeps
Occasional Contributor
Posts: 15

Re: Converting Date Variables

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

Ask a Question
Discussion stats
  • 2 replies
  • 202 views
  • 3 likes
  • 2 in conversation