Counting non missing with proc freq; remove zeros from 'not missing'

[Satori]

I am doing a proc freq to count the number of missing and not missing per variable:

My code:

proc format; value $missfmt ' '='Missing' other='Not Missing'; value missfmt . ='Missing' other='Not Missing';
proc freq data=have; format _NUMERIC_ missfmt.; tables _NUMERIC_ / missing missprint nocum;

What I get is a table for each variable (only one variable - sales - is shown below)

The FREQ Procedure

Sales Frequency Percent
------------------------------------
Missing 10153881 47.32
Not Missing 11304829 52.68

What I want is to make sure that the observations that are zero are counted as 'missing' or other class but not as 'not missing'. How can I do this?

[PaigeMiller · Accepted solution]

---

@Satori wrote:

What I want is to make sure that the observations that are zero are counted as 'missing' or other class but not as 'not missing'. How can I do this?

---

Modify your format to include 0 as missing.

proc format;
    value missfmt .,0 ='Missing' other='Not Missing';
run;

From now on, please include your SAS code in a code box, as I did above, by clicking on the "little running man" icon and then pasting your code into the window that appears.

[WeiChen]

Zero frequency is not missing frequency. Missing frequency menas you do not know how many times a value is observed. Zero frequency means you do know that it was observed zero times.