topic Re: Create a macro variable of the frequency of zeroes in SAS Programming

Create a macro variable of the frequency of zeroes

Xamius32 — Thu, 28 Feb 2013 20:51:46 GMT

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

Re: Create a macro variable of the frequency of zeroes

Reeza — Thu, 28 Feb 2013 20:56:23 GMT

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.

Re: Create a macro variable of the frequency of zeroes

Xamius32 — Thu, 28 Feb 2013 22:18:03 GMT

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

Re: Create a macro variable of the frequency of zeroes

Reeza — Thu, 28 Feb 2013 23:01:17 GMT

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;