Thank you Dhanasekaran R and BobD very much! Your thoughtful hard work and expertise are deeply appreciated! Now not only this piece of code works, I managed to ‘mimic’ this Macro methodology / syntax to apply it to other part of my code before I set up some more SQL... Now I basically have attained the kind of result I expected to see; probably I would still like to do a bit more of testing before I really say ‘it’s finished!’  Thanks, buddy! ... View more

While Andreas already answered your question, I thought you might find it equally useful to know that the reason that you don't have to include Total_Amount_Last_Learning in a retain statement is because it is automatically retained because you used in the statement TOTAL_AMOUNT_LAST_EARNING + AMOUNT_LAST_EARNING ;   The variable on the left in such sum statements are automatically retained. ... View more

Ooh, I forgot to put the line RETAIN COUNTER 1; just under LENGTH COUNTER 2 to get the very first record works. : ) ... View more

Hi: I'm glad you got it working. But the only reason it's working is that &I resolves to the character string I and so the statement: [pre] &I = &I + 1; [/pre] will be resolved as: [pre] I = I + 1; [/pre] and there is really NO need, from what I see for you to use &I at all. You could just have easily written [pre] I = I + 1; [/pre] in the code and the program would have worked the same way. cynthia ... View more