## Create a macro variable of the frequency of zeroes

Solved
Frequent Contributor
Posts: 82

# Create a macro variable of the frequency of zeroes

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

Accepted Solutions
Solution
‎02-28-2013 03:56 PM
Super User
Posts: 23,791

## Re: Create a macro variable of the frequency of zeroes

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.

All Replies
Solution
‎02-28-2013 03:56 PM
Super User
Posts: 23,791

## Re: Create a macro variable of the frequency of zeroes

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.

Frequent Contributor
Posts: 82

## Re: Create a macro variable of the frequency of zeroes

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

Super User
Posts: 23,791

## Re: Create a macro variable of the frequency of zeroes

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;

🔒 This topic is solved and locked.