topic Re: Calculating count and percentage in SAS Programming

Calculating count and percentage

zimcom — Fri, 07 Feb 2020 15:41:58 GMT

Hi community,

I have where x is unique

x	y
118118	apple
118875	apple
176663	pear
166688	pear
716729	pear
118066	Other
121100	Other
122088	Other
170822	Other
166563	Orange
166569	Orange
176647	Orange
716696	Orange
166692	Orange
118036	Undetermined
119849	Undetermined
714821	Undetermined
160701	Undetermined
710769	Undetermined

I want

x	count	percent(%)
Orange	5	26.32
Other	4	21.05
Undeterm	5	26.32
apple	2	10.53
pear	3	15.79
Total	19	100

THANK you so much and have a great weekend!!!!

Re: Calculating count and percentage

PaigeMiller — Fri, 07 Feb 2020 15:43:38 GMT

This is a simple PROC FREQ

proc freq data=have;
     tables y;
run;

Re: Calculating count and percentage

ed_sas_member — Fri, 07 Feb 2020 15:56:46 GMT

Hi @zimcom

You can add the option OUT= in the PROC FREQ to output a dataset:

proc freq data=have;
	table y / out=want;
run;

Re: Calculating count and percentage

zimcom — Fri, 07 Feb 2020 15:57:15 GMT

could you please show me the code of how can I get the have.sas to want.sas?

THANK YOU!!!

Re: Calculating count and percentage

Cynthia_sas — Fri, 07 Feb 2020 15:59:05 GMT

Or a simple PROC TABULATE, to get the TOTAL line:
proc tabulate data=<yourdata>;
class y;
table y all='Total',
n pctn;
run;

Cynthia

Re: Calculating count and percentage

zimcom — Fri, 07 Feb 2020 15:59:44 GMT

Thank you all @Cynthia_sas @ed_sas_member @PaigeMiller

I really appreciated your help

Have a great weekend!!!