topic percentage Caluculation in SAS Programming

percentage Caluculation

cm3 — Thu, 27 Dec 2018 21:59:59 GMT

I’ve data like below

accno. Var1 var2 var3

111. Y. Y. N

112. Y. Y. Y

113. N. Y. Y

114. Y. N N

115. Y. Y. Y

116. Y. Y. Y

117. Y. Y. N

118. Y. Y. Y

119. Y. Y. Y

120. N. Y. Y

i need output as below by considering only Y values for Var1,...

tot. %var1. %var2. %var3

10. 80. 90. 70

please advise. Thank you

Re: percentage Caluculation

novinosrin — Thu, 27 Dec 2018 22:08:22 GMT

Do you want the output as dataset or report?

Re: percentage Caluculation

cm3 — Thu, 27 Dec 2018 22:41:54 GMT

I’ve input dataset with more than 1000 records

can you suggest with both options, if possible

thank you

Re: percentage Caluculation

PGStats — Thu, 27 Dec 2018 22:42:21 GMT

With SQL

proc sql;
select 
    count(*) as tot,
    sum(var1="Y")/count(var1) as pctVar1 label="%Var1" format=percent7.0,    
    sum(var2="Y")/count(var2) as pctVar2 label="%Var2" format=percent7.0,    
    sum(var3="Y")/count(var3) as pctVar3 label="%Var3" format=percent7.0
from have;
quit;

Re: percentage Caluculation

cm3 — Thu, 27 Dec 2018 22:50:05 GMT

Thank you very much

Can I use any proc procedure for this ?

Re: percentage Caluculation

PGStats — Thu, 27 Dec 2018 22:55:20 GMT

The procedure is proc SQL. If you want to create a new dataset instead of displaying the results, add

create table want as

just before select ...

Re: percentage Caluculation

cm3 — Thu, 27 Dec 2018 23:21:47 GMT

I need single observation as output, but above proc sql giving output with all my 1000 above observations.....

Re: percentage Caluculation

cm3 — Fri, 28 Dec 2018 01:03:29 GMT

Can you pls help to get as single observation output, thank you

Re: percentage Caluculation

learsaas — Fri, 28 Dec 2018 03:15:08 GMT

data  result;
	set a end=last;
	array array_Var Var1-Var3;
	length tot 8;
	array array_Per Per1-Per3;
	if _n_=1 then do over array_Var;
		array_Per=0;
	end;
	do over array_Var;
		if array_Var='Y' then array_Per+1;
	end;
	if last then do;
		tot=_n_;
		do over array_Var;
			array_Per=round(array_Per/tot*100,1);
		end;
		output;
	end;
	keep tot Per1-Per3;
run;

Re: percentage Caluculation

ballardw — Mon, 31 Dec 2018 17:18:57 GMT

@cm3 wrote:

Hi

I’ve data like below

accno. Var1 var2 var3

111. Y. Y. N

112. Y. Y. Y

113. N. Y. Y

114. Y. N N

115. Y. Y. Y

116. Y. Y. Y

117. Y. Y. N

118. Y. Y. Y

119. Y. Y. Y

120. N. Y. Y

i need output as below by considering only Y values for Var1,...

tot. %var1. %var2. %var3

10. 80. 90. 70

please advise. Thank you

Are the values "Y" or "Y." That is two different values. Similar with "N." and "N". So do you want percent of "Y" or "Y."?

I you use 1/0 numeric coding instead of Y/N character coding (or read external data of Y/N into 1/0) this becomes a trivial exercise.

The SUM of 1/0 codes values becomes the number of 1 (or Yes or Y or True or what have you responses) and the mean is a percentage.