topic Re: SAS ODS PDF proc report Group headers repeat in ODS and Base Reporting

SAS ODS PDF proc report Group headers repeat

anandbillava — Thu, 01 Apr 2010 13:40:48 GMT

I am using ods pdf to generate pdf output with proc report. I am also using proc report with by variable. In some of the pages these groups are printing two time and the column headers are not repeated on those pages. This is realy a kind of weired problem. I am totally stuck with no idea.

PLease help me. Thanks a lot.

Re: SAS ODS PDF proc report Group headers repeat

sbb — Thu, 01 Apr 2010 14:30:49 GMT

Share your SAS code to get the most effective response/feedback from the forum subscribers.

Scott Barry
SBBWorks, Inc.

Re: SAS ODS PDF proc report Group headers repeat

anandbillava — Thu, 01 Apr 2010 15:19:41 GMT

Edited in next reply Message was edited by: anandbillava

Re: SAS ODS PDF proc report Group headers repeat

anandbillava — Thu, 01 Apr 2010 15:39:12 GMT

The output pdf contains lot of pages and out of that some of the pages has double entry of group and column headers are not printed for those groups..

Here is the SAS program

ods pdf startpage=no body=_webout;
proc report data=stdrep split=' ' nocenter panels=3 nowd style(REPORT)={cellspacing=0 cellpadding=2 background=white}
style(HEADER)={foreground=black font_weight=bold font_size = 1 just=center}
style(COLUMN)={foreground=black font_size = 1};
COLUMN sbu component bsp_proj_id project_code project pdm
impactno study_title special_name phase sdm actstatus fpfvp fpfva lplv dbl cetC cctC CRFPAGESTREATED
edcC outsrcC provider;
by grVar;
DEFINE sbu / DISPLAY 'TA' width=8 style(column)=[cellwidth=4% just=center];
DEFINE component / DISPLAY 'Compound' width=8 style(column)=[cellwidth=4% just=center];
DEFINE bsp_proj_id / DISPLAY 'BSP Project ID' width=8 style(column)=[cellwidth=4% just=center];
DEFINE project_code / DISPLAY 'Project Code' width=8 style(column)=[cellwidth=4% just=center];
DEFINE project / DISPLAY 'Project' width=8 style(column)=[cellwidth=4% just=center];
DEFINE pdm / DISPLAY 'PDM' width=8 style(column)=[cellwidth=4% just=center];

DEFINE impactno / DISPLAY 'BSP Study No' width=8 style(column)=[cellwidth=4% just=center];
DEFINE study_title /DISPLAY FLOW 'Study Title' width=24 style(column)=[cellwidth=11% just=left];
DEFINE special_name / DISPLAY FLOW 'Special Name' width=12 style(column)=[cellwidth=6% just=left];
DEFINE phase / DISPLAY 'Phase' width=10 style(column)=[cellwidth=5% just=center];
DEFINE sdm / DISPLAY 'SDM' width=14 style(column)=[cellwidth=9% just=left];
DEFINE actstatus / DISPLAY 'Act Status' width=18 flow style(column)=[cellwidth=9% just=left];
DEFINE fpfvp / DISPLAY 'FPFV (P)' width=14 style(column)=[cellwidth=7% just=center];
DEFINE fpfva / DISPLAY 'FPFV(A)' width=14 style(column)=[cellwidth=7% just=center];
DEFINE lplv / DISPLAY 'LPLV (A/P)' width=15 style(column)=[cellwidth=7.5% just=center];
DEFINE dbl / DISPLAY 'DB Lock (A/P)' width=15 style(column)=[cellwidth=7.5% just=center];
DEFINE cetC / DISPLAY 'ET (A/P)' width=8 style(column)=[cellwidth=4% just=center];
DEFINE cctC / DISPLAY 'CT (A/P)' width=8 style(column)=[cellwidth=4% just=center];
DEFINE CRFPAGESTREATED / DISPLAY width=8 'CRFs Treated' style(column)=[cellwidth=4% just=left];
DEFINE edcC / DISPLAY 'EDC' width=8 style(column)=[cellwidth=4% just=left];
DEFINE outsrcC /DISPLAY 'Outsrcd' width=8 style(column)=[cellwidth=4% just=left];
DEFINE provider /DISPLAY 'CRO' width=10 style(column)=[cellwidth=4% just=left];

run;

ods pdf close ;
********Sample output is as below..

Group=TA: PCA
COMPOUND: BAY12-8039
PROJECT: 120099 BAY12-8039/GMD/02 BAY12-8039, Product maintenance
PDM: Fischer, Cornelia Inge

Group=TA: PCA
COMPOUND: BAY12-8039
PROJECT: 120099 BAY12-8039/GMD/02 BAY12-8039, Product maintenance
PDM: Fischer, Cornelia Inge
11980 BAY12-8039,

No column header***************
Column Values *********

**Next Group ***
Column header*********
Column Values************

This happens only for some of the pages..

Message was edited by: anandbillava Message was edited by: anandbillava

Re: SAS ODS PDF proc report Group headers repeat

Cynthia_sas — Thu, 01 Apr 2010 16:24:34 GMT

Hi:
I see you are using _webout... Is that with SAS/Intrnet or with a stored process??

cynthia

Re: SAS ODS PDF proc report Group headers repeat

anandbillava — Thu, 01 Apr 2010 16:40:55 GMT

Yes its a sas stored process creates using enterprise guide.

Re: SAS ODS PDF proc report Group headers repeat

Cynthia_sas — Thu, 01 Apr 2010 20:16:07 GMT

Hi:
It almost sounds like you are running into an issue similar to this -- although this issue was reported with PROC PRINT:
http://support.sas.com/kb/16/792.html or possibly this one: http://support.sas.com/kb/9/372.html

In either case, there are several things about your code that are inappropriate for ODS PDF destinations, such as:
panels=3
width=
FLOW

In addition, you are not using PROC REPORT group variables, it looks like all your variables are a DISPLAY usage and your issue is really with BY group processing, not PROC REPORT GROUP usage behavior

These are minor distractions, however, since the LISTING-only options are ignored by ODS PDF. A more critical problem, might be caused by the fact that your cellwidth percents add up to more than 100% (121% according to my calculator). This may be causing some issues with PROC REPORT, too.

Since you are running this program in the context of a stored process, your best resource will be Tech Support. If you open a track with Tech Support, they can look at your data and your particular BI configuration and see whether some interaction of data/destination/platform or some odd interaction between BY processing with the incorrect cellwidths is causing the problem.

cynthia

Re: SAS ODS PDF proc report Group headers repeat

anandbillava — Thu, 01 Apr 2010 23:36:37 GMT

How to send this issue to tech support ?
I have corrected all the distractions. But still the problem persists..

Re: SAS ODS PDF proc report Group headers repeat

sbb — Fri, 02 Apr 2010 01:23:47 GMT

From SAS discussion forms, the webpage footer has information and a link for opening a SAS track/issue - here's the link:

http://support.sas.com/ctx/supportform/createForm

Scott Barry
SBBWorks, Inc.