BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Sas_Geek
Calcite | Level 5

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadishkatam
Amethyst | Level 16

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

Thanks,
Jag

View solution in original post

3 REPLIES 3
Jagadishkatam
Amethyst | Level 16

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

Thanks,
Jag
ballardw
Super User

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
Calcite | Level 5

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1237 views
  • 5 likes
  • 3 in conversation