If you have an immediate need, then your only other choice is to contact Tech Support for further help. If you are having problems with code that's been posted, once you modify the code for your particular data, then Tech Support can help you figure out how to modify these code examples for your particular need, using your data. There are at least 3 ways that I can think of that you could use to get your final grand total without using BY group processing -- and still have your header text (like REGION = XXXXX) on/in the table(s).
No BY group processing involved:
1) USE PAGE option on Break statement for the NOPRINT var + RBREAK After + COMPUTE BEFORE _PAGE_ + COMPUTE AFTER -- also will have to set some temporary variables and flags so you get the correct text string at the final grand total.
2) USE RBREAK After + COMPUTE BEFORE NOPRINT var + Break Statement on the NOPRINT var (but without PAGE option) + COMPUTE AFTER
3) Use RBREAK After + COMPUTE BEFORE NOPRINT var + with PAGE option on BREAK for NOPRINT var + COMPUTE AFTER
However, I am teaching class this week and my time to experiment with examples is limited. If you can't figure out the syntax from the documentation or by modifying previous examples, your best bet would be to seek help from Tech Support.
Good PROC REPORT help topics are entitled:
Creating Detail and Summary Reports with the REPORT Procedure
Overview: REPORT Procedure
Concepts: REPORT Procedure
How PROC REPORT Builds a Report
Can you give me an example or can you modify my code given in my posting to use one of 3 options.
I am not able to get you how will I able to get grand total as well as supplier=xxxx
on the top without using by statement.
Usually, if I have a program in my folders, I can just cut and paste it in here. However, for this question, I'd have to modify several programs that were doing a lot of other stuff as well as what you want and the 3 programs I was thinking of were all using DIFFERENT data -- so I'd have to swap out the data, too. Since I'm teaching this week, I don't have time to devote to the task.