Thank you Andre and Kevin for the time you spent on trying to resolve the problem. Sorry I didn't response your earlier reply to my initial post, I was so busy yesterday for my work. I just briefly went through your analysis (still not thoroughly), and concluded, happily, that at least we have a consent that my initial observation is right, yet unfortunately concluded that this is a problem not quite easy to solve so far (except maybe using some non-SAS way, such as DDE motioned by Kevin). I may try again later on when I have some time.

As to the philosophical position Andre stand regarding the use (or abuse :-) of rtf format, I have to say that personally I hold almost the same position as you, I do believe rtf file, because it is not a page description format like postscript and pdf, are not a good vehicle to deliver a report. I'm exploring the possibility to use ods/rtf to replace the current data step/macro based rtf system in our shop only because I feel it's too complicated to understand and use. I used to do a lot of pdf/postscript before I join this shop a few months ago, I'll see if there is any room for me to promote pdf format.

Thanks again.

Best regards,

Ya

-----Original Message----- From: Delaney, Kevin P. [mailto:khd8@cdc.gov] Sent: Tuesday, February 11, 2003 8:03 AM To: 'WIELKI Andre'; Huang, Ya Cc: 'SAS-L@LISTSERV.UGA.EDU' Subject: RE: ODS/rtf, pagebreak vs section break -- Warning, long!!

Andre Wrote: "If you use sas graph in rtf destination you cannot obtain multiple graphs on one page except the use of a template."

Which I thought was true until I started playing around with different graphics devices last night at home, check this out:

(Note: Titles still screwed up here, any Birdies care to explain how SAS picks which Title to use?)

data test; input x y @@; datalines; 1 2 2 4 3 8 4 10 5 15 ; run; options orientation=portrait; goptions device=activeX /*jpeg*/ hsize=7in vsize=5in;*Use Device=ActiveX, default behavior appears to be to NOT include Titles on the graph, which is nice. ActiveX and JPEG are the only destinations (I tried Gif,CGM, PNG, TIFFP and default is EMF) where this (2 graphs to a page) seems work!!;

symbol i=j v=dot; title; ods listing close; title1 "Test first title, These are still all messed up!"; ods rtf file="c:\temp\pagebr.rtf";

Title1 "Use this Title on All pages"; ods rtf startpage=never ; *ods rtf startpage=no;* or never too; proc gplot data=test; title1 'PLOT #1'; plot y*x /name="mygraph" noframe; run; quit;

ods rtf anchor="Newpage"; Title1 "Test second Title"; proc gplot data=test; title1 'PLOT #2'; plot y*x /name="mygraph" noframe; run; quit;

proc gplot data=test; title1 'PLOT #3, Where did that come from?'; plot y*x /name="mygraph" noframe; run; quit;

ods rtf startpage=now; ods rtf startpage=now;*Need two consequetive to get Section (New Page) from SAS V8.2 (TS2M0); *V9 Startpage=Never works much better (inserting Section (continuous) between graphs) rather than inserting nothing in v8.2, so we only need the one, comment out this second one if running V9!; Title1 "Test second Title"; proc gplot data=test; title1 'PLOT #4'; plot y*x /name="mygraph" noframe; run; quit;

ods rtf close; ods listing;

-----Original Message----- From: WIELKI Andre [mailto:wielki@ined.fr] Sent: Tuesday, February 11, 2003 8:08 AM To: Delaney Kevin P.; 'Huang Ya' Cc: 'SAS-L@LISTSERV.UGA.EDU' Subject: RE: ODS/rtf, pagebreak vs section break -- Warning, long!!

Kevin and Ya, I resume here my observations about the behavior of rtf and pdf First of all some reference about my environment Windows 2000 + sas 8.02.02M0P012301 (extract from About Sas system) and Office XP for the word version

In a french pdf file "Allo Support n°9" from sas support at http://www.sas.com/offices/europe/france/services/techsup/allosupport.html

I have found some indication about he use of titles and page skip in ods rtf

My basic test start from this code (sorry i have not diabete;fitness and houses are old tables from 6.12) ods rtf file="c:\pagebr.rtf" ; title "first title"; proc print data=sasuser.fitness(obs=2);run; title "second title"; proc print data=sasuser.houses(obs=4);run; title "third title"; proc print data=sashelp.class;run; ods rtf close;;

1)By default we are in startpage=on/yes situation consequence: page skip are present at each proc and titles were varying. In my version of Word 'page skip' means a =======section skip(following page)======== translated from french

2)If you start using startpage=no in the ods rtf file statement, consequence: no more page skip and all titles disappear But if you add some ods rtf startpage=now; just before closing the ods rts close; one title appear in fact the last one (it is like the title value where substitued last on previous one)

3)if you start with a normal ods rtf file without startpage, and you put ods rtf startpage=no; AFTER the run of the first proc print then title1 is printed and remain on all the potential pages all this without page skip

4)in this case ods rtf file="c:\pagebr.rtf" ; title "first title"; proc print data=sasuser.fitness(obs=2);run; ods rtf startpage=no; title "second title"; proc print data=sasuser.houses(obs=4);run; ods rtf startpage=on; title "third title"; proc print data=sashelp.class;run; ods rtf close;; i have one page skip and two titles the first on page 1 and last one on page two.

5) ods rtf file="c:\pagebr1.rtf" ; title "first title"; proc print data=sasuser.fitness(obs=2);run; ods rtf startpage=no; title "second title"; proc print data=sasuser.houses(obs=4);run; ods rtf startpage=now; title "third title"; proc print data=sashelp.class;run; ods rtf close; ods listing;; Two page skip thus an empty page and third title lost You have only one page skip if you set only one startpage=now.

6) ods rtf file="c:\pagebr2.rtf" ; title "first title"; proc print data=sasuser.fitness(obs=2);run; ods rtf startpage=no; title "third title"; proc print data=sasuser.houses(obs=4);run; ods rtf startpage=now; proc print data=sashelp.class;run; ods rtf close; ods listing;; i obtain 1 page skip and title one and third but observe where i have to put it!

I recognize i have made some confusion between 5 and 6 in my last mail to Ya.

If you use sas graph in rtf destination you cannot obtain multiple graphs on one page except the use of a template.

Kevin, I am waiting v9 and hope ther will be a lot of new accomodations for rtf. Andre

___________ WIELKI Andre INED - Service Informatique 133 Bd Davout, 75 980 Paris Cedex 20 FRANCE Tel: 01 56 06 21 54