Formatting data from an ACROSS variable

[1162]

I'm creating a report using PROC REPORT. One of the report items is an ACROSS variable. I would like to format the report data for that variable, but I can't seem to figure out how. Using format in the DEFINE statement formats the variable itself, but not the resulting count data. Here's a very basic example:

[pre]
data tmp;
input category :$1. @@;
cards;
A B C A B A A
;
run;

proc report data=tmp nowindows;
columns category;
define category / across;
run;
[/pre]

For column 'A', the result is 4, but I'd like it to be formatted as 4.0. I tried adding 'format=8.1' to the DEFINE statement, but that doesn't work.

[Cynthia_sas]

Hi:
If you explicitly add N to the report layout, then you can format it.
cynthia
[pre]
ods html file='c:\temp\use_n.html' style=sasweb;
proc report data=tmp nowindows;
columns ('Category' category),n;
define category / across ' ';
define n / f=8.1 ' ';
run;
ods html close;

[/pre]

[1162]

Worked perfectly. Thanks.