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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 360 views
  • 0 likes
  • 1 in conversation