Desktop productivity for business analysts and programmers

how to customize lines through proc report

Reply
N/A
Posts: 0

how to customize lines through proc report

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

Re: how to customize lines through proc report

Ask a Question
Discussion stats
  • 1 reply
  • 104 views
  • 0 likes
  • 2 in conversation