topic Re: Column header truncated when exporting to PDF in ODS and Base Reporting

Column header truncated when exporting to PDF

TTNY — Tue, 30 Apr 2013 08:34:31 GMT

When producing the report in EG all headers look fine. But when exporting to PDF one of the column headers, which is quite large, is truncated. The strange thing is that when my collague runs the exact same report and exports to PDF there is no truncation and column headers look fine. So my question is if there are any settings where rowsize or textsize for exporting to PDF can be set, or any other setting that might influence the truncation. Screen dumps are attached.

Re: Column header truncated when exporting to PDF

Ksharp — Tue, 30 Apr 2013 09:43:16 GMT

Did you use cellheight= or cellwidth= style ?

Re: Column header truncated when exporting to PDF

TTNY — Tue, 30 Apr 2013 12:16:50 GMT

It seems I get the same issue with or without the width option. Here is my code:

proc report data=uniquedata style(header)=[background=white] split='*';
column ('' ('' soc)) ('' ('' pt))
('Spontaneous, including competent authorities *(worldwide) and literature'
('Serious' per_ser_s1 cum_ser_s1) ('Non-serious' per_nonser_s1 cum_nonser_s1))
('Total *Spontaneous'('' tot))
('Non-interventional post-*marketing studies and *reports from other *solicited sources'
('Serious' per_ser_s2 cum_ser_s2));

define soc / group 'SOC' style(header)=[just=l];
define pt / group 'PT' style(header)=[just=l];
define per_ser_s1 / analysis 'PSUR *period';
define cum_ser_s1 / analysis 'Cumulative';
define per_nonser_s1 / analysis 'PSUR *period';
define cum_nonser_s1 / analysis 'Cumulative';
define tot / analysis 'Cumulative *all';
define per_ser_s2 / analysis 'PSUR *period';
define cum_ser_s2 / analysis 'Cumulative';

Re: Column header truncated when exporting to PDF

Cynthia_sas — Wed, 01 May 2013 16:09:10 GMT

Hi:

I ran the report a couple of different ways using SAS 9.3 and didn't run into any issues such as you show in your screen shots. One thing that I am curious about is your statement "When producing the report in EG all headers look fine. But when exporting to PDF..."

I am not sure what you mean when you say "exporting to PDF". When you use EG, I assumed that you meant you clicked the PDF choice to automatically create PDF output from within EG. When you do that, EG adds explicit ODS PDF statements to the behind the scenes code. So, how did you "export to PDF"? Did you turn your code into a stored process and run it in Web Report Studio? Did you accidentally create SASReport output in EG? Are you using the Information Delivery Portal?

I would recommend opening a track with Tech Support. I used EG and I used SAS with explicit ODS statements and I could not replicate your header truncation. I think Tech Support will be your best help on this issue.

cynthia

Re: Column header truncated when exporting to PDF

TTNY — Thu, 02 May 2013 07:10:22 GMT

Dear Cynthia,

Thank you for your answer. Perhaps the problem is the way I get my report into PDF. Please see attached screen dumps.

Best regards

Tatiana

Re: Column header truncated when exporting to PDF

Cynthia_sas — Thu, 02 May 2013 14:47:17 GMT

Ah, that was one method I did NOT try. Since I prefer to let ODS control the creation of the PDF document, I used one of 2 methods:

1)explicit ODS control statements:

ods _all_ close;

ods pdf file='c:\temp\xxxx.pdf';

... the code ...

ods pdf close;

2) using the Tools --> Options --> Results General menu choice to DE-select SASReport format and SELECT the check box for PDF results

When I used either of those methods, I did not experience any truncation. I do not know what method the Export to PDF choice uses, so if you want to continue to use that method, then you will have to pursue your question with Tech Support.

Cynthia