Proc Report Total Line

[DmytroYermak]

Hi all,

Could you please help to code the line before Total:

[Ksharp]

Use original code of RTF.

ods escapechar="^";
proc report...;
  columns x ("^R'\brdrb\brdrs\brdrw15 'Powers" y z) ;

[DmytroYermak]

I bring my apolog

[Cynthia_sas]

Hi:
It is really hard to do what you ask with code or data to test. It is impossible to "correct" your COMPUTE block out of context -- it needs the whole code and some data.

If you can't share your data then make some fake data or use one of the SASHELP datasets. I do not think your COMPUTE before will do what you want, because you would be writing the line at the TOP of the group when VAR3 changes. According to your picture, that is not where you want the LINE to be written.

Another reason why it is important to see all the code is that in your screen shot, it doesn't look like there's a column for VAR3, which implies that it might be a NOPRINT item. And, depending on the order of variables in the COLUMN statement, you might be testing VAR3 at the wrong place.

cynthia

[DmytroYermak · Accepted solution]

The case was resolved by adding the following data to var3:

 var3 = "(*ESC*)S={bordertopwidth=1}"||"             Total # of Subjects Attended Visit = " || strip(put(number, 8.));