topic Re: Calculating Count and Percentage in SAS Programming

Calculating Count and Percentage

zimcom — Wed, 05 Feb 2020 22:29:26 GMT

Greeting community !!

I need to calculating the percentage with different denominator.

for variable A% - G%, the denominator is variable "All", so the computation is straight forwards.

But hwo should I calculate variable All%, which use the Total (sum of variable "All").

I hope I am clear. Can someone point me a direction.... Thanks !!!

	All	A	B	C	D	E	F	G	All%	A%	B%	C%	D%	E%	F%	G%
Z	356	69	36	19	69	15	59	89	356/1002	69/356	36/356	19/356	69/356	15/356	59/356	89/356
Y	371	32	7	90	87	29	47	79	371/1002
X	275	46	49	31	35	94	14	6	275/1002
Total	1002	##	15	83	33	96	60	93

Re: Calculating Count and Percentage

Patrick — Wed, 05 Feb 2020 23:51:43 GMT

One of the below two links might give you an idea:

https://support.sas.com/resources/papers/proceedings13/134-2013.pdf

https://communities.sas.com/t5/SAS-Programming/PROC-Tabulate-displaying-counts-and-percentages-with-multiple/td-p/319554

data have;
  input y $ x $;
  datalines;
X A
X A
X B
Y A
Y B
Y B
Y B
;

proc tabulate data=have noseps;
  class y x;
  table
    y all,
    (all x) (all x)*colpctn
  ;
run;

Re: Calculating Count and Percentage

ed_sas_member — Thu, 06 Feb 2020 09:02:30 GMT

Hi @zimcom

You can also simply use a proc freq. It depends whether you want to stick to the format of the output.

proc freq;
	table y*x;
run;