How to make specific percentage in pro tabulate

Solved
Occasional Contributor
Posts: 19

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!

Accepted Solutions
Solution
‎08-23-2017 02:24 PM
Occasional Contributor
Posts: 19

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!

All Replies
Super User
Posts: 23,754

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

Solution
‎08-23-2017 02:24 PM
Occasional Contributor
Posts: 19

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
Posts: 23,754

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?

☑ This topic is solved.

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