Well, macro language is just a code generator at the end of the day. You can achieve exactly the same thing with cntrl + c and cntrl + v changing any values. From what I see, a lot of the use for macros is when the problem is not thought about, i.e. would transposing or normalising make the coding easier, what about arrays, using metadata etc. I used to use macros all the time, but stepping back and thinking about the data, and how metadata can be stored (e.g. by merging parameters from other datasets) really reduces the need for it.
... View more