Hi:
Since you're using BY group processing to get every table separate, I think the easiest thing to do is to calculate a helper variable in a DATA step, as shown below, where I create the variable table_cnt:
Then, the table_cnt variable can be placed on the report row and used in the creation of DISP_LINE, as shown below with partial output:
After you verify that table_cnt is working as desired, you can use NOPRINT to just hide the column on the report. Note that I added a LENGTH statement for DISP_LINE with a length of 30 because when concatenating, I like to make sure the length will be wide enough to avoid truncation. Then, I also changed the format in the LINE statement to $30. as well.
I toyed with the idea of using substr to get the number our of the TYPE variable, so that's another possible approach, but I was afraid that this was some dummy data and the real values might not contain a number that corresponds to the table number.
Cynthia
... View more