PROC REPORT lines not displaying properly in RTF

tarheel13 — Sun, 08 Jan 2023 19:30:35 GMT

proc report data=table nowd headline headskip missing split="*" formchar="|----|+|---+=|-/\<>*" style=monospace  
out=&ov_out.(where=(_break_=""))
style(report)=[outputwidth=101%]
style(header)=[just=l asis=on ]
style(column)=[just=l asis=on ];
	columns pg aperiod visitnum paramn roword cat0 stat_c1-stat_c4;
	define pg / order order=internal noprint;
	define aperiod / order order=internal noprint;
	define visitnum / order order=internal noprint;
	define paramn / order order=internal noprint;
	define roword / order order=internal noprint;
	define cat0 / "Period*  Visit*   Measurement/Lab Test (Units)" flow style(column)=[just=left cellwidth = 15.1%];
	define stat_c1 / "* TRT A* N=&n1" flow style(column)=[just=left cellwidth = 6.1%];
	define stat_c2 / "* TRT B* N=&n2" flow style(column)=[just=left cellwidth = 6.1%];
	define stat_c3 / "* TRT C* N=&n3" flow style(column)=[just=left cellwidth = 6.1%];
	define stat_c4 / "* TOTAL* N=&n4" flow style(column)=[just=left cellwidth = 6.1%];
	break after pg / page;
	compute before / style={just=l}; line "&headline"; endcomp;
    compute before _page_/ style={just=l}; line "&headline"; line ""; endcomp;       
    compute after _page_ / style={just=l borderbottomcolor=white}; line "&headline"; endcomp;  
	compute after paramn / style={just=l borderbottomcolor=white}; line ""; endcomp;
	compute before pg / style={just=l borderbottomcolor=white}; line ""; endcomp;
run;

Hi, I need lines under column headers and at the bottom of the table. The lines are displaying but not properly. Line spills onto the next line. I am using a macro variable and compute blocks to get the lines. Macro variable is %let headline = %sysfunc(repeat('_',&ls-2)). &ls is another macro variable for line size and is currently set at 133 from what I can tell. If anyone has a better way to get the lines, please let me know. I already have headline and headskip options on proc report and a paging variable called pg. I have break after pg / page.

I would like the yellow to go away. Same is happening for line under the table.

Re: PROC REPORT lines not displaying properly in RTF

tarheel13 — Sun, 08 Jan 2023 19:42:32 GMT

Okay, I think I fixed it by using these macro variables instead of &headline.

  %let bb=\brdrb\brdrs\brdrw10;
  %let tb=\brdrt\brdrs\brdrw10;

topic PROC REPORT lines not displaying properly in RTF in SAS Programming

PROC REPORT lines not displaying properly in RTF

Re: PROC REPORT lines not displaying properly in RTF