The SAS Output Delivery System and reporting techniques

Column header truncated when exporting to PDF

Reply
Occasional Contributor
Posts: 5

Column header truncated when exporting to PDF

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.trunc_header.pngnotrunc_header.png

Super User
Posts: 9,681

Re: Column header truncated when exporting to PDF

Did you use cellheight= or cellwidth=   style ?

Occasional Contributor
Posts: 5

Re: Column header truncated when exporting to PDF

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

SAS Super FREQ
Posts: 8,743

Re: Column header truncated when exporting to PDF


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

Occasional Contributor
Posts: 5

Re: Column header truncated when exporting to PDF

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

export1.png

export2.png

SAS Super FREQ
Posts: 8,743

Re: Column header truncated when exporting to PDF

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;

OR

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

Ask a Question
Discussion stats
  • 5 replies
  • 353 views
  • 0 likes
  • 3 in conversation