topic Re: Proc tabulate issue in SAS Procedures

Proc tabulate issue

ameey — Tue, 21 Apr 2015 09:37:59 GMT

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.

Re: Proc tabulate issue

Ksharp — Tue, 21 Apr 2015 12:44:51 GMT

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

Re: Proc tabulate issue

ameey — Thu, 23 Apr 2015 09:50:08 GMT

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.

Re: Proc tabulate issue

Ksharp — Thu, 23 Apr 2015 12:01:51 GMT

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