Date:         Tue, 24 Jul 2001 20:52:05 -0400
Reply-To:     "Abakah Nori (crm1nxa)" <crm1nxa@UPS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Abakah Nori (crm1nxa)" <crm1nxa@UPS.COM>
Subject:      Re: ODS and proc tabulate output in RTF format
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset="iso-8859-1"

Connie,
I had a similar issue recently . Take a look at how I was able to shrink the
tabulate output with lots of help from the ODS Queen's book. It makes
extensive use of the STYLE= and FONT_SIZE= options.
hope this helps
Nori

<...snip...>

ODS LISTING CLOSE;

ODS HTML BODY="&DS"
         PATH=DCOLLECT
        STYLE=DEFAULT
           RS=NONE;

PROC TABULATE DATA=REARRANGE   STYLE={FONT_SIZE=1.5};
 CLASS MDATE DAY SYSID / STYLE={BACKGROUND=BLUE
                                FOREGROUND=YELLOW
                                FONT_FACE=TIMES
                                FONT_SIZE=2};
 TABLE (MDATE='DATE'*DAY),
        (SYSID='' ALL='DAILY TOTAL')*
        (CYL*F=5.*SUM='' EXTENTS='EX'*F=2.*SUM='')
       / RTS=22 BOX='RAMAPO'    STYLE={BACKGROUND=BLUE
                                FOREGROUND=YELLOW
                                FONT_FACE=TIMES
                                FONT_SIZE=1};
 VAR CYL EXTENTS       / STYLE={BACKGROUND=GREEN
                                FOREGROUND=PURPLE
                                FONT_FACE=TIMES
                                FONT_SIZE=1};
 CLASSLEV MDATE DAY SYSID   / STYLE={FONT_FACE=TIMES
                                FONT_SIZE=1};
 KEYWORD ALL / STYLE={FONT_FACE=TIMES
                      FONT_SIZE=1};
 FORMAT  MDATE $MDFMT. DAY DAYFMT3.;
 TITLE1 FONT=TIMES HEIGHT=3 "DASD USAGE INFORMATION";
 TITLE2 FONT=TIMES HEIGHT=3 "FOR RAMAPO %SYSFUNC(DATE(), MONYY7.)";
 TITLE3 FONT=TIMES HEIGHT=3 "&THETITLE";
RUN;

ODS HTML CLOSE;
ODS LISTING;

<... snip ...>
-----Original Message-----
From: Connie Zhou [mailto:czhou1949@home.com]
Sent: Tuesday, July 24, 2001 6:29 PM
To: SAS-L@LISTSERV.VT.EDU
Subject: ODS and proc tabulate output in RTF format


I tried the ODS HTML format of proc tabulate and open it in MS word,
but the table had thick boarders and big cell size, takes a lot of
editting in word to get it to the way I wanted.
does anyone know how get an RTF output using ODS? and would the table
look as if it was created in word?

Many Thanks,


Connie