topic How to make specific percentage in pro tabulate in SAS Procedures

How to make specific percentage in pro tabulate

bemariec — Wed, 23 Aug 2017 17:58:20 GMT

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!

Re: How to make specific percentage in pro tabulate

Reeza — Wed, 23 Aug 2017 18:01:45 GMT

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

Re: How to make specific percentage in pro tabulate

bemariec — Wed, 23 Aug 2017 18:18:35 GMT

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!

Re: How to make specific percentage in pro tabulate

Reeza — Wed, 23 Aug 2017 18:23:50 GMT

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?