topic Re: Formatting data from an ACROSS variable in ODS and Base Reporting

Formatting data from an ACROSS variable

1162 — Fri, 25 Jul 2008 16:44:17 GMT

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.

Re: Formatting data from an ACROSS variable

Cynthia_sas — Fri, 25 Jul 2008 19:05:40 GMT

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]

Re: Formatting data from an ACROSS variable

1162 — Fri, 25 Jul 2008 20:55:08 GMT

Worked perfectly. Thanks.