BookmarkSubscribeRSS Feed
anandbillava
Fluorite | Level 6
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.
8 REPLIES 8
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Share your SAS code to get the most effective response/feedback from the forum subscribers.

Scott Barry
SBBWorks, Inc.
anandbillava
Fluorite | Level 6
Edited in next reply Message was edited by: anandbillava
anandbillava
Fluorite | Level 6
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
Cynthia_sas
SAS Super FREQ
Hi:
I see you are using _webout... Is that with SAS/Intrnet or with a stored process??

cynthia
anandbillava
Fluorite | Level 6
Yes its a sas stored process creates using enterprise guide.
Cynthia_sas
SAS Super FREQ
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
anandbillava
Fluorite | Level 6
How to send this issue to tech support ?
I have corrected all the distractions. But still the problem persists..
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 1801 views
  • 0 likes
  • 3 in conversation