Date:         Wed, 2 Jul 2003 03:32:49 -0700
Reply-To:     John Kirkpatrick <johnk_uk@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         John Kirkpatrick <johnk_uk@HOTMAIL.COM>
Organization: http://groups.google.com/
Subject:      Re: ODS RTF - Landscape?
Content-Type: text/plain; charset=ISO-8859-1

Bruce,

Here's one way.  There are many others.  The best one will depend on
exactly what you're trying to do.

data test;
 do i=1 to 10;
   y = ranuni(0);
   output;
  end;

ods rtf file="test.rtf";
proc report data=test nowindows;
  column i y;
  define i/display;
  define y/display
           style(column)={protectspecialchars=off
                          pretext="\tx300\bullet\tab "
                          cellwidth=3cm
                          }
           left;
run;
ods rtf close;

Notes:

This will only work for the RTF destination as we're passing
destination specific code.  For a gneral solution, use the S={} syntax
with ODSESCAPECHAR to select the symbol font, print your chosen bullet
and then revert to the "normal" font.  Alternatively, the \dagger
inline format will produce a dagger bullet.  With both of these
approaches, putting a tab after the bullet symbol may not be
straightforward  (again, depending on context).

protectspecialchars=off tells ODS not to try to interpret ODS command
words (which all begin with a backslash: "\").

pretext specifies a string to be passed to ODS immediatly prior to the
data value.  In this case, "\tx300" defines a left aligned tab stop
300 twips (1440twips=1inch) from the left margin of the column;
"\bullet" defines a bullet mark, "\tab" inserts the tab character.

The final space is ESSENTIAL to separate the RTF control code from the
printed text.

CELLWIDTH=3cm defines a sensible width for the column, overrding the
default which would allow for the RTF code to be printed as well.
(SAS doesn't know it's non-printing.)

I hope that gets you started in the right direction.

Cheers,

John

bjohnson@SOLUCIENT.COM (Bruce Johnson) wrote in message news:<8BFC8E80E55BFE41B0DE181B6BE8802D07488FD3@aaemail01.aa.hcia.com>...
> Thanks!  Any chance you know how to create a bullet-ed list in a RTF file?
>
> Bruce A Johnson
> Senior Data Analyst
> Solucient, LLC
> (847) 440-9635
>
>
> -----Original Message-----
> From: Mark Lamias [mailto:Mark.Lamias@grizzard.com]
> Sent: Friday, June 27, 2003 2:56 PM
> To: 'Bruce Johnson'; SAS-L@LISTSERV.UGA.EDU
> Subject: RE: ODS RTF - Landscape?
>
>
> before your ods rtf statement, put the following line:
>
> options orientation=landscape;
>
> Sincerely yours,
>
> Mark J. Lamias
>
> -----Original Message-----
> From: Bruce Johnson [mailto:bjohnson@SOLUCIENT.COM]
> Sent: Friday, June 27, 2003 3:56 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: ODS RTF - Landscape?
>
>
> Is there an easy way to define the RTF page size to be landscape rather than
> portrait?
>
> Thanks so much!
>
>
> Bruce A Johnson
> Senior Data Analyst
> Solucient, LLC
> (847) 440-9635
>
>
>
>
> This message is a private communication. It may contain information that is
> confidential and legally protected from disclosure. If you are not an
> intended recipient, please do not read, copy or use this message or any
> attachments, and do not disclose them to others.
>
> Please notify the sender of the delivery error by replying to this message,
> and then delete it and any attachments from your system. Thank you.
> Solucient LLC.
>
>
> This message is a private communication. It may contain information that is
> confidential and legally protected from disclosure. If you are not an
> intended recipient, please do not read, copy or use this message or any
> attachments, and do not disclose them to others.
>
> Please notify the sender of the delivery error by replying to this message,
> and then delete it and any attachments from your system. Thank you.
> Solucient LLC.