Help using Base SAS procedures

How to make specific percentage in pro tabulate

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

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: 14

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!

View solution in original post


All Replies
Super User
Posts: 18,588

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: 14

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: 18,588

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.

Need further help from the community? Please ask a new question.

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