The SAS Output Delivery System and reporting techniques

Formatting data from an ACROSS variable

Reply
Frequent Contributor
Posts: 95

Formatting data from an ACROSS variable

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.
SAS Super FREQ
Posts: 8,743

Re: Formatting data from an ACROSS variable

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]
Frequent Contributor
Posts: 95

Re: Formatting data from an ACROSS variable

Worked perfectly. Thanks.
Ask a Question
Discussion stats
  • 2 replies
  • 128 views
  • 0 likes
  • 2 in conversation