topic Re: Proc Report: How do I add a blank line at bottom of page? in ODS and Base Reporting

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

NJGIRL — Thu, 25 May 2017 16:27:59 GMT

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

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

ballardw — Thu, 25 May 2017 16:49:41 GMT

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>;

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

NJGIRL — Thu, 25 May 2017 17:37:24 GMT

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;

;

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

Cynthia_sas — Thu, 25 May 2017 17:53:15 GMT

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

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

ballardw — Thu, 25 May 2017 18:01:07 GMT

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.