Date: Fri, 27 Dec 2002 16:39:10 -0800
Reply-To: makkena <makkenar@AOL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: makkena <makkenar@AOL.COM>
Organization: http://groups.google.com/
Subject: ODS PROC REPORT
Content-Type: text/plain; charset=ISO-8859-1
Hello Folks,
Hope all of you celebrated Christmas.
I have a following problem with ODS Proc Report. I want to put the
continuation mark if the same group continues on to next page in my
listings. I was succeeded in ASCII but not in ODS. I got a potential
solution by creating a flag variable in my data step and force a page
break in proc report. In the present scenario I know 14 rows could fit
in a page. My problem is what if the values of value is character and
has long values then this is not going to work. Can anybody help me to
dynamically do this?.
Thanks in advance,
Makkena
data test;
length grp $ 8;
do grp='AA','BB','CC';
do i=1 to 75;
value=int(ranuni(i)*100);
output;
end; end;
run;
proc sort data=test;
by grp;
run;
data test; set test; by grp;
myval=last.grp;
* create a flag variable to force page breaks in proc report;
length flag 8;
retain flag;
if _n_=1 then flag=1;
else if not(mod(_n_,14)) then flag=flag+1;
run;
options ls=80 ps=54 pageno=1;
ods pdf body="test.pdf";
proc report data=test nowd headline headskip;
col flag myval grp value;
define flag / order noprint;
define myval / display noprint;
define grp / order;
define value / display;
break after flag / page;
compute after _page_;
if myval=0 then text='Continued';
else text=' ';
line ' ';
line @33 text $10.;
endcomp;
run;
ods pdf close;