The SAS Output Delivery System and reporting techniques

SAS ODS PDF proc report Group headers repeat

Reply
Contributor
Posts: 72

SAS ODS PDF proc report Group headers repeat

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.
Super Contributor
Super Contributor
Posts: 3,174

Re: SAS ODS PDF proc report Group headers repeat

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

Scott Barry
SBBWorks, Inc.
Contributor
Posts: 72

Re: SAS ODS PDF proc report Group headers repeat

Edited in next reply Message was edited by: anandbillava
Contributor
Posts: 72

Re: SAS ODS PDF proc report Group headers repeat

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
SAS Super FREQ
Posts: 8,743

Re: SAS ODS PDF proc report Group headers repeat

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

cynthia
Contributor
Posts: 72

Re: SAS ODS PDF proc report Group headers repeat

Yes its a sas stored process creates using enterprise guide.
SAS Super FREQ
Posts: 8,743

Re: SAS ODS PDF proc report Group headers repeat

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
Contributor
Posts: 72

Re: SAS ODS PDF proc report Group headers repeat

How to send this issue to tech support ?
I have corrected all the distractions. But still the problem persists..
Super Contributor
Super Contributor
Posts: 3,174

Re: SAS ODS PDF proc report Group headers repeat

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.
Ask a Question
Discussion stats
  • 8 replies
  • 372 views
  • 0 likes
  • 3 in conversation