Date:         Fri, 24 Jun 2005 15:12:58 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: how to right align numeric-character data
Comments: To: a@MAILINATOR.COM
In-Reply-To:  <727eefc4.0506240702.7b6068c8@posting.google.com>
Content-Type: text/plain; format=flowed

Susa,

this worked for me:

define x2 /  style(column)={htmlstyle="mso-number-format:\@"}
                 display right ;



Toby Dunn




From: Susa Ali-M?nk?re <a@MAILINATOR.COM>
Reply-To: Susa Ali-M?nk?re <a@MAILINATOR.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: how to right align numeric-character data
Date: Fri, 24 Jun 2005 08:02:31 -0700
how can the x2 variable be right aligned in the output?
the key is in the htmlstyle, but what is the format?

sample code:
data test;input x1 $16. x2 $2.;
cards;
0000100002000031 C
0000300003000041 8
0000300004000011 B
0000000000000001 1
;
run;
ods noptitle;
ods html file="%sysfunc(pathname(WORK))x_.xls" style=statdoc;
title;
proc report data=work.test headline headskip nowd;
column x1 x2 ;
define  x1 /
   style(column)={htmlstyle='mso-number-format:000000000000000'}
   display;
define x2 /
   style(column)={htmlstyle="mso-number-format:\@"}
   display;
run;
ods html close;