topic Re: Help to left-align row values in Proc Freq crosstab in SAS Enterprise Guide

Help to left-align row values in Proc Freq crosstab

Boka98 — Fri, 29 May 2015 09:43:31 GMT

When I make crosstabs by using Proc Freq, I get the following output:

How can I left-align the row values? (ie. Z038/39 and Z048)

I'm using SAS EG 5.1 32 bit.

Hope someone can help.

Thank you.

Re: Help to left-align row values in Proc Freq crosstab

Ksharp — Fri, 29 May 2015 12:54:49 GMT

How about this one :

data class;
 set sashelp.class;
 length _sex $ 40;
 _sex=catx(' ','~S={just=l}',sex);
run;



ods listing close;
ods pdf file='c:\temp\x.pdf';
ods escapechar='~';
proc freq data=class ;
table _sex*age/norow nocol nopercent nocum ;
run;
ods pdf close;
ods listing;

Xia Keshan

Re: Help to left-align row values in Proc Freq crosstab

Boka98 — Fri, 29 May 2015 13:27:32 GMT

Thank you for your answer.

It Works perfectly.

Great way to use the ODS Escape Char

Re: Help to left-align row values in Proc Freq crosstab

ballardw — Fri, 29 May 2015 14:44:19 GMT

Or slight modification:

proc format library=work;
value $sextemp
'F' = '~S={just=L}F'
'M' = '~S={just=L}M'
;
run;
quit;

ods escapechar='~';
proc freq data=class ;
table sex*age/norow nocol nopercent nocum ;
format sex $sextemp.;
run;