topic Re: How to get sum of frequencies of non numeric variables? in Statistical Procedures

How to get sum of frequencies of non numeric variables?

momin — Tue, 28 Oct 2014 23:00:28 GMT

I created this file using the following code

proc freq data=b ;

table donor_relation/nocum nopercent out=how2;

run;

the question is how can I get the total sum of all frequencies at the bottom.Is there any other methodwhich I can use?

non

stat_sas — Wed, 29 Oct 2014 00:00:43 GMT

Proc tabulate can provide total of all frequencies at the bottom in addition to frequency of each level. Try this.

proc tabulate data=b;

class donor_relation;

table donor_relation all='Total',n='Frequency Count';

run;

arodriguez — Wed, 29 Oct 2014 07:27:09 GMT

I think that if you export the dataset adding the option out=nameoftheoutput it will create a table that have totals, something likev

VAR1 VAR2 Freq

...

lev1 ....

lev1 lev1 ....

... ... ...

where rows without levels is the total, rows with only a level in one of the variables is the sum of the row or column