How to make specific percentage in pro tabulate

[bemariec]

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!

[Reeza]

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

[bemariec · Accepted solution]

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!

[Reeza]

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?