Question about header when using proc report

Kya_wwwwww — Mon, 30 Sep 2019 02:49:31 GMT

Dear users,

How can I make my table show like the picture below?

I want a line above the whole table but the line is not a title, I use the "line @1" statement, but my output is like this way

Thx you for answering my question!!!!!!!!A lot!!!!!!!!!!!!!

Re: Question about header when using proc report

ballardw — Mon, 30 Sep 2019 14:42:44 GMT

Please post the code that are using so far. Please post the code into a code box opened on the forum using the {I} or "running man" icons to preserve formatting.

Also you should tell us what ODS style you are currently using for your output.

Re: Question about header when using proc report

Kya_wwwwww — Thu, 03 Oct 2019 15:21:02 GMT

Oh I'm sorry and thx for your reminding, below is my template and proc report code

proc template;
    define style rtfstyle;
    parent=styles.rtf;
    style fonts / 'TitleFont' = ("Courier New", 8pt, Bold) 
    'TitleFont2' = ("Courier New", 8pt, Bold)
    'StrongFont' = ("Courier New", 8pt, Bold) 
    'headingFont' = ("Courier New", 8pt, Bold) 
    'docFont' = ("Courier New", 8pt, Bold)
    'footFont' = ("Courier New", 8pt, Bold) 
    'FixedStrongFont' = ("Courier New", 8pt, Bold)
    'FixedHeadingFont' = ("Courier New", 8pt, Bold)
    'FixedFont' = ("Courier New", 8pt, Bold) 
    'BatchFixedFont' = ("Courier New", 8pt, Bold)
    'FixedEmphasisFont' = ("Courier New", 8pt, Bold)
    'EmphasisFont' = ("Courier New", 8pt, Bold);
    style Table from Output / bordercollapse = separate rules = none cellpadding = 0pt cellspacing = 0pt borderspacing = 0pt bordertopwidth = 1pt borderbottomwidth = 0pt frame = void;
    style body from document / leftmargin = 1in rightmargin = 1in topmargin = 1.5in bottommargin = 1in;
    style cell from container / ;
    style header from header / background = _undef_ leftmargin=2pt;
    end;
run;


proc report nowd data=final(where=(paramcd="SPGA0")) split = '|' nowd headline headskip missing;
	column avisitn ord ord2 label  trt5
							 trt6  trt7 ;
	define avisitn	 / noprint order order=data ;
	define ord 		 / computed noprint order order=data ; 
	define ord2 	 / noprint order order=data ; 
	define label 	 / width=45 "By Pooled Dose"  flow style(column)=[width=39% asis=on JUST=L] style(header)={just=LEFT borderbottomwidth=1pt};
	define trt5 	 / width=18 "aaa|(N=%cmpres(&den5))" style(column)=[width=20% asis=on JUST=C] style(header)={just=center borderbottomwidth=1pt};
	define trt6     / width=18 "bbb|(N=%cmpres(&den6))" style(column)=[width=20% asis=on JUST=C] style(header)={just=center borderbottomwidth=1pt};
	define trt7     / width=18 "Total|(N=%cmpres(&den7))" style(column)=[width=20% asis=on JUST=C] style(header)={just=center borderbottomwidth=1pt};
	
	compute before _page_;
	line @1 "Parameter: sPGA(0)";
	endcomp;

      compute after ord;
  	  line " ";
  	  endcomp;
	break after avisitn/ page;
 run;

Re: Question about header when using proc report

Tom — Thu, 03 Oct 2019 15:39:27 GMT

Why not just use a TITLE statement for that title line?

Re: Question about header when using proc report

Kya_wwwwww — Thu, 03 Oct 2019 15:57:35 GMT

Because there will be a blank line between the title and the table.

topic Re: Question about header when using proc report in New SAS User

Question about header when using proc report

Re: Question about header when using proc report

Re: Question about header when using proc report

Re: Question about header when using proc report

Re: Question about header when using proc report