DATA Step, Macro, Functions and more

Create a macro variable of the frequency of zeroes

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 82
Accepted Solution

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: 19,770

Re: Create a macro variable of the frequency of zeroes

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

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.

View solution in original post


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

Re: Create a macro variable of the frequency of zeroes

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

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: 19,770

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 172 views
  • 3 likes
  • 2 in conversation