| Date: | Fri, 11 May 2001 10:00:41 -0700 |
| Reply-To: | Lauren Haworth <haworthl@GENE.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Lauren Haworth <haworthl@GENE.COM> |
| Organization: | Genentech, Inc. |
| Subject: | Re: Tabulate |
|
| Content-Type: | text/plain; charset=us-ascii |
Jacques,
You can easily do this in v8 if you're creating ODS output. Just use the
classlev statment with a style option to set the justification for those cells.
I've attached an example program that creates RTF output.
-- Lauren
proc format;
value testf 1='One'
2='Two'
3='Three';
run;
data test;
do I=1 to 100;
company=ceil(ranuni(1234)*3);
format company testf.;
trucks=ceil(ranuni(2345)*60);
output;
end;
run;
ods rtf file='test.rtf';
proc tabulate data=test;
class company;
classlev company / S={JUST=R};
var trucks;
table company, trucks*n;
run;
ods rtf close;
Jacques Thibault wrote:
> Hi SAS-L'rs,
>
> Is it possible to right justify a formatted value in a PROC TABULATE?
>
> Example:
> proc tabulate data=one;
> class cie_a;
> table all='Total:' cie_a,all='Number of Trucks'*(F=8.0)
> /rts=30 box='Status';
> format a $frmta30.;
> run;
>
> Status Number of Trucks
>
> Total: 34
> compa 4
> compb 5
> compc 20
> compd 5
>
> ^^^^
>
> I want the company names (cie_a) indented on the right side. I tried to put
> spaces in the format values, but they are not there anymore in my output.
>
> Any help would be appreciated,
> Thanks,
> Jacques
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
|