topic Re: Proc Tabulate Percent in SAS Programming

Proc Tabulate Percent

Mick_bill — Tue, 02 Feb 2021 16:33:13 GMT

Hello,

I am trying to work out how to get a percentage within my proc tabulate for the sum of a variable within column, without having a column variable. I have tired the below code. Though this only produces the col % for the total population. Does any body know how to get it to produce the % for the Value.

proc tabulate data=book;
title 'Age band';
table Pet_Type ="Pet'', (n pctn Value colpctn<Value>);
class Pet_type /missing;
var Value;
run;

What this gives me is:

Total number falling within each band (N)

% for the t

total summed up value associated to the Pets

% for the col for total again.

I have shown two tables with the current vs what i wish to produce.

Current output

Pet N PctN Value ColPctN Value
a. Dog 80 30.65 15000 30.65
b. Cat 74 28.35 10000 28.35
c. Rodent 42 16.09 5000 16.09
d. Fish 55 21.07 8000 21.07
e. Other 10 3.83 1000 3.83

Expected Output

Pet N PctN Value ColPctN Val
a. Dog 80 30.65 15000 38.46
b. Cat 74 28.35 10000 25.64
c. Rodent 42 16.09 5000 12.82
d. Fish 55 21.07 8000 20.51
e. Other 10 3.83 1000 2.56

Is the expected output possible within an proc tabulate without a column header?

Thank you,

Re: Proc Tabulate Percent

Cynthia_sas — Tue, 02 Feb 2021 17:03:21 GMT

Hi:
Without your WORK.BOOK data, no one can run your code. Can you either post your data, post some test data, or rework your example using one of the SASHELP datasets? I think from what you describe that you need to switch to the PCTSUM statistic in the table. But I'm not entirely sure. Here's an example using N and PCTN and then SUM and PCTSUM for a numeric variable:

Cynthia

Re: Proc Tabulate Percent

ballardw — Tue, 02 Feb 2021 17:07:06 GMT

Without your starting data set there really isn't any way to see if what you want is practical in Proc Tabulate.

Proc tabulate to use a variable in a Pctn<var> will require the variable to be in the table somewhere, and pretty picky about where it can be.

Are you sure that you don't want colpctsum of Value?

proc tabulate data=book;
title 'Age band';
table Pet_Type ="Pet'', 
n pctn Value*sum=' '  value=' '*colpctsum=' ';
class Pet_type /missing;
var Value;
run;

You can use the variablename=' ' or statistic*' ' to provide a blank label

Re: Proc Tabulate Percent

Mick_bill — Tue, 02 Feb 2021 17:08:49 GMT

thank you, this is perfect.