Obsidian | Level 7

## How to make specific percentage in pro tabulate

Hi!

I would like to be able to add a column in my table (see the picture joined) made by proc tabulate where I can put a new column with the result of 'n_insuffisant / indic', in percent... for example,

Indic     n_insuffisant   new_column

an         caracteritistique    c

2012     PourBitume          EC-10      55              21                  21/55%

EG-10      9                2                    2/9%

...           ...                ...                    ...

thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Obsidian | Level 7

## Re: How to make specific percentage in pro tabulate

Hi!

When a try the example like this:

proc tabulate data=nombre_observations_table;

class an caracteristique c;

var n_insuffisant indic;

table an*caracteristique*c,(indic n_insuffisant n_insuffisant*rowpctsum);

run;

the rowpctsum is full of 100... only 100... I don't get where the f comes from in your example (colpctsum*f=...)

thanks!

3 REPLIES 3
Super User

## Re: How to make specific percentage in pro tabulate

You want the 'row percent'.

See the examples in the documentation:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a001253001.htm

Obsidian | Level 7

## Re: How to make specific percentage in pro tabulate

Hi!

When a try the example like this:

proc tabulate data=nombre_observations_table;

class an caracteristique c;

var n_insuffisant indic;

table an*caracteristique*c,(indic n_insuffisant n_insuffisant*rowpctsum);

run;

the rowpctsum is full of 100... only 100... I don't get where the f comes from in your example (colpctsum*f=...)

thanks!

Super User

## Re: How to make specific percentage in pro tabulate

The F is for FORMAT.

Without a sample of your data, your code isn't easy to decipher. Can you use SASHELP.CLASS or SASHELP.CARS instead?

Discussion stats
• 3 replies
• 756 views
• 0 likes
• 2 in conversation