Help using Base SAS procedures

Proc tabulate issue

Reply
Occasional Contributor
Posts: 19

Proc tabulate issue

Hi Cynthia/ All


This is same report, Here is sub header B where there value is coming in a right alignment because in label it is numeric character and using proc format  I have changed the value into a printable character value. Now this character value is still coming in right alignment now I have to put in left alignment which is not going. I have tried to solve it but unable to do it. Please help me out how can i do it. Herewith i am sharing a data set with sas code, print screen of output and desired output.

output print screen.png

Attachment
Super User
Posts: 9,677

Re: Proc tabulate issue

Why not add a STYLE to get it ?

proc format;
value fmt
 0-60='xx'
 70-200='yy';
run;

ods listing close;
ods pdf file='c:\temp\x.pdf';
proc tabulate data=sashelp.class;
class sex age;
var weight height;
table sex,age*weight=''*format=fmt10.*{style={just=left}} ;
run;
ods pdf close;
ods listing;

Xia Keshan

Occasional Contributor
Posts: 19

Re: Proc tabulate issue

Hi,

my data set is there in gip file and already i have used a proc format and  tried to move the B column value in left align but stll it is not moving in left. Even you can try with my dataset and sas code.

Super User
Posts: 9,677

Re: Proc tabulate issue

I have no time to download your data . Post it at ODS and Base Reporting  Cynthia@sas might would do that .

Ask a Question
Discussion stats
  • 3 replies
  • 238 views
  • 0 likes
  • 2 in conversation