Date:         Wed, 22 Dec 2004 17:26:01 -0500
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: Report trick /help wanted
Comments: To: Ben Benjamin <benpub7@YAHOO.COM>

Depends on what destination of the proc report you use, if it
is traditional listing, try split and flow option. For ods/rtf,
you have to code in a rtf control word:


data class;
 set sashelp.class;
 unitwt=compress(put(weight,best.)||'~'||'(kg)');
 unitwt1=compress(put(weight,best.)||'^R/RTF "{\line}"'||'(kg)');
run;

proc report data=class nowd headline split='~';
column sex name age unitwt;
define sex / order;
define name / display;
define unitwt / width=12 left flow;
run;

ods rtf file="c:\temp\junk.rtf";
ods listing close;
ods escapechar='^';

proc report data=class nowd headline;
column sex name age unitwt1;
define sex / order;
define name / display;
define unitwt / width=12 left flow;
run;

ods listing;
ods rtf close;

Kind regards,

Ya Huang




On Wed, 22 Dec 2004 16:58:19 -0500, Ben <benpub7@YAHOO.COM> wrote:

>one cell means a space for value : Aij, i=I, j=J.
>
>I was asked to show result and unit not after it but under it (in the same
>row).
>
>I wish I am a boss.
>
>Thanks.
>
>
>
>
>
>
>
>On Wed, 22 Dec 2004 12:40:07 -0800, Dennis Diskin <diskin@SNET.NET> wrote:
>
>>Ben,
>>
>>One technique Iv'e used in proc report is to keep them as separate
>columns, but left justify the units so they appear right after the value.
>This depends on what you mean by "cell'.
>>
>>Regards,
>>Dennis Diskin
>>
>>Ben <benpub7@YAHOO.COM> wrote:
>>I was trying to make a report , was asked to put measurements and their
>>units in one cell (appeared in two lines), How to do it? simply adding
>>empty space between value and units, doesn't work well, I will
>>automatically run at least one hundred report, for this report.
>>
>>(final report in rtf format)
>>
>>Many thanks