The SAS Output Delivery System and reporting techniques

The 'end'-horizontal line to be eliminated in listing after 'proc report'

Reply
Frequent Contributor
Posts: 148

The 'end'-horizontal line to be eliminated in listing after 'proc report'

Hi all,

 

Could you please help in the following case. There is a line on each page when final listing is printed. Please see the picture below. Is there a method to eliminate the line?1.jpg

SAS Super FREQ
Posts: 8,958

Re: The 'end'-horizontal line to be eliminated in listing after 'proc report'

Posted in reply to DmytroYermak
What code have you tried? That looks like Journal style. You could change the style template ... not sure what you mean about bottom line coming from Proc Print — Looks like a footnote statement with rtf control strings??? Hard to guess without data or code.

Cynthia
Frequent Contributor
Posts: 148

Re: The 'end'-horizontal line to be eliminated in listing after 'proc report'

[ Edited ]
Posted in reply to Cynthia_sas

 Thank you, Cynthia. I'm using the code below. It think that the style is defined in system options before the block but I have not found it. Possibly they are in system macros.

 

 

 

/*-------------------*/
options missing='';
/*%styles;*/
ods ESCAPECHAR='~';

%footnote(%str(Note: LLL = Single LLLLLLLL Dose;%str(*) - Major Protocol Deviation.));
%print(1);


proc report data=L16_02_02_01 nowd
style(column)={asis=on}
style(header)={asis=on font_weight=medium} split="*" ;
by pgn;

column  var1 d var2 d VisitNum var3 d var4 d var5 d var6 ;
define var1 / group "Subject ID" style(header)=[just=l cellwidth=9%] left ;
define var2 / group "Cohort /*LLLLLLL Dose" style(header)=[just=l cellwidth=11%] left;
define VisitNum / order order=internal noprint;
define var3 / order "Visit Name" style(header)=[just=l cellwidth=12%] left;
define var4 / order "Panel Name" style(header)=[just=l cellwidth=18%] left;
define var5 / order "Protocol Deviation*Description" style(header)=[just=l cellwidth=22%] left;

compute before var5; 
   line " "; 
endcomp;

define var6 / "Reason for Protocol*Deviation" style(header)=[just=l cellwidth=22%] left;
define d / ' ' style=[cellwidth=1%];

run;

%print();

 

 

SAS Super FREQ
Posts: 8,958

Re: The 'end'-horizontal line to be eliminated in listing after 'proc report'

Posted in reply to DmytroYermak
hi, where are the ODS statements? You do not show the destination or style= option. If you want to get rid of the line above the footnote, you will have to change the code in %footnote. If you want to remove the line under the table that comes from the style template, you will have to change the style template. I see you have another macro program call called %print -- so that might contain the ODS statements and style template references. Unfortunately, you are going to need to dig into those macro programs and that code to figure out how to get rid of the line or lines you don't like.

cynthia
Frequent Contributor
Posts: 148

Re: The 'end'-horizontal line to be eliminated in listing after 'proc report'

[ Edited ]
Posted in reply to Cynthia_sas

Thank you, Cynthia. In my understanding the style Journal is a default style of SAS and it is standard for clinical trials Listings and Tables. It means that even we use a %print it just calls for this template 'Journal' and does not modify it. Is it correct interpretation?

 

How could I access the template and modify it? 

Frequent Contributor
Posts: 92

Re: The 'end'-horizontal line to be eliminated in listing after 'proc report'

[ Edited ]
Posted in reply to DmytroYermak

Use PROC TEMPLATE to see the style definition in the log.

 

proc template;
  source styles.journal;
run;

The code box below shows a portion of the Journal style.  frame = HSIDES produces the borders at the top and bottom of the table.  frame = ABOVE produces a border at the top of the table.  

 

    style Output from Container /
       bordercolor = colors('fgA1')
       borderwidth = 1
       borderspacing = 0
       cellpadding = 7
       frame = HSIDES
       rules = GROUPS
       backgroundcolor = colors('bgA1')
       bordercollapse = separate
       borderstyle = solid;

Create a modified version of the template and then use it.

 

ODS PATH WORK.TEMPLAT(UPDATE) SASHELP.Tmplmst(READ);


proc template; define style styles.modified_Journal; parent=styles.Journal; style Output from Output / frame = ABOVE; end; run; ods rtf file="/folders/myfolders/SAS Communities/modified Journal style.rtf" style=modified_Journal; proc report data=sashelp.class nowd; title 'SASHELP.class data set'; title2 'This is a modified version of the Journal style that ships with SAS'; run; ods rtf close;

Modified version of Journal style with frame = ABOVEModified version of Journal style with frame = ABOVE

 

Frequent Contributor
Posts: 148

Re: The 'end'-horizontal line to be eliminated in listing after 'proc report'

Posted in reply to SuzanneDorinski
Thank you, Suzanne! I have to put this in order for myself, to return with questions.
Ask a Question
Discussion stats
  • 6 replies
  • 292 views
  • 0 likes
  • 3 in conversation