topic Re: How to apply a format in Proc Tabulate, like in Proc freq? in SAS Procedures

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

Sas_Geek — Thu, 24 Jan 2013 07:19:04 GMT

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 — Thu, 24 Jan 2013 07:48:17 GMT

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 — Thu, 24 Jan 2013 18:20:32 GMT

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 — Sat, 26 Jan 2013 12:34:25 GMT

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