I suspect you're just making it hard for yourself by converting rows to columns, both in your initial steps and in your eventual requirement. In terms of the latter, what does having all days on a single row give you that one row per day would not? A simple PROC SUMMARY would allow you to roll together days of data if that's what's ultimately required. If it's the kind of project I think it is, then there will be further questions and analyses that spring from the results of this stage, and the simpler your data structure is, the easier it's going to be to perform those analyses. Keep everything in simple non-repeating columns as far as you possibly can, and I think you can probably achieve that using simple DATA steps, PROC SORTs and PROC SUMMARYs. Transpose for reporting at the end if you must, but keep your data simple as possible as long as possible.
... View more