Create a macro variable of the frequency of zeroes

[Xamius32]

    Im wondering if it is possible to create a macro variable that creates an output of the frequency of a certain number (zero in this case) using call symput etc.I know how I would do it to get a mean (proc means, then output, then a call symput) but dont know if it is possible for a frequency count

[Reeza · Accepted solution]

You can create a macro of anything...though should you is a different question

proc sql;

select count(var_interest) into :num_zero

from have

where var_interest=0;

quit;

Or you can run proc freq and then a data step or proc sql to create the macro variable.

[Xamius32]

Thanks, works great, is there an easy way I can change it from count to a percentage?

[Reeza]

How do you want to calculate the percent? # of 0/Total number? 

proc sql;

select sum(var_interest=0)/count(*) into :macro_variable

from have;

quit;