BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
tarheel13
Rhodochrosite | Level 12
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.

tarheel13_0-1673206099838.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
tarheel13
Rhodochrosite | Level 12

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

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

View solution in original post

1 REPLY 1
tarheel13
Rhodochrosite | Level 12

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

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 630 views
  • 0 likes
  • 1 in conversation