Thanks cynthia.. that works ... View more

Thank you so much cynthia. But incase if I must add group header for the subsequent pages if one group spills to different pages. ... View more

data shoes; set sashelp.shoes; run; ods pdf file='c:\1.pdf'; proc report data=shoes split=' ' nocenter 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 region product subsidiary stores sales; define region / group noprint; DEFINE edcC / DISPLAY 'EDC' ; DEFINE product / DISPLAY 'EDC' ; DEFINE subsidiary / DISPLAY 'EDC' ; DEFINE stores / DISPLAY 'EDC' ; DEFINE sales / DISPLAY 'EDC' ; compute before region / style=Header{just=l font_size = 1 font_weight=bold background=wheat}; before_line = catx(' ',trim(region)); line before_line $300.; endcomp; run; ods pdf close ; The above program writes output to a ODS destincation. You can see in the same page there are multiple groups printed. But the column headers are printed only once at the starting of the page and its not printed for each of the group if group starts in between pages. I dont wnat skip the pages when group does not have more observation to print in that page. Hopefuly this will help you in understanding. ... View more

HI Cynthia, I am trying to add headers for each of the group, but at the same time when it encounters new page It should not print header twice. Please let me know if you have any idea. Anand ... View more

I dont have any problem in sharing the code. But its a big program and with lot of dependent data. I am able to get succeed about 80% on this problem. Now i am stuck with order of the axis. If i dont mention the by value in order value then the order is clustered. These orders are dynamic always. For .eg In axis if i put order = 1(a) to 100000(b) by 1000(c) - It works fine with beautiful graph But if put order = 1(a) to 100000(b) then the graph is clustered. Problem is i do know the a and b. But determing the c is becoming challenge for me. ... View more

NOTE: 19 observation(s) contained a MISSING value for the TRIAL_PATIENTS_PLAN * PERIOD_END_DATE request. NOTE: 19 observation(s) contained a MISSING value for the TRIAL_PATIENTS_ACTUAL * PERIOD_END_DATE request. NOTE: 19 observation(s) contained a MISSING value for the TREAT_PATIENTS_ACTUAL * PERIOD_END_DATE request. Other than that my data set has many missing observations. If i make the missing observation to 0 then it plots. but i dont need 0 to be plotted in my graph. ... View more

Thanks Cynthia... I got solution for many of my problems with your suggestion. I appreciate. Thanks once again. ... View more

Thanks cynthia, But in my case the group headers printed as title for each group (may be in same page depending up on the size of the group). If i use the method mentioned by you the group headers are printed inside the table and after each group. My condition is Group headers should be printed on top of each group not at the bottom and not inside the table. Is there any other way you suggest. Anand ... View more

But i do not want each group to be printed in different page. I tihnk using byval. byvar and computer techniques will result in each group to be printed in different page ... View more

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

Yes its a sas stored process creates using enterprise guide. ... View more

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 ... View more

Edited in next reply Message was edited by: anandbillava ... View more