Go Back   Rhinocerus > Newsgroup > Newsgroup comp.soft-sys.sas

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 11-30-2009, 11:46 PM
SAS_learner
Guest
 
Posts: n/a
Default How to create a Picture Format ( is there better way )

Hello all,

In the final table I need all the 0's to be lined to left,I tried hard
coding spaces it is not working , I know it can be done using Picture format
but not sure how to move my final Zeros to left. Here small code how I am
trying to do ??

Is there a better to spaces in 95% ??

Data Final;
Retain Page Res_j Count Row Txt Sec Counter Inc _Label_ Text B_375 B_500
B_999;
Set All;
if Text = " Lower 95% CI Limit" and Count In(4,5,6)Then do ;
if Index(B_375,' 0' ) Then B_375 = ' ';
if Index(B_375, ' 0 ( 0)' ) Then B_375 = ' ';
End ;
if Text = " Upper 95% CI Limit" and Count In(4,5,6) Then do ;
if Index(B_375,' 0' ) Then B_375 = ' ';
if Index(B_375, ' 0 ( 0)' ) Then B_375 = ' ';
End ;
if Count In(4,5,6) and Txt = '2' Then Do;
If B_375 = ' ' Then B_375 = ' 0 ';
If Index(B_999,'0 ( 0)') Then B_999 = ' 0 ';
End;
Run;
*This Logic is not working *
Data Final;
set Final ;
if Index( B_375,'0' ) Then B_375 =Put(B_375 , 5. -l) ;
Run;
proc report data=Final split='|' headskip headline missing spacing=1;
columns Page Text (' Lum(mg/m^2)| __' B_375 B_500) B_999 ;

define B_375 / display "375 | (N=%cmpres(&C1.))" width=18
Right style(column)={asis=on};
run;

I had to Right align in Proc Report otherwise the header part is moving Left
and Remaining part is right Justified

thanks
SL
Reply With Quote
Alt Today
Advertising
 
and become member of Rhinocerus
Standard Sponsored Links

Reply

Popular Tags in the Forum
create, format, picture

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Help in reading data with a picture format Peter Crawford Newsgroup comp.soft-sys.sas 0 07-17-2007 12:23 PM
Re: Is there a way create a format catalog Platform Independent SAS_learner Newsgroup comp.soft-sys.sas 0 05-09-2006 10:45 PM
Re: Is there a way create a format catalog Platform Independent Peter Crawford Newsgroup comp.soft-sys.sas 0 05-09-2006 05:21 PM
Re: picture format Ian Whitlock Newsgroup comp.soft-sys.sas 0 01-20-2005 06:07 PM
Re: picture format Michael S. Zdeb Newsgroup comp.soft-sys.sas 0 01-20-2005 05:42 PM



All times are GMT. The time now is 03:11 AM.


Copyright ©2009

LinkBacks Enabled by vBSEO 3.3.0 RC2 © 2009, Crawlability, Inc.