how to customize lines through proc report

deleted_user — Wed, 03 Oct 2007 22:05:12 GMT

Hi,

Below there is my proc report code to generate a report:

options nocenter;

proc report data=WORK.QUERY8283 nowd headskip split='*' spacing=1 ;

column Gb_Br_Name
Ageing
Pi_In_Ordtype,
(''(Pi_In_Recgoods=Pi_In_Recgoods1))
Pi_In_Recgoods;

define Gb_Br_Name / group width=40 flow FORMAT=$30.;
define Ageing / group width=25 flow FORMAT=$25.;
define Pi_In_Ordtype / 'Order Type' across ;
define Pi_In_Recgoods1 / 'Value' FORMAT=COMMA16.2 ;
define Pi_In_Recgoods / 'Total*Value ' FORMAT=COMMA16.2;
rbreak after /summarize ol;
break after Ageing / suppress skip;
break after Gb_Br_Name / summarize ol suppress skip;
compute before _page_;
line @2 "&div"
@10 "&repnum"
&_CENT "&Rep_title"
@109 "&repdate";
line &_CENT &_LEN*'-';
endcomp;
compute after Gb_Br_Name ;
Ageing = 'Branch Total';

endcomp;
compute after;
Ageing ='Company Total';
_last_page=1;
endcomp;
compute after _page_;
_page+1;
if _last_page=1 then
text='End of Report';
else text='';
pagetxt='Page '||trim(left(_page));
line center pagetxt $20.;
line center text $20.;
endcomp;
run;

I am getting proper output the only problem is that it prints a line above branch total label and company total also which i want to suppress the line
I dont want to use Line statement in my code.
Any solution for this issue?

Re: how to customize lines through proc report

Cynthia_sas — Thu, 04 Oct 2007 03:50:36 GMT

Hi:
See this posting:
http://support.sas.com/forums/thread.jspa?messageID=7894Ỗ

cynthia

topic how to customize lines through proc report in SAS Enterprise Guide

how to customize lines through proc report

Re: how to customize lines through proc report