percentage Caluculation

[cm3]

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

[novinosrin]

Do you want the output as dataset or report?

[cm3]

I’ve input dataset with more than 1000 records

can you suggest with both options, if possible 

thank you

[PGStats]

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;

[cm3]

Thank you very much

Can I use any proc procedure for this ?

[PGStats]

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 ...

[cm3]

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

[cm3]

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

[learsaas]

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;

[ballardw]

---

@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.