topic Re: calculate and display percentages in SAS Programming

calculate and display percentages

prolifious — Mon, 04 Jun 2018 18:06:44 GMT

I'm pretty far along into a report. Right now I have a data set that looks like this (not real data, i understand column 2 and 3 are not sorted, but it is in my program):

friend	treats	count
bird	pop	3
bird	eggs	134
bird	fish	12
cat	ham	8
cat	soda	12
dog	meat	3
dog	eggs	4
dog	fish	1
dog	cereal	1
dog	candy	1

And I'm trying to get an output of this:

friend	treats	count	percentage
bird	pop	3	2%
bird	eggs	134	90%
bird	fish	12	8%
cat	ham	8	40%
cat	soda	12	60%
dog	meat	3	30%
dog	eggs	4	40%
dog	fish	1	10%
dog	cereal	1	10%
dog	candy	1	10%

I'd post code that i have which attempts to do this, but suffice it to say, it's not worth sharing. Any thoughts or ideas are much appreciated. thank you.

Re: calculate and display percentages

novinosrin — Mon, 04 Jun 2018 18:19:18 GMT

data have;
input friend $	treats $	count;
cards;
bird	pop	3
bird	eggs	134
bird	fish	12
cat	ham	8
cat	soda	12
dog	meat	3
dog	eggs	4
dog	fish	1
dog	cereal	1
dog	candy	1
;

proc sql;
create table want as
select *, count/sum(count)  as pct format=percent10.
from have
group by friend;
quit;

Re: calculate and display percentages

prolifious — Mon, 04 Jun 2018 18:32:17 GMT

This is the first I'll be using PROC SQL...thank you very much!!

Re: calculate and display percentages

novinosrin — Mon, 04 Jun 2018 18:33:07 GMT

@prolifious You are welcome. Yes proc SQL is super cool 🙂

Re: calculate and display percentages

ballardw — Mon, 04 Jun 2018 20:24:58 GMT

And one of the other report procedures:

proc tabulate data=have;
   class friend treats;
   freq count;
   table friend*treats,
         n='Count'  pctn<treats>='Percentage' *f=percent8.0
         ;
run;

if you do not actually need a data set