Thats quite difficult to say, I don't know your data, your processes etc. To your question on the normalisation, to normalise/transpose data you can use the proc transpose procedure. If it is a complicated transpose/normalise then use array's/datastep processing.
Wether this structure is good for your analysis - I don't know, I have no information. What I can say is that SAS is built around the concept of:
- The datastep, which is in itself a loop
- By group processing
Your original post:
"is there a feasible way (or a good alternative) to do loops in SAS without getting into macros"
This would be you creating code to replicate what a datastep does
"I need to repeat the same analysis section"
This sounds like you need to do code for various sub-groups.
At the end of the day its up to you and your decision based on the facts you know, I merely respond to the point:
"s there a feasible way (or a good alternative) to do loops in SAS without getting into macros?"
Yes, there are various methods. Data structure change, arrays, using inbuilt shortcuts such as VAR: or VAR1--VAR10 or _numeric_. Or you could use macros, or call execute.
... View more