topic Count and Percentage? in SAS Programming

Count and Percentage?

ybz12003 — Tue, 04 Dec 2018 19:18:00 GMT

Hello:

I would like to calculate the counts in Column 'A' where the number is '1' or '0' separately? And the percentage where '1' over '0', and '1' over _all_.

DATA TEST;
	INPUT id agree;
	datalines; 
	1 1
	2 1
	3 0
	4 1
	5 0
	6 1
	7 0
	8 0
	9 0
	10 0
	;
run;

The result I am looking for is:

Yes: 4

Yes percentage: 40%

No: 6

No percentage:60%

Re: Count and Percentage?

novinosrin — Tue, 04 Dec 2018 19:34:58 GMT


DATA TEST;
	INPUT id agree;
	datalines; 
	1 1
	2 1
	3 0
	4 1
	5 0
	6 1
	7 0
	8 0
	9 0
	10 0
	;
run;


proc sql;
create table want as
select agree, count(agree)/(select count(*) from test)*100 as c
from test
group by agree;
quit;

Re: Count and Percentage?

novinosrin — Tue, 04 Dec 2018 19:37:42 GMT

With percent format

proc sql;
create table want as
select agree, count(agree)/(select count(*) from test) as c format=percent.
from test
group by agree;
quit;

Re: Count and Percentage?

ballardw — Tue, 04 Dec 2018 19:53:17 GMT

And a Proc Tabulate solution

proc tabulate data=test;
   class agree;
   table agree,
         n colpctn;
run;

if people are to read the result and a data set not needed.