topic Re: column in proc report overlaps the footnote in SAS Programming

column in proc report overlaps the footnote

Jedrzej — Wed, 12 Oct 2022 09:55:26 GMT

Hi,

im trying to create proc report (RTF) and text of one variable is so long that it's overlaping my footnotes.

do you have and idea how to control the size of the column that will fit in one page or continues text on another.? I cant make this variable wider

define var1 display style(header)={just=center} center flow style(column)=[just=l width = 16% asis = on] style(header)=[just=l asis=on];

regards,

jedrzej

Re: column in proc report overlaps the footnote

Ksharp — Wed, 12 Oct 2022 12:12:48 GMT

Add a FORMAT to that variable ?

ods rtf file='c:\temp\temp.rtf';
proc report data=sashelp.class nowd;
define name/format=$4.;
run;
ods rtf close;

Re: column in proc report overlaps the footnote

ballardw — Wed, 12 Oct 2022 15:03:48 GMT

You may have to supply more details such as your ODS RTF, or ODS Tagsets.rtf statement as options like Bodytitle, Bodytitle_aux, Keepn and Startpage plus the Ods style used can interact affecting such behaviors. We may also need the entire Report code. When you start controlling many output options you may create some interesting interactions as well.

ODS Tagsets.rtf has a bit more control on page layout such as Tablerows but may not address what you need if you have extremely long values crammed into a narrow column of output.

Reduce font size for that cell? a compute block with call define could do such based on length of the text but again, not sure if that will help enough if the text is very long.