Count and Percentage?

[ybz12003]

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%

[novinosrin]

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;

[novinosrin]

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;

[ballardw · Accepted solution]

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.