BookmarkSubscribeRSS Feed
PaulDinsl
Calcite | Level 5

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.


Knipsel2.PNG

 

1 REPLY 1
Cynthia_sas
Diamond | Level 26

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_sas_0-1598318134332.png

 


Cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 732 views
  • 1 like
  • 2 in conversation