topic Overwriting (Underlining) Text Displayed in a PROC REPORT in SAS Programming

Overwriting (Underlining) Text Displayed in a PROC REPORT

davehalltwp — Wed, 26 Apr 2023 21:38:13 GMT

I'm not sure actually if this is a SAS question, or a character set question, but with all the geniuses around here, I'll probably get an answer anyway.

I am trying to print a page header in proc report. I would like a line below it, but without skipping a line (overprint?)

PAGE HEADER

_____________________________

Where the line prints without a line feed.

It's within a PROC REPORT COMPUTE BEFORE _PAGE_ block.

I wonder if it's a matter of embedding control characters such as "~line " (I can't remember the syntax) in the text string. I haven't done much of that.

Right now I have:

compute before _PAGE_;

         line @1 subgtext $ 30. ;
          line @1 131 * '_';

endcomp;

that prints two separate lines, of course.

Thank you...

Re: Overwriting (Underlining) Text Displayed in a PROC REPORT

ballardw — Thu, 27 Apr 2023 01:34:57 GMT

Best would be to include some example data in the form of data step code and the completer Proc Report code so we can test possible solutions.

Also, which ODS destination are you using. Some solutions may be destination dependent. For example, if you were using the ODS LISTING destination that either the UL or DUL options would apply. But these, derived from the days of line printers, only work in the LISTING destination. Also the ODS Style that is in effect.

Re: Overwriting (Underlining) Text Displayed in a PROC REPORT

Ksharp — Thu, 27 Apr 2023 11:48:51 GMT

proc sort data=sashelp.class out=class;
by sex;
run;

ods rtf file='c:\temp\temp.rtf';
options nobyline;
proc report data=class nowd;
by sex;
columns name age weight height;
compute before _PAGE_/style={textdecoration=underline};
subgtext='XXXXXXXXXXX';
line @1 subgtext $30. ;
endcomp;
run;
ods rtf close;

Re: Overwriting (Underlining) Text Displayed in a PROC REPORT

davehalltwp — Thu, 27 Apr 2023 12:40:45 GMT

Thank you, KSharp. That worked perfectly!