Rowheight proc report with pdf ods

PaulDinsl — Mon, 24 Aug 2020 14:41:39 GMT

hello,

i want to create a table with proc Report to show in a pdf with ODS PDF.

its all working fine but how can i change the cellheight to a "minimum" ?

this is the code:


PROC REPORT Data=VMS_T.doorlooptijd1 nowd style=[background=white foreground=black Vjust=B Just=L font=('Calibri, Arial',1pt,Normal) borderwidth = 0];
COLUMNS 'Wachttijd Dagen'n Score ;
define 'Wachttijd Dagen'n / style=[height=4pt BorderColor=white Vjust=B Just=L font=('Calibri, Arial',4pt,Normal)];
define Score / style=[height=4pt BorderColor=white Vjust=B Just=L font=('Calibri, Arial',4pt,Normal)];
;
RUN;

with this code my cellheight is higher then whats in it. how can i change it?

i tried everything. here is a picture from the pdf with the borderlines.

Re: Rowheight proc report with pdf ods

Cynthia_sas — Tue, 25 Aug 2020 01:16:39 GMT

Hi:
You didn't post any data, so in order to run your code, people have to make "fake" data and try to figure out what your data looks like.
You're already using STYLE= overrides, so you just have to look up cellpadding in order to define less white space inside the cells. Just FYI, with PROC REPORT it is a best practice to put the "area" of the report you want to change in parentheses after the STYLE option, as shown in the example below. Also you need to use RULES/FRAME/CELLSPACING to just disappear the border lines. Consider this:

Cynthia

topic Rowheight proc report with pdf ods in ODS and Base Reporting

Rowheight proc report with pdf ods

Re: Rowheight proc report with pdf ods