Data visualization with SAS programming

_ODSDEST=PDF Formatting Bug Workarounds

Reply
Super Contributor
Posts: 443

_ODSDEST=PDF Formatting Bug Workarounds

I have a basic sgpanel statement with a title.  IT displays properly when my output type is html.  When I change my output type to pdf.  The title displays twice. I tried using the

Title; statement to blank out the title however the title remains.

When I use sgpanel and set the output to pdf in SAS 9.2 my Sgpanel headers are repeated each time a new page on my pdf is displayed. 

When I send a tabulate block to pdf the rows with the All command are pushed to the side.

Are there ways to handle these?

SAS Super FREQ
Posts: 864

Re: _ODSDEST=PDF Formatting Bug Workarounds

Answers:

1. "The title displays twice" -- This was fixed in the second maintenance release of SAS 9.2.

2. Headers -- It hard to tell what's going on here without a picture, but it could be due to pagination. Try using the ONEPANEL option on the PANELBY statement.

3. Not sure about the tabulate issue.

Hope this helps!

SAS Super FREQ
Posts: 8,646

Re: _ODSDEST=PDF Formatting Bug Workarounds

Hi:

  These are questions probably best answered by Tech Support. In addition to changing _ODSDEST, you might need to specify some extra options for your stored process like NOGTITLE/NOGFOOTNOTE. Or, depending on your client application, the result format of PDF might not be respected. For example, even if you have an override for _ODSDEST of PDF, that destination is not "received" by all the BI clients. PowerPoint and Web Report Studio will not "receive" PDF results and the output type is changed to SASReport  format under the covers. And, for the Information Delivery Portal or the Stored Process Web App, sometimes you have to send your own content-type header using the STPSRV_HEADER function. And instead of a straight override for _ODSDEST using %STPBEGIN, sometimes you have to use _WEBOUT explicitly with the ODS PDF invocation (not using %STPBEGIN), as shown here: 12994 - Creating a PDF, CSV or RTF file when running the SAS® Stored Process Server, see Example 1.

cynthia

Grand Advisor
Posts: 9,748

Re: _ODSDEST=PDF Formatting Bug Workarounds

The tabulate issue I have experienced a number of times and it is not just with PDF, I have it occur with RTF.

Sometimes ROW=Float will help and others using overrides for column widths helps.

Super Contributor
Posts: 443

Re: _ODSDEST=PDF Formatting Bug Workarounds

Below is a screen shot of the PDF two headers.  The one panel option helped but did not entirely solve the issue.

pdf two titles.png

Researching row float it did not seem to have effect.  Because I am creating my columns dynamically it is extremely difficult to preset the width.

Looking into NOGTITLE

SAS Super FREQ
Posts: 864

Re: _ODSDEST=PDF Formatting Bug Workarounds

A couple of questions:

1. Based on the picture, the only duplication is in the title, not the panel headers. Is that correct?

2. Can you run this command and post the result from your log?:

%put &sysvlong;

Thanks!

Super Contributor
Posts: 443

Re: _ODSDEST=PDF Formatting Bug Workarounds

It looks like the duplicate is for the title for the sgpanel.  I’m not sure what a panel header is.  I’m only using the title statement inside of the sgpanel.


When I ran this command in my html output for Information Delivery Portal I got. 9.02.02M3P041310.

Tabulate in HTML

PDF output good.png

Tabulate in PDF

PDF tabular bad.png

SAS Super FREQ
Posts: 864

Re: _ODSDEST=PDF Formatting Bug Workarounds

Check out this SAS note and see if it helps:

http://support.sas.com/kb/34/600.html

Super Contributor
Posts: 443

Re: _ODSDEST=PDF Formatting Bug Workarounds

Dan,

I found that solution works for removing the double header.  I also found that proc report has less issues in PDF than tabulate.

Post a Question
Discussion Stats
  • 8 replies
  • 530 views
  • 0 likes
  • 4 in conversation