Date:         Wed, 4 Oct 2006 08:12:47 -0500
Reply-To:     Deborah Wentworth <debby@CCBR.UMN.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Deborah Wentworth <debby@CCBR.UMN.EDU>
Subject:      Re: underlining columns names, proc report
Comments: To: Yu Zhang <zhangyu05@gmail.com>
In-Reply-To:  <445d9dbe0610031830g5db47c4ar2b51cfa8b0a3fcc9@mail.gmail.com>
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

On Tue, 3 Oct 2006, Yu Zhang wrote:

Yu, thank you so much, that did the trick.

I also got a tip for the low-tech approach of using 'split=!' together
with 'Group A!__________'.

Thanks very much for your help!

Deb

> Date: Tue, 3 Oct 2006 20:30:41 -0500
> From: Yu Zhang <zhangyu05@gmail.com>
> To: Deborah Wentworth <debby@ccbr.umn.edu>
> Cc: SAS-L@listserv.uga.edu
> Subject: Re: underlining columns names, proc report
>
> Deborah,
>
> If what you need is a undeline, RTF control word (\UL) will do the job for
> you. see sample code at below:
>
> ods escapechar='^';
> ods rtf file='c:\underline.rtf';
> proc report data=sashelp.class nowd;
> col sex ("^\ul Physcal character" weight height);
> define sex/order 'GENDER' width=12;
> define weight/sum 'weight' style(column)={cellwidth=1.5in};
> define height/sum 'Height' style(column)={cellwidth=1.5in};
> run;
> ods rtf close;
>
> HTH
>
> YU
>
>
>
> On 10/3/06, Deborah Wentworth <debby@ccbr.umn.edu> wrote:
>>
>> Greetings -
>>
>> I have a question I hope someone might be able to help me with.
>>
>> I have a table where the labels "Group A" and "Group B" each span 2
>> columns containing counts and rates.  I have been trying unsuccessfully to
>> figure out the syntax to underline those 2 labels.
>>
>> My code is below - I'm using ODS to save this as an .rtf file.  Is it
>> possible (at least without too much difficulty) to underline the
>> Group column headers ?
>>
>>
>> proc report data=allevents ;
>>   column event ("Group A" gpAev gpArate ) ("Group B" gpBev gpBrate)  ;
>>   define event / order ' ' left flow style(column) = {just=l cellwidth=12
>> cm};
>>   define gpAev / 'No.' format = 3.0 style(column) = {just=r cellwidth=1.0
>> cm} ;
>>   define gpArate / 'Rate' format = 5.2 style(column) = {just=r
>> cellwidth=1.2 cm} ;
>>   define gpBev / 'No.' format = 3.0 style(column) = {just=r cellwidth=1.0
>> cm} ;
>>   define gpBrate / 'Rate' format = 5.2 style(column) = {just=r
>> cellwidth=1.2 cm} ;
>>
>>
>> Thanks so much in advance.
>>
>> Deb
>>
>>
>>
>> >|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<
>> >                                                    <
>> > Deborah Wentworth                                  <
>> > Coordinating Centers for Biometric Research        <
>> > Division of Biostatistics, University of Minnesota <
>> > 612.626.9005                                       <
>> >                                                    <
>> >|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<
>>
>

>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<
>                                                    <
> Deborah Wentworth                                  <
> Coordinating Centers for Biometric Research        <
> Division of Biostatistics, University of Minnesota <
> 612.626.9005                                       <
>                                                    <
>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<>|<