How to apply a format in Proc Tabulate, like in Proc freq?

[Sas_Geek]

For example:

if we create a format:

proc format;

value quantityf

low - <0 = "Negative"

0 - 0 = "Zero"

1 - high = "Positive"

. = "Missing";

run;

we can easily apply it to proc freq procedure:

proc freq;

table quantity*group;

format quantity quantityf.;

run;

how to do the same with proc tabulate?

proc tabulate;

class quantity group;

tables quantity, group;

run;

[Jagadishkatam · Accepted solution]

Hi,

You need to use the format option in proc tabulate on then you will be able to apply the formats,

you can write

proc tabulate data=datasetname format=formatname;

class quantity group;

tables quantity, group;

format variablename format.;

run;

Thanks,

Jagadish

[ballardw]

For your classification variables you do it exactly the same as in your proc freq example.

Jagadish's example is an easy way to control a lot of summary statistics at once.

You can also override or provide specific formats for the summary statistics in a table statement:

Table classvariable,

         variable * (n*f=comma6.   mean*f=f6.2 stddev*f=3.1);

for example to provide counts in comma format, mean with 2 decimals and standard deviation with one decimal.

[Sas_Geek]

Thanks Jagadish and Ballardw! Exactly what I was looking for.