Count number of 0 values

Question

Similar to here, I can count the number of missing observations:

data dataset;
  input a b c;
cards;
1 2 3
0 1 0
0 0 0
7 6 .
. 3 0
0 0 .
;
run;

proc means data=dataset NMISS N;
run;

But how can I also count the number of observations that are 0?

Answer 1

If you want to count the number of observations that are 0, you'd want to use proc tabulate or proc freq, and do a frequency count.

If you have a lot of values and you just want "0/not 0", that's easy to do with a format.

data have;
  input a b c;
cards;
1 2 3
0 1 0
0 0 0
7 6 .
. 3 0
0 0 .
;
run;

proc format;
  value zerof
  0='Zero'
  .='Missing'
  other='Not Zero';
quit;

proc freq data=have;
  format _numeric_ zerof.;
  tables _numeric_/missing;
run;

Something along those lines. Obviously be careful about _numeric_ as that's all numeric variables and could get messy quickly if you have a lot of them...