Date:         Wed, 20 Feb 2002 13:33:45 +0100
Reply-To:     Alte@Uni-Greifswald.de
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dietrich Alte <alte@MAIL.UNI-GREIFSWALD.DE>
Organization: Ernst-Moritz-Arndt-Universität Greifswald
Subject:      How to keep macro internal output away from the ods destination
Comments: To: sas-l <SAS-L@uga.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Dear all,

for writing a report with numerous similar tables I need your help:

I have a macro that produces a table with proc tabulate. I would like
to send the whole thing to a rich text formatted file (ods rtf). that
works fine,
but, alas: the macro also writes values which are needed for further
calculations to a file using something like

  proc printto file="holdsas.del" new;

and reads these with an infile statement back later. When I write my
ods rtf statement before the macro call, I get the proc printto
results also in the rtf file, but I want only the table. One way out
would be to redesign the macro for use with the ods facility, but as
it has > 500 lines, I am not very much inclined to go that way.

Is there any way to prevent the proc printto results from entering my
rtf file? I have played with ods exclude, but to no avail.

Any help much appreciated.

-----------------------------------------------------------------
 Dietrich Alte (Statistician, Dipl.-Stat.)
 University of Greifswald - Medical Faculty
 Institute of Epidemiology and Social Medicine
 Walther-Rathenau-Str. 48, D-17487 Greifswald, Germany
 Phone      +49 (0) 3834 - 86 77 13, fax +49 (0) 3834 - 86 66 84
 Email      alte@mail.uni-greifswald.de
 Institute  http://www.medizin.uni-greifswald.de/epidem/
 Study      http://www.medizin.uni-greifswald.de/epidem/ship.htm
-----------------------------------------------------------------