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;

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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