Ashutosh and Jason,
I have just started with a system that has many, many fields - Ashutosh you might be in the same boat. Correct me if I'm wrong here.
We don't have a situation of X Y Z but rather 100's of fields, which makes programs lengthy and difficult to manage. Arrays make short work of repeated calculations and macro variables containing the variable names also shortcut a lot of it. But whatever route you take, you still end up with these long, unwieldy lists somewhere.
I'm taking the attitude of more rows less columns - trying the reduce the variable lists to categories in columns. Use of proc transpose can interchange between the tables. Taking this different approach makes programming much easier and shorter - have you tried thinking in this way? I've also returned a 75% space saving with this method - this is the business motivation of taking this route. Its often difficult justifying code changes without any obvious end-result.
Jason your thoughts?
... View more