The SAS Output Delivery System and reporting techniques

Proc Report: How do I add a blank line at bottom of page?

Reply
Contributor
Posts: 24

Proc Report: How do I add a blank line at bottom of page?

Dear all,

Rather simple to add  a blank line at the TOP of a page , however, I am stumped on how to add a blank line to BOTTOM of page for a Vital Signs lisitng ?

 

thanks in advance ! Jill1

Super User
Posts: 10,535

Re: Proc Report: How do I add a blank line at bottom of page?

A more complete description of what you are attempting and the Proc Report code you are currently using may help as well.

 

BREAK and RBREAK and/or LINE statments may come into play. 

Possibly Break after <variable name>; or RBreak after <variablename>;

 

Contributor
Posts: 24

Re: Proc Report: How do I add a blank line at bottom of page?

thank you Ballard!  Here is the code at the bottom of my program. Does this help at all describe what I am trying to do?

 

OPTION LS=200 NODATE NONUMBER MISSING=' ';

TITLE1;

ods escapechar="~";

ODS RTF FILE="&OUTPUTDIR.\&PROGNAME..rtf" STYLE=STYLES.TEST HEADERY=720 FOOTERY=720;

ODS LISTING CLOSE;

PROC REPORT DATA=&PROGNAME NOWD SPLIT="|" MISSING NOCENTER spacing=2

STYLE (REPORT)={OUTPUTWIDTH=8.75 IN}

STYLE (HEADER COLUMN)={asis=on protectspecialchars=off};

COLUMNS REP_NUMPAGES REP_PAGE subjid col1 col2 ST_END col3 ;

 

DEFINE REP_NUMPAGES / GROUP NOPRINT;

DEFINE REP_PAGE / GROUP NOPRINT;

 

DEFINE subjid / group "Subject | Number"

style(column)={just=center cellwidth=2% protectspecialchars=off}

style(header)={just=center cellwidth=2%};

DEFINE col1 / display "Medication Name"

style(column)={just=left cellwidth=5% protectspecialchars=off}

style(header)={just=left cellwidth=5%};

DEFINE col2 / display "Dose Unit / Route / Frequency"

style(column)={just=left cellwidth=4% protectspecialchars=off}

style(header)={just=left cellwidth=4%};

DEFINE ST_END / DISPLAY "Start Date (Day) / End Date (Day)"

style(column)={just=left cellwidth=4.5% protectspecialchars=off}

style(header)={just=left cellwidth=4.5%};

DEFINE col3 / display "Indication"

style(column)={just=left cellwidth=4% protectspecialchars=off}

style(header)={just=left cellwidth=4%};

 

COMPUTE BEFORE _PAGE_ /style=[protectspecialchars=off];

*line "Confidential";

LINE "\ql{&client.}\tqr\tx12500\tab{Page " REP_PAGE 3. " of " REP_NUMPAGES 3. "}";

LINE "Protocol No. &Protocol";

LINE "\par\qc{Listing &lstnum.: Prior and Concomitant Medications}";

**LINE "All Randomized Subjects";

LINE "\brdrb\brdrs ";

ENDCOMP;

 

compute before subjid;

line " ";

endcomp;

COMPUTE AFTER REP_PAGE /style=[protectspecialchars=off];

LINE "\ql{ }\brdrt\brdrs";

line "Note: Day is relative to Study Day 1.";

line " ";

LINE "Generated on &sysdate. by &PROGNAME. /Uses: &SETSUSED";

ENDCOMP;

BREAK AFTER REP_PAGE / PAGE;

RUN;

ODS RTF CLOSE;

ODS LISTING;

;

SAS Super FREQ
Posts: 8,743

Re: Proc Report: How do I add a blank line at bottom of page?

Hi: you already show the code to generate a blank line. It is shown in your COMPUTE BLOCK where you have
line " ";

So it is not clear to me what you mean when you say that you want to create a blank line at the bottom of the listing. Do you want to generate a blank line on every page? If so, you might consider a footnote statement:
footnote " ";

But if you want to add an extra line whether it is blank or has text, then use a COMPUTE block, as you are already doing. If you want a blank line, for example after the "Generated on" line, you would only need to add line " "; AFTER the LINE statement for Generated On.

cynthia
Super User
Posts: 10,535

Re: Proc Report: How do I add a blank line at bottom of page?

Without data it is hard to test.

Since you are providing raw RTF codes that may be interfering but I don't know enough about that to be sure.

 

When using a different data set and less complex code my output to RTF has each table on a different page with the break after as you are using it.

Ask a Question
Discussion stats
  • 4 replies
  • 138 views
  • 0 likes
  • 3 in conversation