The SAS Output Delivery System and reporting techniques

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

Reply
Regular Contributor
Posts: 210

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

[ Edited ]

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?

 large (2).jpg

 

SAS Super FREQ
Posts: 9,253

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
Regular Contributor
Posts: 210

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.

SAS Super FREQ
Posts: 9,253

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
Regular Contributor
Posts: 210

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: 105

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 Journal style does not use bottom border.jpgModified version of Journal style with frame = ABOVE

 

Regular Contributor
Posts: 210

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
  • 361 views
  • 0 likes
  • 3 in conversation