LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (May 2001, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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
Comments:   To: Jacques Thibault <jacques_t@HOTMAIL.COM>
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.


Back to: Top of message | Previous page | Main SAS-L page