@Jumboshrimps wrote:
At this point, I cannot say with 100% certainty where this is going. It is a bunch of Enterprise Guide 7.13 legacy code made by someone who know how to drag-and-drop components only.
My task is to try to refactor the 10,000 lines of incomprehensible, undocumented, uncommented code into SAS Studio code that can be loaded back into the Warehouse on an automated basis.
The proc transpose code module show above, (that one that works) replaced 80 lines of code.
You must have some idea about how this output is used. You inherited something that produces a report, or an analysis, or an output. You did not inherit something that does complicated transposing and then stops there and does nothing with the transposed data.
If you don't know how this is being used, then I suggest that's the first step you need to tackle.
And in any event, I will stick with my opinion that putting dates into variable names is a poor practice, and much easier methods of dealing with this data are available if you do not transpose.
... View more