topic Re: _ODSDEST=PDF Formatting Bug Workarounds in Graphics Programming

_ODSDEST=PDF Formatting Bug Workarounds

DavidPhillips2 — Thu, 02 Apr 2015 17:25:11 GMT

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?

Re: _ODSDEST=PDF Formatting Bug Workarounds

DanH_sas — Thu, 02 Apr 2015 17:56:41 GMT

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!

Re: _ODSDEST=PDF Formatting Bug Workarounds

Cynthia_sas — Thu, 02 Apr 2015 17:59:54 GMT

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

Re: _ODSDEST=PDF Formatting Bug Workarounds

ballardw — Thu, 02 Apr 2015 18:12:20 GMT

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.

Re: _ODSDEST=PDF Formatting Bug Workarounds

DavidPhillips2 — Thu, 02 Apr 2015 18:36:20 GMT

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

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

Re: _ODSDEST=PDF Formatting Bug Workarounds

DanH_sas — Thu, 02 Apr 2015 18:44:07 GMT

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!

Re: _ODSDEST=PDF Formatting Bug Workarounds

DavidPhillips2 — Thu, 02 Apr 2015 18:55:19 GMT

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

Tabulate in PDF

Re: _ODSDEST=PDF Formatting Bug Workarounds

DanH_sas — Thu, 09 Apr 2015 15:45:28 GMT

Check out this SAS note and see if it helps:

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

Re: _ODSDEST=PDF Formatting Bug Workarounds

DavidPhillips2 — Thu, 09 Apr 2015 16:28:07 GMT

Dan,

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