LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (December 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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;


Back to: Top of message | Previous page | Main SAS-L page